Introduction to Databases for Back-End Development

Introduction to Databases for Back-End Development

This course is part of multiple programs.

Instructor: Taught by Meta Experts

Access provided by Veriff

55,203 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

674 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.

674 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

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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 videos Total 47 minutes

Introduction to databases 4 minutes
A day in the Life of a Database Engineer 6 minutes
What is a database? 6 minutes
How is data related? 4 minutes
Alternative types of databases 5 minutes
What is Structured Query Language? 2 minutes
SQL usage 4 minutes
Advantages of SQL 3 minutes
SQL syntax introduction 5 minutes
What are tables in databases? 4 minutes
Types of keys in a database table 4 minutes
Module summary: Introduction to Databases 2 minutes

10 readings Total 120 minutes

Course syllabus: Introduction to databases 10 minutes
How to be successful in this course 10 minutes
Relational data example charts 10 minutes
Database Evolution 15 minutes
Additional resources 10 minutes
Common SQL Commands 15 minutes
Additional resources 10 minutes
Tables overview 15 minutes
Database structure overview 15 minutes
Additional resources 10 minutes

4 assignments Total 75 minutes

Module quiz: Introduction to Databases 30 minutes
Knowledge check: Databases and data 15 minutes
Knowledge check: SQL syntax review 15 minutes
Knowledge check: Database structure 15 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 videos Total 42 minutes

Numeric data types 3 minutes
String data types 4 minutes
Default values 4 minutes
CREATE and DROP database 3 minutes
CREATE TABLE statement 2 minutes
ALTER TABLE statement 4 minutes
INSERT statement 5 minutes
SELECT statement 4 minutes
INSERT INTO SELECT statement 3 minutes
Updating data 4 minutes
Deleting data 3 minutes
Module summary: Create, Read, Update and Delete (CRUD) Operations 3 minutes

4 readings Total 45 minutes

Additional resources 15 minutes
Creating tables 15 minutes
Additional resources 10 minutes
Additional resources 5 minutes

10 assignments Total 156 minutes

Module quiz: Create, Read, Update and Delete (CRUD) Operations 30 minutes
Self review: Working with numbers 15 minutes
Self review: Working with strings 12 minutes
Self review: Working with default values 12 minutes
Self review: Choosing the right data type for a column 15 minutes
Self-review: Create database, create table and insert data 15 minutes
Self review: Practicing table creation 15 minutes
Knowledge check: Create, insert and select 15 minutes
Self-review: Record deletion 12 minutes
Knowledge check: Update and Delete 15 minutes

7 ungraded labs Total 420 minutes

Exercise: Working with numbers 60 minutes
Exercise: Working with strings 60 minutes
Working with default values 60 minutes
Choosing the right data type for a column 60 minutes
Exercise: Create Database, create table and insert data 60 minutes
Exercise: Practicing table creation 60 minutes
Exercise: Record deletion 60 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 videos Total 34 minutes

SQL Arithmetic Operators 4 minutes
Operators in use 5 minutes
SQL Comparison operators 6 minutes
ORDER BY clause 5 minutes
WHERE clause 8 minutes
SELECT DISTINCT clause 4 minutes
Module summary: SQL operators and sorting and filtering data 2 minutes

7 readings Total 155 minutes

SQL Arithmetic Operator Examples 30 minutes
SQL Comparison operator examples 30 minutes
Additional resources 10 minutes
Types of ordering / sorting 30 minutes
WHERE Clause uses 30 minutes
SELECT DISTINCT clause in use 15 minutes
Additional resources 10 minutes

3 assignments Total 72 minutes

Module quiz: SQL operators and sorting and filtering data 30 minutes
Knowledge Check: Operators 30 minutes
Self-review: ORDER BY and WHERE 12 minutes

1 ungraded lab Total 60 minutes

ORDER BY and WHERE 60 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 videos Total 48 minutes

Database schema 3 minutes
Schema in use 5 minutes
Types of database schema 3 minutes
Table relationships 4 minutes
Primary key 3 minutes
Foreign key 5 minutes
Finding entitites 3 minutes
What is database normalization? 5 minutes
First normal form 1NF 4 minutes
Second normal form 2NF 6 minutes
Third normal form 3NF 4 minutes
Module summary: Database design 2 minutes

9 readings Total 140 minutes

Exploring database schema 15 minutes
Building a schema 15 minutes
Additional resources 10 minutes
Relational model 15 minutes
Keys in depth 15 minutes
Entity relationship diagrams (ERD) 30 minutes
Additional resources 15 minutes
Data normalization 15 minutes
Additional resources 10 minutes

6 assignments Total 96 minutes

Module quiz: Database design 24 minutes
Knowledge check: Database schema 15 minutes
Knowledge check: Defining keys 15 minutes
Database relations and keys 15 minutes
Knowledge Check: Database normalization 12 minutes
Self-review: Database schema examples 15 minutes

1 ungraded lab Total 60 minutes

Database schema examples 60 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 videos Total 5 minutes

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

2 readings Total 13 minutes

About the final graded quiz assessment 3 minutes
Next steps after Introduction to Databases 10 minutes

1 assignment Total 30 minutes

Final graded quiz: Intro to databases 30 minutes

1 discussion prompt Total 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

(150 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.14%
4 stars
19.43%
3 stars
5.19%
2 stars
1.03%
1 star
1.18%

Showing 3 of 674

Reviewed on Jun 21, 2023

An excellent explanation along with good hands-on experience. I will recommend if anyone wants to learn SQL this is the right course for you.

Reviewed on Dec 4, 2022

It is amazing course to start with databasesbut there are two problems at assignments there is questions about the next videos and there is a problem at using online vscode sandbox of the course

Reviewed on Aug 27, 2023

I thought the topics of database were covered well. I also like being able to practice the SQL so often. I learned I really like SQL and database concepts.

View more reviews