Database Structures and Management with MySQL

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Experts

47,311 already enrolled

Included with

4 modules

Gain insight into a topic and learn the fundamentals.

566 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

97%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

566 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

97%

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

Category: Data Management
Category: Database Development
Category: Database Management
Category: Database Design
Category: Database Administration
Category: Stored Procedure
Category: Data Integrity
Category: Data Maintenance
Category: SQL
Category: Data Entry

Tools you'll learn

Category: Database Management Systems
Category: MySQL
Category: Query Languages
Category: Relational Databases

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

27 assignments

Taught in English

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’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 assignments3 ungraded labs

14 videosTotal 68 minutes

Introduction to the program2 minutes
Introduction to the course2 minutes
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
JOINS6 minutes
INNER JOIN4 minutes
LEFT and RIGHT JOIN4 minutes
SELF-JOIN4 minutes
MySQL UNION operator5 minutes
MySQL GROUP BY7 minutes
MySQL HAVING5 minutes
Module summary: Intro to MySQL2 minutes

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
Additional resources5 minutes
How to access MySQL Environment10 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

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 minutes
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 255 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 constraints10 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 TABLE 30 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 36 minutes

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

8 readingsTotal 130 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)15 minutes
Reference sheet: Functions in MySQL20 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’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.

What's included

2 videos3 readings2 assignments2 discussion prompts1 ungraded lab

2 videosTotal 6 minutes

Course Recap3 minutes
Course wrap up3 minutes

3 readingsTotal 30 minutes

About the final graded assessment5 minutes
MySQL database project (Exercise solution)20 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

(146 ratings)

Taught by Meta Experts

Offered by

Why people choose Coursera 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, Coursera 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. Coursera allows me to learn without limits."

Learner reviews

5 stars
83.21%
4 stars
13.42%
3 stars
1.59%
2 stars
0.53%
1 star
1.23%

Showing 3 of 566

Reviewed on Jun 3, 2023

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

Reviewed on Jan 5, 2023

Thank you so much for the opportunity to learn Introduction to Database Structure Management with SQL learn New things with crisp and clearly Taught Menter and Meta and Coursera thanks for help me..

Reviewed on Apr 9, 2024

This course lays the fundamental foundations for understanding advanced operators and effective manipulation of MySQL databases.

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.

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.