SQL for Data Analytics - Learn SQL in 4 Hours

Published: 11 March 2024
on channel: Luke Barousse

1,374,576

33k

📁 FREE Course Databases & Links 👉 https://lukebarousse.com/sql
🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/sql

⚠️ Fix Database Load Issue in Ch 2 👉    • SQL for Data Analytics: Database Load Issu...
IMPORTANT: Drop the database and reload the tables before proceeding. (Instructions in pinned comment)

My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse

𝗖𝗵 1️⃣ - 𝗕𝗮𝘀𝗶𝗰𝘀
▔▔▔▔▔▔▔
0:00:00 - Welcome
0:03:43 - What is SQL
0:10:44 - Intro to Course
0:16:51 - The Basics
0:33:59 - Comparisons
0:41:18 - Practice Problem 1
0:45:23 - Wildcards
0:48:49 - Alias: AS
0:51:06 - Practice Problem 2
0:54:01 - Operations
0:59:37 - Aggregation
1:06:28 - Practice Problem 3
1:08:45 - NULL Values
Skipped - Practice Problem 4
1:10:07 - JOINS
1:20:15 - Order of Execution
1:22:35 - Practice Problem 5

𝗖𝗵 2️⃣ - 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱
▔▔▔▔▔▔▔▔
1:26:18 - Setup PostgreSQL
1:32:48 - IDE Install: VS Code
1:44:08 - Data Types
1:47:35 - Manipulate Tables
2:00:00 - Database Load
2:10:02 - Date Functions
2:20:26 - Problem Problem 6
2:25:02 - CASE Expression
2:30:24 - SubQueries and CTEs
2:42:21 - Practice Problem 7
2:50:11 - UNION Operators
2:54:28 - Practice Problem 8

𝗖𝗵 3️⃣ - 𝗣𝗿𝗼𝗷𝗲𝗰𝘁
▔▔▔▔▔▔▔
2:58:11 - About the Project
3:02:17 - Create the Repository
3:14:50 - Query 1 - Top Paying Jobs
3:20:42 - Query 2 - Top Paying Job's Skills
3:28:10 - Query 3 - In-Demand Skills
3:34:14 - Query 4 - Top Paying Skills
3:41:37 - Query 5 - Most Optimal Skills
3:53:14 - Share on GitHub
4:05:16 - Share on LinkedIn

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮
▔▔▔▔▔▔▔
📫Newsletter: https://www.lukebarousse.com/
👨🏼‍💼 Linkedin:   / luke-b
🅧 X/Twitter:   / lukebarousse
🌄 Instagram:   / lukebarousse
⏰ TikTok:   / lukebarousse

Thanks to Kelly Adams for her work in producing this course 🎉🙌
👩🏻‍💼 Kelly's LinkedIn:   / kellyjianadams
🌐 Kelly's Website: https://www.kellyjadams.com/

#sql #postgresql #sqlite

On this page of the site you can watch the video online SQL for Data Analytics - Learn SQL in 4 Hours with a duration of hours minute second in good quality, which was uploaded by the user Luke Barousse 11 March 2024, share the link with friends and acquaintances, this video has already been watched 1,374,576 times on youtube and it was liked by 33 thousand viewers. Enjoy your viewing!

7,320

201