SQL for Data Engineering - Full Course for Beginners
Key Takeaways
This video course covers SQL for data engineering, including SQL foundations, data analysis, and data warehousing, using tools like DuckDB and GitHub.
Original Description
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
DuckDB Install (Don't use DuckDB.org) 👉 https://lukeb.co/duckdb
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
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from Luke Barousse · Luke Barousse · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Connect Google Sheets to Tableau & Joining Data - Tableau Tutorial P.1
Luke Barousse
How To Use Tableau Desktop Controls - Tableau Tutorial P.2
Luke Barousse
Dimensions Vs Measures (Blue Vs Green Data) - Tableau Tutorial P.3
Luke Barousse
Create Stacked Bar Chart (and any other visuals EASILY!) w/ Show Me! - Tableau Tutorial P.4
Luke Barousse
Conditional Format Tables in Tableau (Like Excel!) - Tableau Tutorial P.5
Luke Barousse
Calculated Fields in Tableau (Formulas & IF Statements) - Tableau Tutorial P.6
Luke Barousse
Parameters (Create & Use in Calculated Fields and/or Visuals) - Tableau Tutorial P.7
Luke Barousse
Totals, Average Lines, & Trend Lines (Analytics Pane) - Tableau Tutorial P.8
Luke Barousse
How To Create a Dashboard - Tableau Tutorial P.9
Luke Barousse
Upload your dashboard to Tableau Public - Tableau Tutorial P.10
Luke Barousse
Install Python for Data Science on Mac & Windows (PC) with Anaconda - P.1
Luke Barousse
How to run Python for Data Science - Editors vs IDEs - P.2
Luke Barousse
Install VS Code with Python for Data Science / Data Analysis - P.3
Luke Barousse
Understanding Virtual Environments for Data Science / Data Analysis - P.4
Luke Barousse
Using VS Code with Python for Data Science / Data Analysis - P.5
Luke Barousse
Python for Data Science / Analysis ft. 'The Office' Dataset - P.0
Luke Barousse
Python Objects frequently used in Data Science / Data Analysis - P.1
Luke Barousse
Python If Statements for Data Science / Data Analysis - P.2
Luke Barousse
Python For & While Loops for Data Science / Data Analysis - P.3
Luke Barousse
Python List Comprehension for Data Science / Data Analysis - P.4
Luke Barousse
Python Functions for Data Science / Data Analysis - P.5
Luke Barousse
Lambda Functions for Data Science / Data Analysis - Python P.6
Luke Barousse
How NOT to learn Python for Data Science
Luke Barousse
What is Business Intelligence (BI)? 📊😅
Luke Barousse
Top 3️⃣ Technical Skills for Business Intelligence 📚📊
Luke Barousse
Top Non-technical Skills for Business Intelligence 📊👨🏼💻
Luke Barousse
M1 vs Intel Mac for Data Science
Luke Barousse
M1 vs Intel Mac for Excel 📈👨🏼💻
Luke Barousse
M1 vs Intel Mac for Python 🐍👨🏼💻
Luke Barousse
M1 vs Intel Mac for Business Intelligence Tools 💻📊
Luke Barousse
M1 Macbook Air vs Pro (8 vs 16 GB) for Data Science
Luke Barousse
Python for M1 Mac vs Intel (SPOILER: M1 is 2x faster)
Luke Barousse
Data Analyst's WFH Setup & Upgrades
Luke Barousse
Windows on the M1 Mac - What are your options?
Luke Barousse
Install your favorite Windows app on M1 Mac - ft. Parallels
Luke Barousse
Data Science shortcuts for Mac
Luke Barousse
Day in the life of a data analyst
Luke Barousse
Power BI vs Tableau - Best BI Tool
Luke Barousse
Mac Vs PC - BEST for Data Science
Luke Barousse
Data Scientist vs Data Analyst (funny!)
Luke Barousse
Become a DATA ANALYST with NO degree?!? The Google Data Analytics Professional Certificate
Luke Barousse
Certificates vs Degree for Data Analysts (ft. Google Data Analytics Professional Certificate)
Luke Barousse
Google vs IBM Data Analyst Certificate - BEST Certificate for Data Analysts
Luke Barousse
Python Vs R (funny!)
Luke Barousse
THIS got me my job as a Data Analyst - My portfolio tip
Luke Barousse
I used Python to Count my Bike Jumps!
Luke Barousse
Standout as a Data Analyst with THIS TOOL
Luke Barousse
STOP using Spreadsheets for Everything!
Luke Barousse
Transition into Data Science - My Tips & Story
Luke Barousse
Get a JOB w/ Google Data Analytics Certificate?!? (ft. Certificate Holders)
Luke Barousse
Staying Motivated in Data Science
Luke Barousse
Data Science - Expectation vs Reality (funny!) - ft. @KenJee_ds
Luke Barousse
Get NOTICED in Data Science!!! (3 types of GREAT projects)
Luke Barousse
Use THIS to showcase EXPERIENCE in Data Science
Luke Barousse
How to show EXPERIENCE... when you have NONE?!?
Luke Barousse
Learn PYTHON to be a DATA ANALYST?!? (or is R enough...)
Luke Barousse
The BIGGEST MISTAKE when starting a data project!
Luke Barousse
Top Jobs in Data Science
Luke Barousse
How to get Data Analytics side jobs - NEW LinkedIn Feature
Luke Barousse
Building a bot to scrape job data… How NOT to collect data
Luke Barousse
More on: SQL Analytics
View skill →
Related Reads
📰
📰
📰
📰
What Can We Do When Memory Becomes the New Bottleneck in Data Engineering?
Towards Data Science
Migrate from Ponder to Envio HyperIndex
Dev.to · Envio
Data Backfilling with Apache Airflow: Architectures and Implementations for Historical Data Processing
Dev.to · Wangila russell
Building a Production-Style Weather Analytics Pipeline from Scratch: ETL, ELT, Star Schema, and…
Medium · Python
Chapters (41)
Course Intro
6:11
What is SQL?
12:15
Data & Pipeline Intro
18:39
SQL & Dataset Setup
32:39
Basic Keywords
52:06
Comparison & Logical Operators
1:14:52
Wildcards & Aliases
1:26:10
Arithmetic Operators
1:38:10
Aggregate Functions
1:55:01
Terminal Intro
2:28:32
Local DuckDB Intro
3:06:24
VS Code Intro
3:28:56
Data Modeling Pt.1
3:49:10
JOINs
4:11:34
Order of Execution
4:30:51
Project #1 Intro
4:38:54
EDA #1 In-Demand Skills
4:47:27
EDA #2 Highest Paying Skills
4:56:02
EDA #3 Most Optimal Skills
5:10:58
README.md Build
5:27:27
Git & GitHub Pt.1
6:03:49
Share Project #1
6:10:27
Data Types
6:27:17
DDL & DML Pt.1
7:04:57
DDL & DML Pt.2
7:30:28
Subqueries and CTEs
8:06:07
DDL & DML Pt.3
8:44:55
Data Modeling Pt.2
9:08:07
CASE Expressions
9:28:54
Date Functions
9: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
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
🎓
Tutor Explanation
DeepCamp AI