Introduction to Databases for Back-End Development

4 days left! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Introduction to Databases for Back-End Development

This course is part of multiple programs.

Instructor: Taught by Meta Experts

56,901 already enrolled

Included with

5 modules

Gain insight into a topic and learn the fundamentals.

680 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

95%

Most learners liked this course

5 modules

Gain insight into a topic and learn the fundamentals.

680 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

95%

Most learners liked this course

What you'll learn

Concepts and principles that underpin how databases work.
Plan and execute a simple database development project.

Skills you'll gain

Category: Data Integrity
Category: Database Management
Category: Database Administration
Category: Database Design
Category: Databases
Category: Back-End Web Development
Category: Data Store
Category: SQL
Category: Database Theory

Tools you'll learn

Category: Relational Databases
Category: MySQL
Category: Query Languages
Category: Database Management Systems
Category: NoSQL

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments

Taught in English

91% of learners achieved a positive career outcome

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 5 modules in this course

Back-end developers write applications that end-users use to interact with databases. Some common tasks that end-users carry out using these applications include storing, searching, extracting and manipulating data.

Therefore, it’s essential that all back-end developers possess strong knowledge and experience with how databases work. In this course, you’ll receive an introduction to databases and explore the different ways in which they can be used to store and manage data. You’ll also learn to distinguish between different types of database management systems. You’ll then practice basic creation and data selection tasks with the use of Structured Query Language (SQL) commands. By the end of this course, you’ll be able to: - Demonstrate a working knowledge of the concepts and principles that underpin how databases work - Identify and explain the different types of core technology and management systems used in databases - Identify and interpret basic SQL statements and commands - Manipulate records in a database with the use of SQL statements and commands - Outline alternatives to SQL - and plan and design a simple relational database system You’ll also gain experience with the following: - Fundamental concepts in database - Basic MySQL syntax and commands - Database management systems - Relational databases

In this module, you’ll receive an introduction to the course and explore possible career roles that you could follow as a database engineer. You’ll also review some tips on how to take this course successfully and discuss what it is that you hope to learn. As part of your introduction, you’ll learn about the basics of databases and data and how they work. You’ll then receive an introduction to SQL, or Standard Query Language, the coding syntax used to interact with databases. Finally, you’ll explore the basic structure of databases and discover the different types of keys they use.

What's included

12 videos10 readings4 assignments

12 videosTotal 47 minutes

Introduction to databases4 minutes
A day in the Life of a Database Engineer6 minutes
What is a database?6 minutes
How is data related?4 minutes
Alternative types of databases5 minutes
What is Structured Query Language?2 minutes
SQL usage4 minutes
Advantages of SQL3 minutes
SQL syntax introduction5 minutes
What are tables in databases?4 minutes
Types of keys in a database table4 minutes
Module summary: Introduction to Databases2 minutes

10 readingsTotal 120 minutes

Course syllabus: Introduction to databases10 minutes
How to be successful in this course10 minutes
Relational data example charts10 minutes
Database Evolution15 minutes
Additional resources10 minutes
Common SQL Commands15 minutes
Additional resources10 minutes
Tables overview15 minutes
Database structure overview15 minutes
Additional resources10 minutes

4 assignmentsTotal 75 minutes

Knowledge check: Databases and data15 minutes
Knowledge check: SQL syntax review15 minutes
Knowledge check: Database structure15 minutes
Module quiz: Introduction to Databases30 minutes

In this module, you’ll explore CRUD, or Create, Read Update and Delete operations. You’ll begin with an exploration of SQL data types and learn how to differentiate between numeric data, string data and default values. You’ll also embark upon several exercises in which you’ll learn how to utilize these different data types within your database projects. You’ll then move on to learn how to Create and Read data within a database. You’ll discover how to create databases and tables and populate them with data using SQL statements. Lastly, you’ll explore the SQL statements used for updating and deleting data in a database. And to demonstrate your ability with CRUD operations, you’ll complete exercises that will task you with creating and managing data.

What's included

12 videos4 readings10 assignments7 ungraded labs

12 videosTotal 42 minutes

Numeric data types3 minutes
String data types4 minutes
Default values4 minutes
CREATE and DROP database3 minutes
CREATE TABLE statement2 minutes
ALTER TABLE statement4 minutes
INSERT statement5 minutes
SELECT statement4 minutes
INSERT INTO SELECT statement3 minutes
Updating data4 minutes
Deleting data3 minutes
Module summary: Create, Read, Update and Delete (CRUD) Operations3 minutes

4 readingsTotal 45 minutes

Additional resources15 minutes
Creating tables15 minutes
Additional resources10 minutes
Additional resources5 minutes

10 assignmentsTotal 156 minutes

Self review: Working with numbers15 minutes
Self review: Working with strings12 minutes
Self review: Working with default values12 minutes
Self review: Choosing the right data type for a column15 minutes
Self-review: Create database, create table and insert data15 minutes
Self review: Practicing table creation15 minutes
Knowledge check: Create, insert and select15 minutes
Self-review: Record deletion 12 minutes
Knowledge check: Update and Delete15 minutes
Module quiz: Create, Read, Update and Delete (CRUD) Operations30 minutes

7 ungraded labsTotal 420 minutes

Exercise: Working with numbers60 minutes
Exercise: Working with strings60 minutes
Working with default values 60 minutes
Choosing the right data type for a column 60 minutes
Exercise: Create Database, create table and insert data60 minutes
Exercise: Practicing table creation60 minutes
Exercise: Record deletion60 minutes

In this module, you’ll explore SQL operators and learn how to sort and filter data. You’ll begin this module with a lesson on SQL operators. As part of this first lesson, you’ll explore the syntax and process steps used to deploy SQL arithmetic and comparison operators within a database. Next, you’ll discover how to sort and filter data using clauses. The clauses that you’ll learn about include the Order By clause, Where clause and Select Distinct clause. In each lesson item, you’ll receive an overview of how each clause is used to sort and filter data in a database. You’ll also view demonstrations of these clauses and then receive an opportunity to try them for yourself.

What's included

7 videos7 readings3 assignments1 ungraded lab

7 videosTotal 34 minutes

SQL Arithmetic Operators4 minutes
Operators in use5 minutes
SQL Comparison operators6 minutes
ORDER BY clause5 minutes
WHERE clause8 minutes
SELECT DISTINCT clause4 minutes
Module summary: SQL operators and sorting and filtering data2 minutes

7 readingsTotal 155 minutes

SQL Arithmetic Operator Examples30 minutes
SQL Comparison operator examples30 minutes
Additional resources10 minutes
Types of ordering / sorting30 minutes
WHERE Clause uses30 minutes
SELECT DISTINCT clause in use15 minutes
Additional resources10 minutes

3 assignmentsTotal 72 minutes

Knowledge Check: Operators 30 minutes
Self-review: ORDER BY and WHERE12 minutes
Module quiz: SQL operators and sorting and filtering data30 minutes

1 ungraded labTotal 60 minutes

ORDER BY and WHERE60 minutes

In this module, you’ll learn about database design. In the first lesson, you’ll receive an overview of how to design a database schema. As part of this overview, you’ll learn about basic database design concepts like schema and find out about different types of schemas. The next lesson focuses on relational database design. In this lesson, you’ll explore how to establish relationships between tables in a database using keys. You’ll also learn about the different types of keys that are used in relational database design, such as primary keys and foreign keys.

What's included

12 videos9 readings6 assignments1 ungraded lab

12 videosTotal 48 minutes

Database schema3 minutes
Schema in use5 minutes
Types of database schema3 minutes
Table relationships4 minutes
Primary key3 minutes
Foreign key5 minutes
Finding entitites3 minutes
What is database normalization?5 minutes
First normal form 1NF4 minutes
Second normal form 2NF6 minutes
Third normal form 3NF4 minutes
Module summary: Database design2 minutes

9 readingsTotal 140 minutes

Exploring database schema15 minutes
Building a schema15 minutes
Additional resources10 minutes
Relational model15 minutes
Keys in depth15 minutes
Entity relationship diagrams (ERD)30 minutes
Additional resources15 minutes
Data normalization15 minutes
Additional resources10 minutes

6 assignmentsTotal 96 minutes

Knowledge check: Database schema15 minutes
Knowledge check: Defining keys15 minutes
Database relations and keys15 minutes
Knowledge Check: Database normalization12 minutes
Self-review: Database schema examples15 minutes
Module quiz: Database design24 minutes

1 ungraded labTotal 60 minutes

Database schema examples60 minutes

In this module, you’ll have an opportunity to recap what you learned and identify your strengths as well as target topics that you would like to revisit in this course.

What's included

2 videos2 readings1 assignment1 discussion prompt

2 videosTotal 5 minutes

Course Recap: Introduction to databases for back-end development3 minutes
Congratulations, you have completed Intro to databases for back-end development!2 minutes

2 readingsTotal 13 minutes

About the final graded quiz assessment3 minutes
Next steps after Introduction to Databases10 minutes

1 assignmentTotal 30 minutes

Final graded quiz: Intro to databases 30 minutes

1 discussion promptTotal 10 minutes

What are your thoughts on working with databases?10 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(151 ratings)

Taught by Meta Experts

Offered by

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
73.27%
4 stars
19.23%
3 stars
5.13%
2 stars
1.17%
1 star
1.17%

Showing 3 of 680

Reviewed on Oct 9, 2022

They do not teach Databases and SQL anywhere like here. Meta sure does Software Engineering very differently. If you want to be the best, I guess you ought to learn from the best.

Reviewed on Dec 15, 2022

It was a informative and precise course with sufficient labs to get hands on. I found Normalization is pretty tricky to implement. More detailed readings shall help me improve and gain confidence.

Reviewed on Oct 19, 2022

This cours is overall a good course to resfresh or learn the basis of SQL, but the tests could be better, especially the last one (it has a lot of formatting problems).

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.