Back to Advanced MySQL Topics
Learner Reviews & Feedback for Advanced MySQL Topics by Meta
242 ratings
About the 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.
Top reviews
SI
Dec 10, 2022
Learned a bunch of new SQL topics here.. I recommend this to anyone interested in improving their SQL skills. Don't forget to expand your understanding via any other resources out there.Good one!
PI
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.
Filter by: