Coursera

Advanced MySQL Topics (Coursera)

Offered by Meta,
Advanced MySQL Topics (Coursera)

In this course, you'll begin to push beyond simple SQL statements in MySQL to an advanced level in database engineering. Through this course you'll develop new skills, improve your productivity, learn to act effectively with data and boost your career prospects.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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

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.
Course 4 of 9 in the Meta Database Engineer Professional Certificate.

What You Will 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 .

Syllabus

WEEK 1
Functions and triggers
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.

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

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

WEEK 4
Final project
Practice your SQL automation by writing a stored procedure to solve real world problems

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Relational database systems (Coursera) Coursera
Universidad Nacional Autónoma de México

Relational database systems (Coursera)

Statistics & Data Analysis Data Science

Welcome to the specialization course Relational Database Systems. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how several types of information systems and databases are available to solve different problems and needs of the companies.

Jun 8th 2026
5-12 Weeks
Databases SQL Data Analysis
Details
Databases and SQL for Data Science with Python(Coursera) Coursera
IBM

Databases and SQL for Data Science with Python(Coursera)

Statistics & Data Analysis Data Science

Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment.

Jun 8th 2026
4 Weeks
Programming Python Databases
Details
Introduction to Structured Query Language (SQL) (Coursera) Coursera
University of Michigan

Introduction to Structured Query Language (SQL) (Coursera)

CS: Software Engineering CS: Programming

In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.

Jun 8th 2026
4 Weeks
SQL PHP MySQL
Details
Scripting with Python and SQL for Data Engineering (Coursera) Coursera
Duke University

Scripting with Python and SQL for Data Engineering (Coursera)

Statistics & Data Analysis CS: Programming

In this third course of the Python, Bash and SQL Essentials for Data Engineering Specialization, you will explore techniques to work effectively with Python and SQL. We will go through useful data structures in Python scripting and connect to databases like MySQL. Additionally, you will learn how to use a modern text editor to connect and run SQL queries against a real database, performing operations to load and extract data.

Jun 8th 2026
4 Weeks
Python SQL Scripting
Details
Foundations for Big Data Analysis with SQL (Coursera) Coursera
Cloudera

Foundations for Big Data Analysis with SQL (Coursera)

Statistics & Data Analysis Data Science

In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database systems, and the common querying language (SQL). Then you'll learn the characteristics of big data and SQL tools for working on big data platforms. You'll also install an exercise environment (virtual machine) to be used through the specialization courses, and you'll have an opportunity to do some initial exploration of databases and tables in that environment.

Jun 8th 2026
5-12 Weeks
Databases SQL Big Data
Details
Data Manipulation at Scale: Systems and Algorithms (Coursera) Coursera
University of Washington

Data Manipulation at Scale: Systems and Algorithms (Coursera)

Statistics & Data Analysis Data Science

Data analysis has replaced data acquisition as the bottleneck to evidence-based decision making --- we are drowning in it. Extracting knowledge from large, heterogeneous, and noisy datasets requires not only powerful computing resources, but the programming abstractions to use them effectively. The abstractions that emerged in the last decade blend ideas from parallel databases, distributed systems, and programming languages to create a new class of scalable data analytics platforms that form the foundation for data science at realistic scales.

Jun 8th 2026
4 Weeks
Algebra Algorithms Databases
Details
The Structured Query Language (SQL) (Coursera) Coursera
University of Colorado Boulder

The Structured Query Language (SQL) (Coursera)

Data Science

In this course you will learn all about the Structured Query Language ("SQL".) We will review the origins of the language and its conceptual foundations. But primarily, we will focus on learning all the standard SQL commands, their syntax, and how to use these commands to conduct analysis of the data within a relational database. Our scope includes not only the SELECT statement for retrieving data and creating analytical reports, but also includes the DDL ("Data Definition Language") and DML ("Data Manipulation Language") commands necessary to create and maintain database objects.

Jun 9th 2026
5-12 Weeks
Databases SQL Data Science
Details
Building Scalable Java Microservices with Spring Boot and Spring Cloud (Coursera) Coursera
Google Cloud

Building Scalable Java Microservices with Spring Boot and Spring Cloud (Coursera)

Computer Science

"Microservices" describes a software design pattern in which an application is a collection of loosely coupled services. These services are fine-grained, and can be individually maintained and scaled. The microservices architecture is ideal for the public cloud, with its focus on elastic scaling with on-demand resources. In this course, you will learn how to build Java applications using Spring Boot and Spring Cloud on Google Cloud Platform.

Jun 9th 2026
2 Weeks
Java Cloud SQL
Details