SQL for Data Analytics - Learn SQL in 4 Hours
Course Links, Problems, & Notes
️ Fix Database Load Issue in Ch 2
Thanks to Kelly Adams for her work in producing this course
Kelly's LinkedIn:
Kelly's Website:
Ch 1️⃣ - Basics
==============
00:00 - Welcome
03:43 - What is SQL
10:44 - Intro to Course
16:51 - The Basics
33:58 - Comparisons
41:16 - Practice Problem 1
45:21 - Wildcards
48:47 - Alias: AS
51:04 - Practice Problem 2
53:58 - Operations
59:34 - Aggregation
1:06:25 - Practice Problem 3
1:08:42 - NULL Values
Skipped - Practice Problem 4
1:10:03 - JOINS
1:20:11 - Order of Execution
1:22:31 - Practice Problem 5
Ch 2️⃣ - Advanced
==============
1:26:14 - Setup PostgreSQL
1:32:43 - IDE Install: VS Code
1:44:03 - Data Types
1:47:29 - Manipulate Tables
1:59:54 - Database Load
2:09:55 - Date Functions
2:20:18 - Problem Problem 6
2:24:54 - CASE Expression
2:30:16 - SubQueries and CTEs
2:42:12 - Practice Problem 7
2:50:02 - UNION Operators
2:54:19 - Practice Problem 8
Ch 3️⃣ - Project
==============
2:58:01 - About the Project
3:02:07 - Create the Repository
3:14:39 - Query 1 - Top Paying Jobs
3:20:31 - Query 2 - Top Paying Job's Skills
3:27:59 - Query 3 - In-Demand Skills
3:34:02 - Query 4 - Top Paying Skills
3:41:25 - Query 5 - Most Optimal Skills
3:53:01 - Share on GitHub
4:05:03 - Share on LinkedIn
Social Media / Contact Me
======================
Newsletter:
Linkedin:
🅧 X/Twitter:
Instagram:
⏰ TikTok:
Watch video SQL for Data Analytics - Learn SQL in 4 Hours online without registration, duration 04 hours 08 minute 41 second in high hd quality. This video was added by user Luke Barousse 11 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 420 thousand once and liked it 15 thousand people.