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 based on your region by running ONE of the following: -- us-east-1 or eu-central-1 ATTACH 'md:_share/data_jobs/87603155-cdc7-4c80-85ad-3a6b0d760d93' AS data_jobs; -- us-west-2 ATTACH 'md:_share/data_jobs/a94f9b8a-2b8a-473f-bb86-de09552f052d' AS data_jobs; -- eu-west-1 ATTACH 'md:_share/data_jobs/058ad1f4-939b-4998-95e1-0df8f8644f3c' AS data_jobs; -- ap-northeast-1 ATTACH 'md:_share/data_jobs/bfebcfd1-016a-4f13-87b1-e6cb852eda98' AS data_jobs; -- ap-southeast-2 ATTACH 'md:_share/data_jobs/dddd85e6-ba93-40d0-8649-bc91194f0afe' 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
ADVERTISEMENT
Guys pls remind me whenever you see my comment just like it so that I complete it at the earliest and I will update after completing the course ...thanks!
I searched for a data engineering course hoping to find you again since i finished your data analyst full course for my internship. I was planning to shift professions for my second internship semester to being a data engineer and cam across this video. I was wondering why this video had very low views, till turns out it was 28 minutes ago. Right on cue, guess it was fate for me to finish this as well 😂.
Next course please on Cloud Computing
This bootcamp is absolute GOLD for future data engineers. Amazing job, Luke! ❤
Can you make a second course for mid-level to senior-level data professionals? I see many beginner-level courses, but no senior-level courses.
Data Nerds! I also have a FREE 10-Day Data Engineering Crash Course 👇 /de-crash-course It's a great supplement to this bootcamp that teaches: • What DEs actually do day-to-day • The strategies that got me hired • The concepts & tools to stand out 10 emails, one per day. Delivered straight to your inbox. 📥
I just finished your BootCamp after about 2 weeks of dedicating 3-4 hours each day. Even though I knew SQL and Python, I was overwhelmed by how deep you go into Pandas and Matplotlib. I thought I knew Pandas decently, but you took it to a new level that made my brain scream for a break. It was a nice challenge and was definitely needed. I aslo appreciate the Git/Github portions that I was not to familiar with. I understood the basics, but nothing beyond that. Truly a great course that helps me freshen up as I prepare to venture out into the Date Engineering world once again.
Luke for President
I think Terraform is a very important skill for Data Engineer to have.
Thankyou Luke for creating this amazing bootcamp, really needed this one !!🤩😍🥳❤️✨💥
watching and learning from Uzbekistan. Thanks Luke for making this free for all
Hi Luke, can you upload learning content for senior, advanced and expert levels as well. Java course would also be helpful. recommend books as well for advanced and expert learning.
I wanted to learn Data Engineering before going into AI/ML engineering with no degree . However, I almost gave up since I had no clear curriculum, but this video makes it look fun and I really look forward to learning Data engineering now
I completed sql one almost/ on the way of completion of python one and now this video gets pupped up guess i can start this one from the middle hehe
Im determined to finish this by this month :)
Appreciate the effort to make this masterclass 🎉
Sounds great, thank you for your work, Luke
I just found this site and WOW. It is exactly what I have been looking for. I have a BSc in Electrical Engineering and Oracle Certified Professional 8i Application Developer but I quit everything in 2005. Now ready to get back, I have been looking into several programs. This is the perfect one for me. Time to start.
I'm still in the first hour of the tutorial and I'm already grateful, thank you Luke!
fast as Alex