This course is part of the Meta Database Engineer Professional Certificate

4.7
stars
435 ratings

Taught by Meta Staff

24,579 already enrolled

Offered By

Meta Database Engineer Professional CertificateMeta

About this Course

227,566 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.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

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.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

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.89/5 (154 Ratings)

Taught by Meta Staff

295,880 Learners

67 Courses

Offered by

Syllabus - What you will learn from this course

Content Rating95%(5,440 ratings)

Week1

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 program2mIntroduction to databases3mA day in the Life of a Database Engineer6mWhat is a database?5mHow is data related?3mAlternative types of databases4mWhat is Structured Query Language?2mSQL usage3mAdvantages of SQL2mSQL syntax introduction4mWhat are tables in databases?3mTypes of keys in a database table3mModule summary: Introduction to Databases2m

10 readings

Course syllabus: Introduction to databases10mHow to be successful in this course10mRelational data example charts10mDatabase Evolution15mAdditional resources10mCommon SQL Commands15mAdditional resources10mTables overview15mDatabase structure overview15mAdditional resources10m

4 practice exercises

Knowledge check: Databases and data15mKnowledge check: SQL syntax review15mKnowledge check: Database structure15mModule quiz: Introduction to Databases30m

Week2

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 types3mString data types3mDefault values4mCREATE and DROP database2mCREATE TABLE statement2mALTER TABLE statement3mINSERT statement4mSELECT statement3mINSERT INTO SELECT statement3mUpdating data3mDeleting data3mModule summary: Create, Read, Update and Delete (CRUD) Operations3m

4 readings

Additional resources15mCreating tables15mAdditional resources10mAdditional resources5m

10 practice exercises

Self review: Working with numbers15mSelf review: Working with strings12mSelf review: Working with default values12mSelf review: Choosing the right data type for a column15mSelf-review: Create database, create table and insert data15mSelf review: Practicing table creation15mKnowledge check: Create, insert and select15mSelf-review: Record deletion12mKnowledge check: Update and Delete15mModule quiz: Create, Read, Update and Delete (CRUD) Operations30m

Week3

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 Operators4mOperators in use4mSQL Comparison operators5mORDER BY clause5mWHERE clause7mSELECT DISTINCT clause4mModule summary: SQL operators and sorting and filtering data1m

7 readings

SQL Arithmetic Operator Examples30mSQL Comparison operator examples30mAdditional resources10mTypes of ordering / sorting30mWHERE Clause uses30mSELECT DISTINCT clause in use15mAdditional resources10m

3 practice exercises

Knowledge Check: Operators30mSelf-review: ORDER BY and WHERE12mModule quiz: SQL operators and sorting and filtering data30m

Week4

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 schema3mSchema in use4mTypes of database schema2mTable relationships3mPrimary key2mForeign key4mFinding entitites3mWhat is database normalization?4mFirst normal form 1NF4mSecond normal form 2NF6mThird normal form 3NF4mModule summary: Database design2m

9 readings

Exploring database schema15mBuilding a schema15mAdditional resources10mRelational model15mKeys in depth15mEntity relationship diagrams (ERD)30mAdditional resources15mData normalization15mAdditional resources10m

6 practice exercises

Knowledge check: Database schema15mKnowledge check: Defining keys15mDatabase relations and keys15mKnowledge Check: Database normalization12mSelf-review: Database schema examples15mModule quiz: Database design24m

Reviews

4.7

116 reviews

5 stars
75.16%
4 stars
20.80%
3 stars
2.46%
2 stars
0.44%
1 star
1.11%

TOP REVIEWS FROM INTRODUCTION TO DATABASES

by CVSep 22, 2022

The course was very informative but it alos had several inconsistencies within the information. There were also many grading issues that I flaged but never recieved any feedback on.

by RPSep 21, 2022

I wish accessing the Lab to practice SQL queries was easier to reach. I had to go back to previous weeks to find the lab link...

by MHOct 4, 2022

I am really inspired to learn a difficult subject in the easy way due to relax, comprehensive and informative tutorials , lectures

by ISSep 1, 2022

Well detailed course, I thought this topic was going to be hard to learn. But the teacher explained it well. Anyway, I enjoy this course, because I learned a lot from it. Thank you Coursera and Meta.

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