SQL for Data Analytics - Learn SQL in 4 Hours

Course Problems & Certificate 👉 lukeb.co/sql
Course Databases & Links 👉 lukebarousse.com/sql

⚠️ Fix Database Load Issue in Ch 2 👉 lukeb.co/sql_error
IMPORTANT: Drop the database and reload the tables before proceeding. (Instructions in pinned comment)

My FREE Course to be a Data Analyst 👉 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: www.lukebarousse.com/
👨🏼‍💼 Linkedin: www.linkedin.com/in/luke-b/
🅧 X/Twitter: twitter.com/LukeBarousse
🌄 Instagram: www.instagram.com/lukebarousse/
⏰ TikTok: www.tiktok.com/@lukebarousse

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

#sql #postgresql #sqlite