Introduction to Databases

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Staff

What you'll learn

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

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

1 quiz, 23 assignments

Taught in English

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

Learn more about Coursera for Business

Build your Data Management expertise

This course is part of the Meta Database Engineer Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

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 from Meta

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 5 modules in this course

In this course, you will be introduced to databases and explore the modern ways in which they are used. Learn to distinguish between different types of database management systems then practice basic creation and data selection 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 • MySQL software • 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

13 videos10 readings4 assignments1 discussion prompt

13 videosTotal 49 minutes

Introduction to the program2 minutesPreview module
Introduction to databases3 minutes
A day in the Life of a Database Engineer6 minutes
What is a database?5 minutes
How is data related?3 minutes
Alternative types of databases4 minutes
What is Structured Query Language?2 minutes
SQL usage3 minutes
Advantages of SQL2 minutes
SQL syntax introduction4 minutes
What are tables in databases?3 minutes
Types of keys in a database table3 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

1 discussion promptTotal 10 minutes

What do you hope to learn?10 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 readings1 quiz9 assignments7 ungraded labs

12 videosTotal 41 minutes

Numeric data types3 minutesPreview module
String data types3 minutes
Default values4 minutes
CREATE and DROP database2 minutes
CREATE TABLE statement2 minutes
ALTER TABLE statement3 minutes
INSERT statement4 minutes
SELECT statement3 minutes
INSERT INTO SELECT statement3 minutes
Updating data3 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

1 quizTotal 12 minutes

Self-review: Record deletion12 minutes

9 assignmentsTotal 144 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
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 minutesPreview module
Operators in use4 minutes
SQL Comparison operators5 minutes
ORDER BY clause5 minutes
WHERE clause7 minutes
SELECT DISTINCT clause4 minutes
Module summary: SQL operators and sorting and filtering data1 minute

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: Operators30 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 47 minutes

Database schema3 minutesPreview module
Schema in use4 minutes
Types of database schema2 minutes
Table relationships3 minutes
Primary key2 minutes
Foreign key4 minutes
Finding entitites3 minutes
What is database normalization?4 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.