Data Engineer Bootcamp (FREE 27+ Hour Course) - SQL, Python, Cloud, Bash, AI, Git & GitHub

Free 10-Day Data Engineer Crash Course 👉 https://lukeb.co/de-crash-course
Data Engineer Course Bundle (470+ interview problems, certificates, & more) 👉 https://lukeb.co/data-engineer-bundle

𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 𝗕𝗼𝗼𝘁𝗰𝗮𝗺𝗽
▔▔▔▔▔▔▔▔▔▔▔▔
0:00:00 Bootcamp Intro
0:11:01 Fundamentals: Intro
0:13:24 Fundamentals: Stages - DE Lifecycle
0:35:16 Fundamentals: Undercurrents - DE Lifecycle
0:42:42 Fundamentals: Top DE Skills to Focus

𝗦𝗤𝗟 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴
▔▔▔▔▔▔▔▔▔▔▔
0:47:22 SQL Intro
1:06:01 Ch 1 - Setup & Basics
1:39:28 Ch 1 - Operators & Functions
2:42:23 Ch 1 - Terminal Intro
3:15:54 Ch 1 - Local DuckDB Intro
3:53:46 Ch 1 - VS Code Intro
4:16:18 Ch 1 - Data Modeling & JOINs
5:18:13 Project #1 - Exploratory Data Analysis
6:57:49 Ch 2 - Data Types
7:14:39 Ch 2 - DDL & DML
8:17:50 Ch 2 - Subqueries & CTEs
9:32:17 Ch 2 - Data Modeling Pt.2
10:16:15 Ch 2 - Functions (Date, Text, & NULL)
11:13:38 Ch 2 - Window Functions
11:47:26 Ch 2 - Nested Functions
13:19:58 Project #2 - Data Warehouse & ETL Pipeline

𝗖𝗵𝗮𝘁𝗚𝗣𝗧 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔▔▔
15:32:34 ChatGPT Tutorial

𝗣𝘆𝘁𝗵𝗼𝗻 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔▔
16:10:14 Python Intro
16:18:56 Ch 1 - Getting Started
16:48:20 Ch 1 - Data Types
17:44:38 Ch 1 - Lists, Dictionaries, Sets, Tuples
18:31:20 Ch 1 - Loops, List Comprehensions
19:02:26 Ch 1 - Functions, Library, Classes
20:20:58 Ch 1 - NumPy: Intro
20:33:10 Ch 1 - Pandas: Intro
21:27:33 Ch 1 - Matplotlib: Intro
22:01:10 Ch 2 - Python Local Install (Anaconda)
22:37:29 Ch 2 - Pandas: Advanced
24:27:35 Ch 2 - Matplotlib: Format Charts
25:41:53 Ch 2 - Seaborn: Intro
25:55:54 Project #3 - Job & Skill Pipeline Analysis

₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋
𝗟𝗶𝗻𝗸𝘀 & 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
▔▔▔▔▔▔▔▔

𝗦𝗤𝗟 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴
▔▔▔▔▔▔▔▔▔▔▔
📁 FREE Course Files & Project 👉 https://lukeb.co/sql-de-github
🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/sql-de

Attach the data_jobs database using ONE of the following:
-- us-east-1 or eu-central-1 region
ATTACH 'md:_share/data_jobs/87603155-cdc7-4c80-85ad-3a6b0d760d93' AS data_jobs;
-- us-west-2 region
ATTACH 'md:_share/data_jobs/a94f9b8a-2b8a-473f-bb86-de09552f052d' AS data_jobs;
-- eu-west-1 region
ATTACH 'md:_share/data_jobs/058ad1f4-939b-4998-95e1-0df8f8644f3c' AS data_jobs;

⚠️ MotherDuck free trial expired?
No worries — just go to Settings → Plans in the UI and select the Lite plan (still 100% free, no credit card needed)

My Job Market Analytics App 👉 https://datanerd.tech
Project #1 👉 https://lukeb.co/sql-de-project1
Project #2 👉 https://lukeb.co/sql-de-project2
MotherDuck Signup 👉 https://lukeb.co/motherduck
DuckDB Install 👉 https://lukeb.co/duckdb

𝗖𝗵𝗮𝘁𝗚𝗣𝗧 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔▔▔
Data Jobs File 👉🏼 https://lukeb.co/jobs_file

𝗣𝘆𝘁𝗵𝗼𝗻 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔▔
📁 FREE Course Files & Project 👉 https://lukeb.co/python_repo
🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/python

1️⃣ Basics Links
- Dataset (Hugging Face) - https://huggingface.co/datasets/lukebarousse/data_jobs
- Python Docs - https://docs.python.org
- Matplotlib Docs - http://matplotlib.org/
- Matplotlib CheatSheet - https://matplotlib.org/cheatsheets/

2️⃣ Advanced Links
- VS Code Install - https://code.visualstudio.com/download
- Anaconda Install - https://anaconda.com/download/success
- Anaconda Docs - https://docs.conda.io
- Software Jobs CSV - https://lukeb.co/software_csv
- Joins Explained (SQL for Data Analytics) - https://lukeb.co/sql_joins
- Pandas Cheat Sheet - https://pandas.pydata.org/Pandas_Cheat_Sheet.pdf
- Seaborn Docs - https://seaborn.pydata.org/

3️⃣ Project Links
- Git Download - https://git-scm.com/downloads
- GitHub Signup - http://github.com/signup
- Markdown CheatSheet - https://www.markdownguide.org/cheat-sheet/

𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀
▔▔▔▔▔▔▔▔▔▔▔▔
💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA
🛠️ SQL for Data Engineering 👉🏼 https://youtu.be/UjhFbq4uU2Y
❎ 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
🙌 Course Bundles 👉🏼 https://lukeb.co/courses

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮
▔▔▔▔▔▔
📫 Newsletter: https://lukebarousse.com/crash-courses
👨🏼‍💼 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

#dataengineer #bootcamp #datanerd