Advanced MySQL for Data Analytics

Course details

Take your MySQL skills to the next level. Designed for those seeking to delve deeper into SQL and optimize their data analysis workflows, this course covers advanced concepts and techniques designed to elevate your proficiency in MySQL. Explore advanced topics such as common table expressions (CTEs) that empower you to write complex queries and perform recursive operations. Plus, dive into the world of stored procedures, learning how to create reusable code blocks that enhance efficiency and streamline data processing tasks.

Concepts

Introduction

Instructor and course introductions
Downloading MySQL and set up database

CTEs and Temp Tables

CTE and temp table intro
Using a CTE
Recursion in CTEs
Temporary tables
Temp tables vs. CTEs

Stored Procedures

Stored procedures introduction
Stored procedures basics
Parameters in stored procedures
Default values as parameters
Output parameters
Session vs. local variables

Triggers and Events

Triggers and events introduction
Creating triggers
Viewing and deleting triggers
Creating and updating events

Indexing for Performance

Indexing introduction
Create an index
Prefix indexes
Composite indexes
Understanding indexes better and best practices

Full Project

Automated data cleaning project

Congratulations

Congratulations