Hellow guys, Welcome to my website, and you are watching SQL for Data Analytics - Learn SQL in 4 Hours. and this vIdeo is uploaded by Luke Barousse at 2024-03-11T03:00:11-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | SQL for Data Analytics - Learn SQL in 4 Hours |
| Video Uploader | Video From Luke Barousse |
| Upload Date | This Video Uploaded At 11-03-2024 10:00:11 |
| Video Discription | Course Links, Problems, & Notes 👉 https://lukebarousse.com/sql ⚠️ Fix Database Load Issue in Ch 2 👉 https://lukeb.co/sql_error Thanks to Kelly Adams for her work in producing this course 🎉🙌 👩🏻💼 Kelly's LinkedIn: https://www.linkedin.com/in/kellyjianadams/ 🌐 Kelly's Website: https://www.kellyjadams.com/ 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: https://www.lukebarousse.com/ 👨🏼💼 Linkedin: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse #sql #postgresql #sqlite |
| Category | Science & Technology |
| Tags | data viz by luke | business intelligence | data science | bi | computer science | data nerd | data analyst | data scientist | how to | data project | data analytics | portfolio project | sql | excel | python | power bi | tableau | data engineer |
