Monthly Subscription Starting at AED 99 + VAT

Advanced MySQL Topics
  • Level Professional
  • المدة 19 ساعات hours
  • الطبع بواسطة Meta
  • Offered by

عن

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.

الوحدات

Course Introduction

    • 1 Videos
    • 3 Readings
    • 1 Discussion
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Instructor

Taught by Meta Staff