SQL for Data Analytics - Learn SQL in 4 Hours

Description:

📁 FREE Course Databases & Links 👉 🏆 Supporter Access: Problems, Certificate, & More 👉 ⚠️ Fix Database Load Issue in Ch 2 👉 IMPORTANT: Drop the database and reload the tables before proceeding. (Instructions in pinned comment) My FREE Course to be a Data Analyst 👉 𝗖𝗵 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: 👨🏼‍💼 Linkedin: 🅧 X/Twitter: 🌄 Instagram: ⏰ TikTok: Thanks to Kelly Adams for her work in producing this course 🎉🙌 👩🏻‍💼 Kelly's LinkedIn: 🌐 Kelly's Website: #sql #postgresql #sqlite