Database Structures and Management with MySQL

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Staff

Access provided by New York State Department of Labor

37,994 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

4.8

(515 reviews)

Beginner level

Recommended experience

Flexible schedule

2 hours to complete

Learn at your own pace

98%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

4.8

(515 reviews)

Beginner level

Recommended experience

Flexible schedule

2 hours to complete

Learn at your own pace

98%

Most learners liked this course

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 糖心vlog官网观看 for Business

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

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

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鈥檒l gain further experience with SQL statements, clauses and data types.

By the end of this course, you鈥檒l 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鈥檒l 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

Module quiz: Intro to MySQL30 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

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

Module quiz: Updating databases and working with views30 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

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

Module quiz: Functions and MySQL stored procedures 30 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

2 ungraded labsTotal 120 minutes

Exercise: Working with MySQL functions60 minutes
Exercise: Working with procedures60 minutes

In this module, you鈥檒l 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 videos3 readings2 assignments2 discussion prompts1 ungraded lab

2 videosTotal 5 minutes

Course Recap3 minutesPreview module
Course wrap up2 minutes

3 readingsTotal 45 minutes

About the final graded assessment30 minutes
MySQL database project (Exercise solution)10 minutes
Next steps5 minutes

2 assignmentsTotal 45 minutes

Course final graded quiz30 minutes
Self review: MySQL database project15 minutes

2 discussion promptsTotal 20 minutes

Share some of the things you learned building the project.10 minutes
Reflect on learning10 minutes

1 ungraded labTotal 60 minutes

MySQL database project60 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

4.8 (133 ratings)

Taught by Meta Staff

Offered by

Why people choose 糖心vlog官网观看 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, 糖心vlog官网观看 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. 糖心vlog官网观看 allows me to learn without limits."

Learner reviews

4.8

515 reviews

5 stars
83.52%
4 stars
13.17%
3 stars
1.74%
2 stars
0.58%
1 star
0.96%

Showing 3 of 515

Reviewed on Jan 14, 2023

Course comes with lots of hand-on and real-world practical examples and exercises. Loved it

Reviewed on Nov 5, 2022

Great rigor to the coursework. If you take your time, study the materials, and do the labs, you will definitely learn everything you need to know to get start coding SQL Databases.

Reviewed on Jun 4, 2023

This is the best course to understand MySQL and write more complex queries to make meaning from data.

View more reviews