Skip to content
Sabaqاردو

Data Analyst Bootcamp (Alex The Analyst)

By Alex The Analyst

Course audio
Course audio: English
Level
Beginner
Length
15 lessons

What you'll be able to do

  • Write MySQL queries from basic SELECTs to window functions
  • Combine tables with joins, unions and CTEs
  • Plan the tools and projects for an analyst portfolio

About this course

Alex Freberg, a working data analyst who runs Alex The Analyst, built this free bootcamp as a full path into the job. It starts with how to become a data analyst, then teaches MySQL from installing it and creating databases through SELECT, WHERE, GROUP BY and ORDER BY, HAVING versus WHERE, LIMIT and aliasing, joins, unions, string functions, CASE statements, subqueries, window functions and CTEs. Later sections cover Excel, Tableau, Power BI, Python and portfolio projects. It suits beginners aiming for an analyst role. Build the portfolio projects as you finish each tool.

Before you start: Basic computer skills; no coding needed

Syllabus

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

  1. 1FREE Data Analyst Bootcamp!!
  2. 2How to Become a Data Analyst in 2023 (Completely FREE!)
  3. 3Installing MySQL and Creating Databases | MySQL for Beginners
  4. 4Select Statement in MySQL | Beginner MySQL Series
  5. 5Where Clause in MySQL | Beginner MySQL Series
  6. 6Group By + Order By in MySQL | Beginner MySQL Series
  7. 7Having vs Where in MySQL | Beginner MySQL Series
  8. 8Limit + Aliasing in MySQL | MySQL Beginner Series
  9. 9Joins in MySQL | Intermediate MySQL
  10. 10Unions in MySQL | Intermediate MySQL
  11. 11String Functions in MySQL | Intermediate MySQL Series
  12. 12Case Statements in MySQL | Intermediate MySQL
  13. 13Subqueries in MySQL | Intermediate MySQL
  14. 14Window Functions in MySQL | Intermediate MySQL
  15. 15CTEs in MySQL | Advanced MySQL Series

What to take next

Videos by Alex The Analyst, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request