Master SQL fundamentals through advanced concepts in this comprehensive video tutorial that progresses from basic database setup to complex data analysis. Begin with MySQL installation and database configuration before advancing through essential SQL commands like SELECT statements and WHERE clauses. Explore data manipulation techniques including GROUP BY operations, joins, unions, and string functions. Dive into advanced topics such as case statements, subqueries, window functions, CTEs, and stored procedures. Apply learned concepts through hands-on data cleaning and exploratory data analysis projects. Includes practical demonstrations using real datasets, covering database triggers, events, and performance optimization techniques. Perfect for aspiring data analysts and database professionals looking to build a strong foundation in SQL while gaining practical experience with industry-standard tools and methodologies.
SQL - From Beginner to Advanced: Database Operations and Analysis
Overview
Syllabus
Intro
Installing MySQL and Setting up Database
Select Statement
Where Clause
Group By
Having vs Where
Limit and Aliasing
Joins
Unions
String Functions
Case Statements
Subqueries
Window Functions
CTEs
Temp Tables
Stored Procedures
Triggers and Events
Data Cleaning Project
Exploratory Data Analysis Project
Taught by
Alex the Analyst
