Advanced MySQL Topics
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 transac
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- Duration 19 hours
- Course by Meta
-
Offered by
About
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.Modules
Course Introduction
-
1
Videos
-
3
Readings
-
1
Discussion
1
Discussions
- What do you hope to learn?
1
Videos
- Introduction to advanced MySQL topics
3
Readings
- Course syllabus: Advanced MySQL
- How to be successful in this course
- How to access the MySQL environment
Advanced MySQL functions and stored procedures
-
4
Videos
-
3
Readings
-
1
Lab
-
2
Assignment
2
Assignment
- Knowledge check: MySQL functions and stored procedures
- Self review: Developing functions in MySQL
1
Labs
- Developing functions in MySQL
4
Videos
- Functions and stored procedures in MySQL
- Variables and parameters
- Developing user-defined functions
- Create complex stored procedures
3
Readings
- Differences between functions and stored procedures
- Solution: Developing functions in MySQL
- Additional resources
MySQL triggers and events
-
5
Videos
-
3
Readings
-
1
Lab
-
3
Assignment
3
Assignment
- Knowledge check: MySQL triggers and events
- Self review: Working with triggers
- Module quiz: Functions and triggers
1
Labs
- Working with triggers
5
Videos
- What are MySQL triggers?
- Types of MySQL triggers
- Create and drop triggers in MySQL
- Working with MySQL Scheduled Events
- Module summary: Functions and triggers
3
Readings
- Overview of MySQL triggers
- Solution: Working with triggers
- Additional resources
Optimizing database queries
-
4
Videos
-
4
Readings
-
1
Lab
-
2
Assignment
2
Assignment
- Knowledge check: Optimizing database queries
- Self review: SELECT statement optimization in MySQL
1
Labs
- SELECT statement optimization in MySQL
4
Videos
- Overview of database optimization
- Optimizing database SELECT statements
- Optimizing database SELECT statements in practice
- Indexes in MySQL
4
Readings
- Database optimization in practice with SELECT statements
- Database optimization in practice with indexes
- Solution: SELECT statement optimization in MySQL
- Additional resources
Further optimization techniques
-
5
Videos
-
3
Readings
-
1
Lab
-
3
Assignment
3
Assignment
- Knowledge check: Further optimization techniques
- Self review: MySQL optimization techniques exercise
- Module quiz: Database optimization
1
Labs
- MySQL optimization techniques exercise
5
Videos
- MySQL Transaction
- MySQL Common table expression (CTE)
- MySQL Prepared Statement
- MySQL JSON
- Module summary: Database optimization
3
Readings
- Further optimization techniques
- Solution: MySQL optimization techniques exercise
- Additional resources
Evaluating MySQL for data analysis
-
2
Videos
-
2
Readings
-
1
Assignment
1
Assignment
- Knowledge check: Using MySQL for data analysis
2
Videos
- Overview of database analytics
- Using MySQL for data analysis
2
Readings
- How MySQL is used with advanced data analytics tools
- Additional resources
Performing data analysis in MySQL
-
4
Videos
-
2
Readings
-
1
Lab
-
3
Assignment
3
Assignment
- Knowledge check: Performing data analysis in MySQL
- Self review: Data analysis in MySQL
- Module quiz: MySQL for data analytics
1
Labs
- Data analysis in MySQL
4
Videos
- 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
2
Readings
- Solution: Data analysis in MySQL
- Additional resources
Graded assessment
-
1
Videos
-
2
Readings
-
1
Discussion
-
1
Lab
-
2
Assignment
2
Assignment
- Self review: Conduct a data analysis for a client persona
- Final graded quiz: Advanced MySQL
1
Discussions
- What challenges did you encounter with your data analysis project?
1
Labs
- Conduct a data analysis for a client persona
1
Videos
- Course Recap: Advanced MySQL
2
Readings
- About the final graded assessment
- Solution: Conduct a data analysis for a client persona
Course wrap up
-
1
Videos
-
1
Readings
-
1
Discussion
1
Discussions
- Reflect on learning
1
Videos
- Course wrap up
1
Readings
- Next steps
Auto Summary
"Advanced MySQL Topics" is an in-depth IT & Computer Science course designed to elevate your database engineering skills. Taught by Coursera, it covers advanced SQL statements, user-defined functions, optimization techniques, triggers, events, and more. With a duration of 1140 minutes, this professional-level course is ideal for those with prior MySQL experience, offering both Starter and Professional subscription options. Enhance your data analysis and database management proficiency and boost your career prospects.
Taught by Meta Staff