@joeychandel7808
Timestamps 00:03 - Learn SQL fundamentals and advanced techniques through practical exercises. 01:52 - Installing MySQL with Developer Default Setup. 05:27 - Completing MySQL configuration and starting the local instance. 07:12 - Creating a sample database for SQL practice. 11:14 - Understanding the SELECT statement in MySQL for querying data. 13:11 - Understanding SQL query execution and database selection best practices. 17:24 - Understanding the order of operations in SQL calculations. 19:27 - Understanding unique values and distinct queries in SQL. 23:12 - Understanding salary comparison operators in SQL queries. 25:17 - Filtering data using 'not equal' and logical operators in SQL. 29:23 - The LIKE statement allows for pattern matching in SQL queries. 31:36 - Using wildcards in SQL for flexible string matching. 35:29 - Understanding non-aggregated columns in SQL grouping. 37:25 - Learn to group data by occupation and salary using SQL. 41:26 - Understanding SQL ordering by multiple columns impacts output results. 43:22 - Understand the risks of using column positions in SQL queries. 47:25 - Understanding SQL HAVING clause and LIMIT for data filtering. 49:18 - Understanding SQL aliasing for clearer query outputs. 53:08 - Joining tables with INNER JOIN requires specifying ambiguous column names. 55:07 - Using aliases simplifies SQL queries for better readability. 58:53 - Explains SQL joins: Left, Right, and Self Joins with practical examples. 1:00:46 - Understanding table joins and employee ID assignment in SQL. 1:04:49 - Understanding reference tables and joining in SQL. 1:06:49 - Using joins to tie multiple SQL tables together effectively. 1:10:35 - Using UNION to combine query results from different tables. 1:12:38 - Filtering and labeling employees based on salary and gender criteria. 1:16:40 - Data cleaning techniques include ensuring length and standardizing case. 1:18:31 - Learn string manipulation functions in SQL, including trim, left, right, and substring. 1:22:13 - Utilizing substring and replace functions for effective data extraction. 1:24:09 - Learn to use SQL functions for text manipulation. 1:27:55 - Using CASE statements to categorize age groups in SQL queries. 1:29:53 - Calculate pay increases and bonuses based on employee salaries. 1:34:13 - Learn to use CASE statements and subqueries for SQL logic and calculations. 1:36:15 - Using subqueries to filter employee demographics based on department IDs. 1:40:21 - Calculating the overall average salary from the employee data. 1:42:25 - Understanding SQL table naming and aggregations with examples. 1:46:18 - Comparing group by and window functions in SQL for salary analysis. 1:48:19 - Calculating average salary with and without partitioning by gender. 1:52:45 - Understanding rolling totals and window functions in SQL. 1:54:34 - Row numbering and partitioning in SQL helps organize data uniquely. 1:58:33 - Understanding Row Number, Rank, and Dense Rank in SQL. 2:00:20 - Using Common Table Expressions (CTE) improves SQL query readability and functionality. 2:04:04 - Common Table Expressions (CTEs) allow temporary data representation without storage. 2:06:18 - Combining data from common table expressions using SQL joins. 2:10:12 - Creating and using temporary tables in SQL. 2:12:09 - Creating and using temporary tables in SQL effectively. 2:16:08 - Understanding advanced CTEs and the creation of stored procedures. 2:18:00 - Created and executed a stored procedure successfully. 2:21:45 - Understanding stored procedures and best practices in SQL. 2:23:46 - Creating and managing stored procedures in SQL. 2:27:18 - Parameter naming conventions enhance SQL readability. 2:29:02 - Using triggers to automatically update related tables in SQL. 2:32:48 - Understanding SQL triggers for automated data insertion. 2:34:51 - Using triggers in SQL to automate actions on data changes. 2:38:38 - Creating an event to retire employees over 60 automatically. 2:40:37 - Creating and troubleshooting SQL events for data deletion. 2:44:04 - Learn how to import data into a new SQL table. 2:45:44 - Overview of data cleaning steps using a layoffs dataset. 2:49:31 - Ensure data integrity by removing duplicates in a staging database. 2:51:13 - Using SQL to identify duplicate entries with ROW_NUMBER() function. 2:55:21 - Removing duplicates in MySQL involves different strategies than in SQL Server. 2:57:08 - Creating and populating SQL tables with data and filtering rows. 3:01:17 - Learn how to update SQL tables and manage preferences for safe updates. 3:03:10 - Standardize industry labels for accurate data analysis. 3:07:20 - Fixing data issues in SQL by trimming unwanted characters. 3:09:33 - Updating country data and converting text to date format. 3:13:22 - Updating and formatting date columns in SQL. 3:15:11 - Modifying data types and handling null values in SQL. 3:19:28 - Updating travel industry data using SQL joins. 3:21:24 - Identifying companies with missing and non-null industry data. 3:25:42 - Resolved issues with null values in SQL queries for company layoffs. 3:27:47 - Cleaning data is crucial for accurate analysis of layoffs. 3:31:35 - Data cleaning is essential for effective exploratory data analysis. 3:33:17 - The basics of analyzing layoffs data using SQL. 3:37:13 - Analyzing employee layoffs among major companies from 2020 to 2023. 3:39:10 - Analysis of job layoffs by industry and country during COVID-19. 3:43:09 - Analyzing post-IPO layoffs and their implications. 3:45:04 - Calculating monthly rolling totals for layoffs using SQL. 3:49:12 - Creating a rolling total for layoffs by month in SQL. 3:51:18 - Job layoffs significantly increased from 2020 to 2023 globally. 3:55:07 - Ranking companies by employee layoffs over the years using SQL. 3:57:09 - Analyze company layoffs over the years using SQL ranking functions. 4:01:34 - Recap of complex SQL query using CTEs for analyzing layoffs. 4:03:25 - Explore advanced SQL projects and enhance your portfolio with real data analysis.
@amazingme894
Hey alex, please never die or delete your channel, I'm lost with what career to get after getting a useless degree and have no technical skills for a job, currently unemployed and living with aging mom, so I'm considering following your channel in the near future after i get over my mental slump. APPRECIATE YOU!!
@Kirito_1777
I am Starting my Data Analyst/Science Journey with this (Big Thanks from me to Alex, he is the best to give us such course for free, that would really help alot of us to learn), i am sharing my progression (if no one mind) My Progress 17/03/2025, i will go slowly: Day 1: #1 (0:00) - (0:51) Intro #2 (0:52) - (11:18) Installing MySQL and Setting up Database #3 (11:19) - (21:46) Select Statement Day 2: #4 (21:47) - (33:53) Where Clause Day 3: #5 (33:53) - (44:17) Group By #6 (44:18) - (47:40) Having vs Where #7 (47:41) - (51:09) Limit and Aliasing #8 (51:10) - (1:08:03) Joins Day 4: #9 (1:08:04) - (1:15:10) Unions #10 (1:15:10) - (1:26:38) String Functions #11 (1:26:39) - (1:35:15) Case Statements #12 (1:35:16) - (1:45:57) Subqueries Day 5: #13 (1:45:58) - (1:58:54) Window Functions #14 (1:58:55) - (2:09:06) CTEs #15 (2:09:07) - (2:16:33) Temp Tables #16 (2:16:34) - (2:28:50) Stored Procedures #17 (2:28:51) - (2:42:45) Triggers and Events
@Nathaniel-codecity
thank you so much for your free youtube course with your bootcamp, I'm now a data analytics instructor in Lagos, Nigeria.
@ZaulT-j4p
Dude, this is the greatest SQL tutorial on Youtube. Covers all the important topics with great examples and communication. Thank you so much!
@JewelUddin-d9j
Day-1: 44:17 --> Group By Day-2: 1:15:13 --> Unions Day-3 1:39:36 --> Subqueries
@zaighamzaidi7857
@22:00 where clause @26:30 logical operators @29:55 Like clause @34:30 Group By @40:00 Order BY @45:15 Having @47:45 Limit & Aliasing @51:10 Joins @57:20 Outer Joins @1:11:25 UNIONs @1:15:14 String Functions @1:26:40 CASE Statements @1:35:15 Sub Queries @1:46:00 Windows Functions @1:59:16 CTEs - Common Table Expressions @2:09:11 Temp Tables @2:16:38 Stored Procedures @2:29:10 Triggers and Events @2:42:50 Data Cleaning Project @3:32:20 Exploratory Data Analysis Project
@MwishaLudack
Your tutorials are the best. Let me just say that I watched the others, but you are by far the most clear instructor I've watched so far. Thank you
@zohraserhenova
Wow! I was just looking for a comprehensive SQL tutorial which was not 10 years old lol. Thank you! Right on time :)
@ManuchehrKabirov
Hello Alex, Without any background in MySQL, I started with this video. It was a great experience for me, like starting the engine of a car and making it start moving (a journey of a thousand miles begins with a single step). I want to say a big thank you for the practical way you showed it.
@GabrielBarbosa-2408
Just started last night and i'm finishing now. I don't really like to watch tutorials but this one was effortless as I was writting it alongisde. I'll start to practice just after as I have an interview as a backend and I need to nail it. Thank you.
@MR.JAM_687
By the way i have completed your EXCEL TUTORIAL FOR DATA ANALYST and i was about to go for SQL and finally you posted this video today 😅
@willyamwambugu
Hello Alex, thank you for your continued support in helping me(us) a beginner in SQL understand it in pursuit of upskilling. Just an observation, I don't know if it's me only or anyone else, but while installing the MySQL on my laptop, the workbench, router and samples execution were absent, though I followed your steps, opened the installer again, it prompted me to a UI with add, upgrade, modify and catalog buttons, chose the catalog option and selected the MySQL workbench, router and samples and installed them manually from the catalog. If anyone else experienced this too leave a comment here to help others learn.
@Harold1526
Thank you Alex, You are by far one of my favorite youtube channels about data and technical skills. I am still in the learning process and I am thankful for your free resources. Thanks a lot!
@kartikarorayt
Thank God I found your channel. I purchased a BootCamp but found nothing worth learning about data analysis. Keep inspiring like this. God bless.
@YannikSpeath
I literally have an SQL Joints test tomorrow and have to binge this entire thing. Thank you so much for this awesome Course!
@alexgraham3529
Nearing the end of this as a refresher, not a SQL admin by any stretch but been great to remind myself due to being an Solution Arch of all these data aspects to a solution which allows me to have enough of an understanding when speaking with engineers, especially when my background before cloud was really Infra ( I'll build you a datacentre ). Thanks for the effort Alex.
@randomytnametonotshowrealname
Hey @Alex The Analyst, thank you very much for this video. It was really easy to follow and I actually had fun learning SQL. SQL just seems so easy to understand and all the commands make so much sense. I noticed at 3:07:11 that there were two locations that appeared twice in the data set, Malmo/Malmö and Dusseldorf/Düsseldorf. It seems like the person who inserted these data rows used the umlaut from the native spelling which causes problems if it is not imported through the right encoding method. It's a very detailed and minor thing but if you want to calculate with this data, e.g. which cities in Germany or Sweden had the highest layoffs, and be 100% accurate then the locations need to be combined. Anyway, thank you for this condensed SQL tutorial.
@Sankalp-sd6fm
34:10 group by, order by 44:18 having vs where
@palaceprincess