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