Database Structures and Management with MySQL

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Experts

Access provided by Alliance University

44,537 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

559 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

98%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

559 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

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

Database Administration
Database Systems
MySQL
SQL
Data Integrity
Query Languages
Relational Databases
Stored Procedure
Data Validation
Data Management
Database Design
Database Development
Database Management
Skills section collapsed. Showing 12 of 13 skills.

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

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’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 videos Total 68 minutes

Introduction to the program 2 minutes
Introduction to the course 2 minutes
How Meta uses MySQL 5 minutes
Filtering data using AND, OR and NOT logical operators 8 minutes
Filtering data using IN, BETWEEN and LIKE logical operators 7 minutes
MySQL aliases 8 minutes
JOINS 6 minutes
INNER JOIN 4 minutes
LEFT and RIGHT JOIN 4 minutes
SELF-JOIN 4 minutes
MySQL UNION operator 5 minutes
MySQL GROUP BY 7 minutes
MySQL HAVING 5 minutes
Module summary: Intro to MySQL 2 minutes

18 readings Total 159 minutes

Course syllabus: Database structures and management with MySQL 4 minutes
How to be successful in this course 5 minutes
Recap of Course 1 concepts 5 minutes
Additional resources 5 minutes
How to access MySQL Environment 10 minutes
Filtering data (Exercise solution) 10 minutes
Additional resources 5 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 clause 10 minutes
Joining tables 30 minutes
Practice using JOINS (Exercise solution) 10 minutes
Additional resources 5 minutes
Grouping data (Exercise solution) 10 minutes
Additional resources 5 minutes
Reading exercise: Operators and clauses (Optional) 10 minutes
Reading exercise: Operators and clauses (Exercise solution) 10 minutes
Reference sheet: Operators and clauses 10 minutes

8 assignments Total 135 minutes

Module quiz: Intro to MySQL 30 minutes
Knowledge check: Filtering data using logical operators 15 minutes
Self review: Filtering data 15 minutes
Knowledge check: JOINS 15 minutes
Knowledge check: MySQL UNION operator 15 minutes
Self review: JOINS 15 minutes
Knowledge check: GROUP BY and HAVING clauses 15 minutes
Self review: Grouping data 15 minutes

3 ungraded labs Total 180 minutes

Exercise: Filtering data 60 minutes
Exercise: Practice using JOINS 60 minutes
Exercise: Grouping data 60 minutes

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

What's included

9 videos24 readings11 assignments5 ungraded labs

9 videos Total 52 minutes

MySQL REPLACE statement 6 minutes
Constraints in MySQL 5 minutes
Constraints in practice 4 minutes
MySQL ALTER TABLE 5 minutes
MySQL COPY TABLE 7 minutes
Subqueries in MySQL 5 minutes
Subqueries and complex comparison operators 8 minutes
MySQL CREATE VIEW 7 minutes
Module summary: Updating databases and working with views 2 minutes

24 readings Total 255 minutes

MySQL REPLACE statement in depth 30 minutes
MySQL REPLACE statement (Exercise solution) 10 minutes
Additional resources 5 minutes
Reading exercise: REPLACE INTO statement (Optional) 10 minutes
Reading exercise: REPLACE INTO statement (Exercise solution) 10 minutes
Types of MySQL constraints 10 minutes
Working with constraints (Exercise solution) 10 minutes
Additional resources 5 minutes
Reading exercise: MySQL constraints (Optional) 10 minutes
Reading exercise: MySQL constraints (Exercise solution) 10 minutes
Changing table structure (Exercise solution) 10 minutes
Additional resources 5 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 uses 10 minutes
Working with subqueries (Exercise solution) 10 minutes
Additional resources 5 minutes
Reading exercise: Practicing subqueries (Optional) 10 minutes
Reading exercise: Practicing subqueries (Exercise solution) 10 minutes
Reference sheet: Subqueries 10 minutes
Virtual tables in depth 30 minutes
Working with views in MySQL (Exercise solution) 10 minutes
Additional resources 5 minutes
Reference sheet: Creating virtual tables in MySQL 10 minutes

11 assignments Total 195 minutes

Module quiz: Updating databases and working with views 30 minutes
Knowledge check: REPLACE 15 minutes
Self review: MySQL REPLACE statement 15 minutes
Knowledge check: Constraints 15 minutes
Self review: Working with constraints 15 minutes
Knowledge check: ALTER TABLE and COPY TABLE 30 minutes
Self review: Changing table structure 15 minutes
Knowledge check: Subqueries in MySQL 15 minutes
Self review: Working with subqueries 15 minutes
Knowledge check: Views in MySQL 15 minutes
Self review: Working with views in MySQL 15 minutes

5 ungraded labs Total 300 minutes

Exercise: MySQL REPLACE statement 60 minutes
Exercise: Working with constraints 60 minutes
Exercise: Changing table structure 60 minutes
Exercise: Working with subqueries 60 minutes
Working with views in MySQL 60 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 videos Total 36 minutes

Numeric functions 6 minutes
String functions 7 minutes
Date functions 5 minutes
Comparison functions 5 minutes
Control flow functions 5 minutes
Stored procedures in MySQL 7 minutes
Module summary: Functions and MySQL stored procedures 1 minute

8 readings Total 130 minutes

Working with MySQL functions (Exercise solution) 10 minutes
Additional resources 30 minutes
Reading exercise: Practicing with functions (Optional) 10 minutes
Reading exercise: Practicing with functions (Exercise solution) 15 minutes
Reference sheet: Functions in MySQL 20 minutes
MySQL stored procedures in depth 30 minutes
Working with procedures (Exercise solution) 10 minutes
Additional resources 5 minutes

6 assignments Total 120 minutes

Module quiz: Functions and MySQL stored procedures 30 minutes
Knowledge check: MySQL functions 15 minutes
Knowledge check: MySQL comparison and control flow functions 30 minutes
Self review: Working with MySQL functions 15 minutes
Knowledge check: MySQL stored procedures 15 minutes
Self review: Working with procedures 15 minutes

2 ungraded labs Total 120 minutes

Exercise: Working with MySQL functions 60 minutes
Exercise: Working with procedures 60 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.