Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)

From the creator

Become a data analyst by following along with this massive course. You will learn the core topics that data analysts need to know. And along the way, you will build plenty of projects to gain hands-on experience. ✏️ Bootcamp developed by @AlexTheAnalyst 🔗 Analyst Builder: https://www.analystbuilder.com/ 💻 Access the datasets used here: https://github.com/AlexTheAnalyst ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp ⭐️ Chapters ⭐️ 00:00:00 Introduction 00:01:10 How to Become a Data Analyst in 2023 (Completely FREE!) 00:15:08 SQL Basics Tutorial | Installing SQL Server Management Studio and Create Tables 00:24:44 SQL Basics Tutorial | Select + From Statements 00:30:57 SQL Basics Tutorial | Where Statement 00:38:54 SQL Basics Tutorial | Group By + Order By Statements 00:47:03 Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases 01:02:55 Intermediate SQL Tutorial | Unions | Union Operator 01:08:19 Intermediate SQL Tutorial | Case Statement | Use Cases 01:15:44 Intermediate SQL Tutorial | Having Clause 01:19:15 Intermediate SQL Tutorial | Updating/Deleting Data 01:23:51 Intermediate SQL Tutorial | Aliasing 01:30:02 Intermediate SQL Tutorial | Partition By 01:34:16 Advanced SQL Tutorial | CTE (Common Table Expression) 01:37:59 Advanced SQL Tutorial | Temp Tables 01:48:18 Advanced SQL Tutorial | String Functions + Use Cases 02:02:06 Advanced SQL Tutorial | Store

Published 2024-01-09 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.