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

Intermediate PostgreSQL (Coursera) Coursera
University of Michigan

Intermediate PostgreSQL (Coursera)

CS: Software Engineering

This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database. You’ll also take a look at how PostgreSQL handles and indexes text data.

Nov 9th 2026
Self-Paced
SQL CRUD PostgreSQL
Details
Relational Database Support for Data Warehouses (Coursera) Coursera
University of Colorado System

Relational Database Support for Data Warehouses (Coursera)

Statistics & Data Analysis Data Science

Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.

Nov 9th 2026
5-12 Weeks
Databases SQL Big Data
Details
Building Database Applications in PHP (Coursera) Coursera
University of Michigan

Building Database Applications in PHP (Coursera)

CS: Software Engineering CS: Programming

In this course, we'll look at the object oriented patterns available in PHP. You'll learn how to connect to a MySQL using the Portable Data Objects (PDO) library and issue SQL commands in the the PHP language. We'll also look at how PHP uses cookies and manages session data. You'll learn how PHP avoids double posting data, how flash messages are implemented, and how to use a session to log in users in web applications.

Nov 9th 2026
5-12 Weeks
Databases PHP MySQL
Details
La recherche documentaire (Coursera) Coursera
École Polytechnique

La recherche documentaire (Coursera)

Personal and Professional Development

Ce cours vise principalement à permettre aux étudiants d’identifier les sources pertinentes dans un domaine donné, leur apprendre à construire un état de l’art et à évaluer les sources, en particulier celles en accès libre sur Internet. Il cherche également à optimiser la recherche documentaire en incitant les étudiants à tirer le meilleur parti des outils et requêtes d’interrogation des bases de données. A l'issue de ce cours, ils devront être capables de construire et alimenter une bibliographie ordonnée, ainsi que de citer convenablement leurs sources pour éviter le plagiat.

Nov 23rd 2026
3 Weeks
Databases Literature Search Document Search
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.

Nov 9th 2026
4 Weeks
Algebra Algorithms Databases
Details
Big Data Analytical Platform on Alibaba Cloud (Coursera) Coursera
Alibaba Cloud Academy

Big Data Analytical Platform on Alibaba Cloud (Coursera)

CS: Information & Technology

Building an Analytical Platform on Alibaba Cloud can empower how you take in, analyze, and demonstrate clear metrics from a set of Big Data. This course is designed to teach engineers how to use Alibaba Cloud Big Data products. It covers basic distributed system theory and Alibaba Cloud's core products like MaxCompute, DataWorks, E-MapReduce as well as a bundle of ecosystem tools.

Nov 9th 2026
5-12 Weeks
Artificial Intelligence SQL Big Data
Details
Accounting Data Analytics with Python (Coursera) Coursera
University of Illinois at Urbana-Champaign

Accounting Data Analytics with Python (Coursera)

Statistics & Data Analysis Data Science

This course focuses on developing Python skills for assembling business data. It will cover some of the same material from Introduction to Accounting Data Analytics and Visualization, but in a more general purpose programming environment (Jupyter Notebook for Python), rather than in Excel and the Visual Basic Editor. These concepts are taught within the context of one or more accounting data domains (e.g., financial statement data from EDGAR, stock data, loan data, point-of-sale data).

Nov 9th 2026
5-12 Weeks
Python SQL Linear Regression
Details
Relational Database Implementation and Applications (Coursera) Coursera
Illinois Tech

Relational Database Implementation and Applications (Coursera)

Statistics & Data Analysis Data Science

In today's data-driven world, the ability to work with relational databases is an essential skill for professionals in various fields. This course is designed to equip you with the knowledge and practical skills needed to become proficient in database management and application development. Whether you are pursuing a career as a database administrator, software developer, or data analyst, this course provides you with a strong foundation to excel in your chosen field.

Nov 16th 2026
5-12 Weeks
SQL Transactions Hashing
Details
Plant Bioinformatics Capstone (Coursera) Coursera
University of Toronto

Plant Bioinformatics Capstone (Coursera)

Engineering Sci: Physics

The past 15 years have been exciting ones in plant biology. Hundreds of plant genomes have been sequenced, RNA-seq has enabled transcriptome-wide expression profiling, and a proliferation of "-seq"-based methods has permitted protein-protein and protein-DNA interactions to be determined cheaply and in a high-throughput manner. These data sets in turn allow us to generate hypotheses at the click of a mouse or tap of a finger. In Plant Bioinformatics on Coursera.org, we covered 33 plant-specific online tools from genome browsers to transcriptomic data mining to promoter/network analyses and others, and in this Plant Bioinformatics Capstone we'll use these tools to hypothesize a biological role for a gene of unknown function, summarized in a written lab report.

Nov 9th 2026
5-12 Weeks
Databases Genes Genomes
Details
Introduction to MongoDB (Coursera) Coursera
MongoDB University

Introduction to MongoDB (Coursera)

CS: Information & Technology

"Introduction to MongoDB" guides you through the foundational skills and knowledge you need to get started with MongoDB. Get an introduction to MongoDB Atlas, the developer data platform, and how to create and deploy an Atlas cluster. Discover how MongoDB structures data in documents similar to JSON objects, making it flexible and developer friendly.

Nov 9th 2026
4 Weeks
MongoDB Databases NoSQL
Details