Advanced MySQL Topics

Heat up your career with 40% off top courses from Google, Adobe, and more. Save today.

Advanced MySQL Topics

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Staff

22,116 already enrolled

Included with Coursera Plus

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

4.7

(235 reviews)

Intermediate level

Recommended experience

Flexible schedule

Approx. 18 hours

Learn at your own pace

95%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

4.7

(235 reviews)

Intermediate level

Recommended experience

Flexible schedule

Approx. 18 hours

Learn at your own pace

95%

Most learners liked this course

What you'll learn

Add decision structures and functionality to a MySQL databases using SQL functions and operators on numbers and strings.
Automate SQL by writing a stored procedure to solve real world problems .

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

16 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

In this course, you'll begin to push beyond simple SQL statements in MySQL to an advanced level in database engineering.

By the end of this course, you'll be able to: - Use control statements and variables in different contexts in MySQL - Develop user defined functions and procedures - Optimize MySQL database queries - Demonstrate a working knowledge of common table expressions and the JSON data type - Understand how and when to use triggers and events - Utilize subqueries, JOINS, views and transactions to perform data analysis - and use database optimization techniques such as MySQL transactions You'll gain experience with the following advanced MySQL database skills: - MySQL user defined functions - Advanced MySQL stored procedures - MySQL optimization techniques including Indexes, Transactions, CTE and JSON - MySQL triggers and events - Database analytics in MySQL - Advanced SQL queries for data analysis with JOINS, views and subqueries Through this course you'll develop new skills, improve your productivity, learn to act effectively with data and boost your career prospects. To be successful in this course, you should have already completed the previous course, “Database Structures and Management with MySQL,” or have prior experience with the skills taught in that course.

Learn how to develop user defined functions and more complex stored procedures in MySQL. You'll also practice invoking a stored program (procedure or function) automatically in response to an event such as insert, update, or delete that occurs in the associated table.

What's included

10 videos9 readings5 assignments1 discussion prompt2 ungraded labs

10 videosTotal 42 minutes

Introduction to advanced MySQL topics3 minutesPreview module
Functions and stored procedures in MySQL3 minutes
Variables and parameters6 minutes
Developing user-defined functions4 minutes
Create complex stored procedures2 minutes
What are MySQL triggers?4 minutes
Types of MySQL triggers4 minutes
Create and drop triggers in MySQL3 minutes
Working with MySQL Scheduled Events5 minutes
Module summary: Functions and triggers3 minutes

9 readingsTotal 105 minutes

Course syllabus: Advanced MySQL 15 minutes
How to be successful in this course5 minutes
How to access the MySQL environment10 minutes
Differences between functions and stored procedures10 minutes
Solution: Developing functions in MySQL15 minutes
Additional resources5 minutes
Overview of MySQL triggers10 minutes
Solution: Working with triggers30 minutes
Additional resources5 minutes

5 assignmentsTotal 84 minutes

Knowledge check: MySQL functions and stored procedures15 minutes
Self review: Developing functions in MySQL12 minutes
Knowledge check: MySQL triggers and events15 minutes
Self review: Working with triggers12 minutes
Module quiz: Functions and triggers30 minutes

1 discussion promptTotal 10 minutes

What do you hope to learn?10 minutes

2 ungraded labsTotal 120 minutes

Developing functions in MySQL60 minutes
Working with triggers60 minutes

Learn the core rules and guidelines for database optimization, and practice advanced database administration tasks that will optimize your database.

What's included

9 videos7 readings5 assignments2 ungraded labs

9 videosTotal 33 minutes

Overview of database optimization3 minutesPreview module
Optimizing database SELECT statements3 minutes
Optimizing database SELECT statements in practice2 minutes
Indexes in MySQL4 minutes
MySQL Transaction5 minutes
MySQL Common table expression (CTE)4 minutes
MySQL Prepared Statement2 minutes
MySQL JSON2 minutes
Module summary: Database optimization3 minutes

7 readingsTotal 140 minutes

Database optimization in practice with SELECT statements30 minutes
Database optimization in practice with indexes30 minutes
Solution: SELECT statement optimization in MySQL30 minutes
Additional resources5 minutes
Further optimization techniques10 minutes
Solution: MySQL optimization techniques exercise30 minutes
Additional resources5 minutes

5 assignmentsTotal 85 minutes

Knowledge check: Optimizing database queries15 minutes
Self review: SELECT statement optimization in MySQL12 minutes
Knowledge check: Further optimization techniques18 minutes
Self review: MySQL optimization techniques exercise10 minutes
Module quiz: Database optimization30 minutes

2 ungraded labsTotal 120 minutes

SELECT statement optimization in MySQL60 minutes
MySQL optimization techniques exercise60 minutes

Learn how to use MySQL with advanced data analytics tools and discover how to perform data analysis using advanced MySQL queries.

What's included

6 videos4 readings4 assignments1 ungraded lab

6 videosTotal 23 minutes

Overview of database analytics4 minutesPreview module
Using MySQL for data analysis3 minutes
Data analysis in MySQL using SQL queries5 minutes
Emulating the Full Outer JOIN in MySQL4 minutes
Extracting data from multiple tables with JOINS2 minutes
Module summary: MySQL for data analytics3 minutes

4 readingsTotal 50 minutes

How MySQL is used with advanced data analytics tools10 minutes
Additional resources5 minutes
Solution: Data analysis in MySQL30 minutes
Additional resources5 minutes

4 assignmentsTotal 70 minutes

Knowledge check: Using MySQL for data analysis15 minutes
Knowledge check: Performing data analysis in MySQL15 minutes
Self review: Data analysis in MySQL10 minutes
Module quiz: MySQL for data analytics30 minutes

1 ungraded labTotal 60 minutes

Data analysis in MySQL60 minutes

Practice your SQL automation by writing a stored procedure to solve real world problems

What's included

2 videos3 readings2 assignments2 discussion prompts1 ungraded lab

2 videosTotal 5 minutes

Course Recap: Advanced MySQL4 minutesPreview module
Course wrap up1 minute

3 readingsTotal 45 minutes

About the final graded assessment5 minutes
Solution: Conduct a data analysis for a client persona30 minutes
Next steps10 minutes

2 assignmentsTotal 45 minutes

Self review: Conduct a data analysis for a client persona15 minutes
Final graded quiz: Advanced MySQL30 minutes

2 discussion promptsTotal 20 minutes

What challenges did you encounter with your data analysis project?10 minutes
Reflect on learning10 minutes

1 ungraded labTotal 60 minutes

Conduct a data analysis for a client persona60 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.3 (72 ratings)

Taught by Meta Staff

Offered by

Explore more from Data Management

Duke University
MySQL-for-Data-Engineering
Guided Project
Status: Free Trial
Meta
Database Structures and Management with MySQL
Course
Status: Free Trial
Meta
Introduction to Databases
Course
Edureka
MySQL for Data Analytics and Business Intelligence
Course

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

4.7

235 reviews

5 stars
77.96%
4 stars
14.83%
3 stars
3.81%
2 stars
1.27%
1 star
2.11%

Showing 3 of 235

Reviewed on May 9, 2023

It was very challenging but the instructor maximized the time and resources available for a great course delivery. I learnt a lot, and hoping to practice to become more proficient.

Reviewed on Aug 26, 2023

I found the content helpful and the lab environment helped me practice what learned step by step. However, the pace and tone of the instructor can be improved. I had to pause a lot to understand it.

Reviewed on Dec 17, 2023

The course is very nice. The only suggestion is to have a summary document for each module.

View more reviews

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

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.

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.

If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.