SerpApi Google Search API

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.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