Learn SQL for Data Analysis in one hour (with sample dataset + 50 queries)
Informations de téléchargement et détails de la vidéo Learn SQL for Data Analysis in one hour (with sample dataset + 50 queries)
Auteur :
ChandooPublié le :
23/08/2022Vues :
1.3MDescription :
SQL is one of the most important skills to have for data people. In this comprehensive video, learn how to use SQL to perform common data analysis tasks. 0:00 - Introduction 0:43 - Data setup, explanation & basic queries 6:24 - Adding calculated columns in SELECT 8:39 - Our first WHERE clause 10:28 - Ordering query results with ORDER BY 13:24 - More Where clause examples 16:42 - Between conditions 19:06 - Working with Dates 21:50 - Using other tables 23:47 - IN clause 24:36 - Pattern matching in SQL 26:30 - CASE operator and branching logic 30:30 - JOINS 36:32 - LEFT Join vs. RIGHT Join ~ EXPLAINED 38:28 - More Join examples 42:10 - Adding conditions to Joins 47:30 - GROUP BY and creating reports with SQL 54:50 - Showing Top 10 Products by Amount 57:12 - Closing remarks & next steps for you
Vidéos similaires : Learn SQL for Data Analysis in one hour
SQL for Data Analytics - Learn SQL in 4 Hours
MySQL Database - Full Course
Data Cleaning in Excel - 10 Tricks (Beginner to PRO)
SQL Tutorial from Basic to Advanced | 30 Days SQL learning Challenge
SQL from basic to Advanced | Types of Commands in SQL - Day - 2
