Power your data pipelines with SerpApi 👉 https://serpapi.link/luke
🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/sql-de

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

𝗖𝗼𝘂𝗿𝘀𝗲 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
▔▔▔▔▔▔▔▔
GitHub Repo 👉 https://lukeb.co/sql-de-github
Project #1 👉 https://lukeb.co/sql-de-project1
Project #2 👉 https://lukeb.co/sql-de-project2
MotherDuck Signup 👉 https://lukeb.co/motherduck
Attach the data_jobs database:
ATTACH ‘md:_share/data_jobs/87603155-cdc7-4c80-85ad-3a6b0d760d93’ AS data_jobs;

0️⃣ 𝗖𝗼𝘂𝗿𝘀𝗲 𝗜𝗻𝘁𝗿𝗼
00: 00: 00 Course Intro
00: 06: 11 What is SQL?
00: 12: 15 Data & Pipeline Intro

1️⃣ 𝗦𝗤𝗟 𝗙𝗼𝘂𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀
00: 18: 39 SQL & Dataset Setup
00: 32: 39 Basic Keywords
00: 52: 06 Comparison & Logical Operators
01: 14: 52 Wildcards & Aliases
01: 26: 10 Arithmetic Operators
01: 38: 10 Aggregate Functions
01: 55: 01 Terminal Intro
02: 28: 32 Local DuckDB Intro
03: 06: 24 VS Code Intro
03: 28: 56 Data Modeling Pt.1
03: 49: 10 JOINs
04: 11: 34 Order of Execution

📊 𝗘𝘅𝗽𝗹𝗼𝗿𝗮𝘁𝗼𝗿𝘆 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝘄/ 𝗦𝗤𝗟 — 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 #1
04: 30: 51 Project #1 Intro
04: 38: 54 EDA #1 In-Demand Skills
04: 47: 27 EDA #2 Highest Paying Skills
04: 56: 02 EDA #3 Most Optimal Skills
05: 10: 58 README.md Build
05: 27: 27 Git & GitHub Pt.1
06: 03: 49 Share Project #1

2️⃣ 𝗣𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻 𝗦𝗤𝗟
06: 10: 27 Data Types
06: 27: 17 DDL & DML Pt.1
07: 04: 57 DDL & DML Pt.2
07: 30: 28 Subqueries and CTEs
08: 06: 07 DDL & DML Pt.3
08: 44: 55 Data Modeling Pt.2
09: 08: 07 CASE Expressions
09: 28: 54 Date Functions
09: 51: 19 SET Operators
10: 08: 04 Text & NULL Functions
10: 26: 16 Window Functions
11: 00: 04 Nested Functions
11: 50: 17 Git & GitHub Pt.2

🏗️ 𝗗𝗮𝘁𝗮 𝗪𝗮𝗿𝗲𝗵𝗼𝘂𝘀𝗲 & 𝗘𝗧𝗟 𝗣𝗶𝗽𝗲𝗹𝗶𝗻𝗲 — 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 #2
12: 32: 36 Project #2 Intro
12: 43: 08 Build Data Warehouse
13: 21: 00 Build Flat Table Mart
13: 40: 03 Build Skills Mart
14: 07: 45 Build Priority Mart
14: 29: 40 README.md Build
14: 40: 58 Share Project #2

𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀
▔▔▔▔▔▔▔▔▔▔▔▔
💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA
❎ Excel for Data Analytics 👉🏼 https://youtu.be/pCJ15nGFgVg
📊 Power BI for Data Analytics 👉🏼 https://youtu.be/FwjaHCVNBWA
🐍 Python for Data Analytics 👉🏼 https://youtu.be/wUSDVGivd-8
⚛️ ChatGPT for Data Analytics 👉🏼 https://youtu.be/uhyMqbZI6rM
🙌 Support my FREE Courses 👉🏼 https://lukeb.co/courses

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮
▔▔▔▔▔▔
📫 Newsletter: https://lukebarousse.com/5daycourse
👨🏼‍💼 LinkedIn: https://www.linkedin.com/in/luke-b/
👾 GitHub: https://github.com/lukebarousse
🅧 X/Twitter: https://twitter.com/LukeBarousse
🌄 Instagram: https://www.instagram.com/lukebarousse/
⏰ TikTok: https://www.tiktok.com/@lukebarousse

𝗧𝗲𝗮𝗺’𝘀 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮
▔▔▔▔▔▔▔▔▔
🎬 Course Producer: Kelly Adams 👉 https://www.linkedin.com/in/kellyjianadams
💻 Content Developer: Rikki Singh 👉 https://www.linkedin.com/in/rikkisingh
📺 Video Editor: Brannon Linder 👉 https://www.linkedin.com/in/brannonlinder

#datanerd #dataengineering #sql