This course is part of the Meta Database Engineer Professional Certificate

4.7
stars
333 ratings

Taught by Meta Staff

19,578 already enrolled

Offered By

Meta Database Engineer Professional CertificateMeta

About this Course

232,649 recent views

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

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 9 in the

Meta Database Engineer Professional Certificate

Beginner Level

You do not need prior database experience. Only basic internet navigation skills and an eagerness to get started with coding.

Approx. 27 hours to complete

English

What you will learn

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

Skills you will gain

Database (DBMS)
MySQL
database administration

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 9 in the

Meta Database Engineer Professional Certificate

Beginner Level

You do not need prior database experience. Only basic internet navigation skills and an eagerness to get started with coding.

Approx. 27 hours to complete

English

Instructor

Instructor rating

4.91/5 (125 Ratings)

Taught by Meta Staff

233,902 Learners

49 Courses

Offered by

Syllabus - What you will learn from this course

Content Rating95%(4,043 ratings)

Week

Week 1

4 hours to complete

Introduction to 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.

4 hours to complete

13 videos (Total 50 min), 10 readings, 4 quizzes

13 videos

Introduction to the program2m

Introduction to databases3m

A day in the Life of a Database Engineer6m

What is a database?5m

How is data related?3m

Alternative types of databases4m

What is Structured Query Language?2m

SQL usage3m

Advantages of SQL2m

SQL syntax introduction4m

What are tables in databases?3m

Types of keys in a database table3m

Module summary: Introduction to Databases2m

10 readings

Course syllabus: Introduction to databases10m

How to be successful in this course10m

Relational data example charts10m

Database Evolution15m

Additional resources10m

Common SQL Commands15m

Additional resources10m

Tables overview15m

Database structure overview15m

Additional resources10m

4 practice exercises

Knowledge check: Databases and data15m

Knowledge check: SQL syntax review15m

Knowledge check: Database structure15m

Module quiz: Introduction to Databases30m

Week

Week 2

11 hours to complete

Create, Read, Update and Delete (CRUD) Operations

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.

11 hours to complete

12 videos (Total 42 min), 4 readings, 10 quizzes

12 videos

Numeric data types3m

String data types3m

Default values4m

CREATE and DROP database2m

CREATE TABLE statement2m

ALTER TABLE statement3m

INSERT statement4m

SELECT statement3m

INSERT INTO SELECT statement3m

Updating data3m

Deleting data3m

Module summary: Create, Read, Update and Delete (CRUD) Operations3m

4 readings

Additional resources15m

Creating tables15m

Additional resources10m

Additional resources5m

10 practice exercises

Self review: Working with numbers15m

Self review: Working with strings12m

Self review: Working with default values12m

Self review: Choosing the right data type for a column15m

Self-review: Create database, create table and insert data15m

Self review: Practicing table creation15m

Knowledge check: Create, insert and select15m

Self-review: Record deletion12m

Knowledge check: Update and Delete15m

Module quiz: Create, Read, Update and Delete (CRUD) Operations30m

Week

Week 3

5 hours to complete

SQL Operators and sorting and filtering data

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.

5 hours to complete

7 videos (Total 34 min), 7 readings, 3 quizzes

7 videos

SQL Arithmetic Operators4m

Operators in use4m

SQL Comparison operators6m

ORDER BY clause5m

WHERE clause7m

SELECT DISTINCT clause4m

Module summary: SQL operators and sorting and filtering data1m

7 readings

SQL Arithmetic Operator Examples30m

SQL Comparison operator examples30m

Additional resources10m

Types of ordering / sorting30m

WHERE Clause uses30m

SELECT DISTINCT clause in use15m

Additional resources10m

3 practice exercises

Knowledge Check: Operators30m

Self-review: ORDER BY and WHERE12m

Module quiz: SQL operators and sorting and filtering data30m

Week

Week 4

6 hours to complete

Database design

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.

6 hours to complete

12 videos (Total 48 min), 9 readings, 6 quizzes

12 videos

Database schema3m

Schema in use4m

Types of database schema2m

Table relationships3m

Primary key2m

Foreign key4m

Finding entitites3m

What is database normalization?4m

First normal form 1NF4m

Second normal form 2NF6m

Third normal form 3NF4m

Module summary: Database design2m

9 readings

Exploring database schema15m

Building a schema15m

Additional resources10m

Relational model15m

Keys in depth15m

Entity relationship diagrams (ERD)30m

Additional resources15m

Data normalization15m

Additional resources10m

6 practice exercises

Knowledge check: Database schema15m

Knowledge check: Defining keys15m

Database relations and keys15m

Knowledge Check: Database normalization12m

Self-review: Database schema examples15m

Module quiz: Database design24m

Reviews

4.7

94 reviews

5 stars
76.03%
4 stars
19.82%
3 stars
2.36%
2 stars
0.59%
1 star
1.18%

TOP REVIEWS FROM INTRODUCTION TO DATABASES

by CMAug 28, 2022

This course is so much better than Introduction to Data Analytics. The guidance is clear and the instructor speaks at a very good pace.

by NINov 12, 2022

The course was very simple and goes a step by step with the student , The instructor is literally the best!!

by KADec 12, 2022

Very helpful, even with 0 knowledge in coding, I was able to catch up with the lessons.

by NMNov 21, 2022

Amazing course for beginners! Tasty cocktail of theoretical and practical knowledge! I highly appreciated this opportunity!

View all reviews

About the Meta Database Engineer Professional Certificate

Want to get started in the world of database engineering? This program is taught by industry-recognized experts at Meta. You’ll learn the key skills required to create, manage and manipulate databases, as well as industry-standard programming languages and software such as SQL, Python, and Django used for supporting outstanding websites and apps like Facebook, Instagram and more.

Upon completion, you’ll get access to the Meta Career Programs Job Board—a job search platform that connects you with 200+ employers who have committed to sourcing talent through Meta’s certificate programs, as well as career support resources to help you with your job search. In this program, you’ll learn: Core techniques and methods to structure and manage databases. Advanced techniques to write database driven applications and advanced data modeling concepts. MySQL database management system (DBMS) and data creation, querying and manipulation. How to code and use Python Syntax How to prepare for technical interviews for database engineer roles. Any third-party trademarks and other intellectual property (including logos and icons) referenced in the learning experience remain the property of their respective owners. Unless specifically identified as such, Coursera’s use of third-party intellectual property does not indicate any relationship, sponsorship, or endorsement between Coursera and the owners of these trademarks or other intellectual property.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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.
What will I get if I subscribe to this Certificate?
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. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Introduction to Databases

About this Course

What you will learn

Skills you will gain