Course Highlights
  • 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.
Curriculum

27 Topics
Introduction to advanced MySQL topics
Functions and stored procedures in MySQL
Variables and parameters
Developing user-defined functions
Create complex stored procedures
What are MySQL triggers?
Types of MySQL triggers
Create and drop triggers in MySQL
Working with MySQL Scheduled Events
Module summary: Functions and triggers
Course syllabus: Advanced MySQL
How to be successful in this course
How to access the MySQL environment
Differences between functions and stored procedures
Solution: Developing functions in MySQL
Additional resources
Overview of MySQL triggers
Solution: Working with triggers
Additional resources
Module quiz: Functions and triggers
Knowledge check: MySQL functions and stored procedures
Self review: Developing functions in MySQL
Knowledge check: MySQL triggers and events
Self review: Working with triggers
What do you hope to learn?
Developing functions in MySQL
Working with triggers

23 Topics
Overview of database optimization
Optimizing database SELECT statements
Optimizing database SELECT statements in practice
Indexes in MySQL
MySQL Transaction
MySQL Common table expression (CTE)
MySQL Prepared Statement
MySQL JSON
Module summary: Database optimization
Database optimization in practice with SELECT statements
Database optimization in practice with indexes
Solution: SELECT statement optimization in MySQL
Additional resources
Further optimization techniques
Solution: MySQL optimization techniques exercise
Additional resources
Module quiz: Database optimization
Knowledge check: Optimizing database queries
Self review: SELECT statement optimization in MySQL
Knowledge check: Further optimization techniques
Self review: MySQL optimization techniques exercise
SELECT statement optimization in MySQL
MySQL optimization techniques exercise

15 Topics
Overview of database analytics
Using MySQL for data analysis
Data analysis in MySQL using SQL queries
Emulating the Full Outer JOIN in MySQL
Extracting data from multiple tables with JOINS
Module summary: MySQL for data analytics
How MySQL is used with advanced data analytics tools
Additional resources
Solution: Data analysis in MySQL
Additional resources
Module quiz: MySQL for data analytics
Knowledge check: Using MySQL for data analysis
Knowledge check: Performing data analysis in MySQL
Self review: Data analysis in MySQL
Data analysis in MySQL

10 Topics
Course Recap: Advanced MySQL
Course wrap up
About the final graded assessment
Solution: Conduct a data analysis for a client persona
Next steps
Final graded quiz: Advanced MySQL
Self review: Conduct a data analysis for a client persona
What challenges did you encounter with your data analysis project?
Reflect on learning
Conduct a data analysis for a client persona

  Write a Review

Advanced MySQL Topics

Go to Free Course