Database Structures and Management with MySQL

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Staff

What you'll learn

Utilize the MySQL DBMS to build and modify relational databases with SQL.
Create relationships between tables using primary and foreign keys .

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

27 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 4 modules in this course

Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types.

By the end of this course, you’ll be able to: - Utilize the MySQL DBMS to build and modify relational databases with SQL - Add records to a MySQL database - Perform intricate queries on database records with filters and groupings - Create simple joins and unions within a database - Create relationships between tables using primary and foreign keys - Demonstrate the ability to complete a database normalization project You’ll gain experience with the following tools and software: - MySQL DBMS - Joins and Unions - SQL statements, clauses and data types - Primary and foreign keys - Database normalization

In this module, you will learn to use the MySQL DBMS to build, modify and query relational databases with SQL.

What's included

14 videos18 readings8 assignments1 discussion prompt3 ungraded labs

14 videosTotal 68 minutes

Introduction to the program2 minutesPreview module
Introduction to the course1 minute
How Meta uses MySQL5 minutes
Filtering data using AND, OR and NOT logical operators8 minutes
Filtering data using IN, BETWEEN and LIKE logical operators7 minutes
MySQL aliases8 minutes
JOINS5 minutes
INNER JOIN3 minutes
LEFT and RIGHT JOIN4 minutes
SELF-JOIN3 minutes
MySQL UNION operator4 minutes
MySQL GROUP BY6 minutes
MySQL HAVING4 minutes
Module summary: Intro to MySQL1 minute

18 readingsTotal 159 minutes

Course syllabus: Database structures and management with MySQL4 minutes
How to be successful in this course5 minutes
Recap of Course 1 concepts5 minutes
How to access MySQL Environment10 minutes
Additional resources5 minutes
Filtering data (Exercise solution)10 minutes
Additional resources5 minutes
Reading exercise: Filtering data examples (Optional) 5 minutes
Reading exercise: Filtering data examples (Exercise solution)10 minutes
Reference sheet: Using operators and the WHERE clause10 minutes
Joining tables30 minutes
Practice using JOINS (Exercise solution)10 minutes
Additional resources5 minutes
Grouping data (Exercise solution)10 minutes
Additional resources5 minutes
Reading exercise: Operators and clauses (Optional)10 minutes
Reading exercise: Operators and clauses (Exercise solution)10 minutes
Reference sheet: Operators and clauses10 minutes

8 assignmentsTotal 135 minutes

Knowledge check: Filtering data using logical operators15 minutes
Self review: Filtering data15 minutes
Knowledge check: JOINS15 minutes
Knowledge check: MySQL UNION operator15 minutes
Self review: JOINS15 minutes
Knowledge check: GROUP BY and HAVING clauses15 minutes
Self review: Grouping data15 minutes
Module quiz: Intro to MySQL30 minutes

1 discussion promptTotal 10 minutes

What do you hope to learn?10 minutes

3 ungraded labsTotal 180 minutes

Exercise: Filtering data60 minutes
Exercise: Practice using JOINS60 minutes
Exercise: Grouping data60 minutes

In this module you'll learn how update databases and work with views.

What's included

9 videos24 readings11 assignments5 ungraded labs

9 videosTotal 52 minutes

MySQL REPLACE statement6 minutesPreview module
Constraints in MySQL5 minutes
Constraints in practice4 minutes
MySQL ALTER TABLE5 minutes
MySQL COPY TABLE7 minutes
Subqueries in MySQL5 minutes
Subqueries and complex comparison operators8 minutes
MySQL CREATE VIEW7 minutes
Module summary: Updating databases and working with views2 minutes

24 readingsTotal 275 minutes

MySQL REPLACE statement in depth30 minutes
MySQL REPLACE statement (Exercise solution)10 minutes
Additional resources5 minutes
Reading exercise: REPLACE INTO statement (Optional)10 minutes
Reading exercise: REPLACE INTO statement (Exercise solution)10 minutes
Types of MySQL constraints30 minutes
Working with constraints (Exercise solution)10 minutes
Additional resources5 minutes
Reading exercise: MySQL constraints (Optional)10 minutes
Reading exercise: MySQL constraints (Exercise solution)10 minutes
Changing table structure (Exercise solution)10 minutes
Additional resources5 minutes
Reading exercise: ALTER TABLE statement (Optional)10 minutes
Reading exercise: ALTER TABLE statement (Exercise solution)10 minutes
Reference sheet: ALTER TABLE statement and its uses10 minutes
Working with subqueries (Exercise solution)10 minutes
Additional resources5 minutes
Reading exercise: Practicing subqueries (Optional)10 minutes
Reading exercise: Practicing subqueries (Exercise solution)10 minutes
Reference sheet: Subqueries10 minutes
Virtual tables in depth30 minutes
Working with views in MySQL (Exercise solution)10 minutes
Additional resources5 minutes
Reference sheet: Creating virtual tables in MySQL10 minutes

11 assignmentsTotal 195 minutes

Knowledge check: REPLACE15 minutes
Self review: MySQL REPLACE statement15 minutes
Knowledge check: Constraints15 minutes
Self review: Working with constraints15 minutes
Knowledge check: ALTER TABLE and COPY TABLE30 minutes
Self review: Changing table structure15 minutes
Knowledge check: Subqueries in MySQL15 minutes
Self review: Working with subqueries15 minutes
Knowledge check: Views in MySQL15 minutes
Self review: Working with views in MySQL15 minutes
Module quiz: Updating databases and working with views30 minutes

5 ungraded labsTotal 300 minutes

Exercise: MySQL REPLACE statement60 minutes
Exercise: Working with constraints60 minutes
Exercise: Changing table structure60 minutes
Exercise: Working with subqueries60 minutes
Working with views in MySQL60 minutes

In this third module, you'll explore different types of functions and learn how to work with MySQL stored procedures.

What's included

7 videos8 readings6 assignments2 ungraded labs

7 videosTotal 35 minutes

Numeric functions6 minutesPreview module
String functions7 minutes
Date functions4 minutes
Comparison functions5 minutes
Control flow functions4 minutes
Stored procedures in MySQL6 minutes
Module summary: Functions and MySQL stored procedures1 minute

8 readingsTotal 115 minutes

Working with MySQL functions (Exercise solution)10 minutes
Additional resources30 minutes
Reading exercise: Practicing with functions (Optional)10 minutes
Reading exercise: Practicing with functions (Exercise solution)10 minutes
Reference sheet: Functions in MySQL10 minutes
MySQL stored procedures in depth30 minutes
Working with procedures (Exercise solution)10 minutes
Additional resources5 minutes

6 assignmentsTotal 120 minutes

Knowledge check: MySQL functions15 minutes
Knowledge check: MySQL comparison and control flow functions30 minutes
Self review: Working with MySQL functions15 minutes
Knowledge check: MySQL stored procedures15 minutes
Self review: Working with procedures15 minutes
Module quiz: Functions and MySQL stored procedures 30 minutes

2 ungraded labsTotal 120 minutes

Exercise: Working with MySQL functions60 minutes
Exercise: Working with procedures60 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.