Data Analysis Bootcamp - 19 Hours (SQL, Excel, Tableau, Power BI, Python)

By freeCodeCamp | Free Course on YouTube

4.0
(0 ratings)
1 students enrolled
Q
Created by Qasrawii Academy
Last updated 3/2026 EN Beginner 1420 min total

What you'll learn

Comprehensive data analyst bootcamp covering SQL, Excel, Tableau, Power BI, Python, and Pandas with hands-on projects for building a portfolio.

Course Content

9 sections • 84 lessons • 1420m total length

Getting Started

10 lessons
FREE Data Analyst Bootcamp!! Preview
7:00
How to Become a Data Analyst in 2023 (Completely FREE!) Preview
14:00
Installing MySQL and Creating Databases | MySQL for Beginners Preview
12:00
Select Statement in MySQL | Beginner MySQL Series
11:00
Where Clause in MySQL | Beginner MySQL Series
12:00
Group By + Order By in MySQL | Beginner MySQL Series
11:00
Having vs Where in MySQL | Beginner MySQL Series
4:00
Limit + Aliasing in MySQL | MySQL Beginner Series
4:00
Joins in MySQL | Intermediate MySQL
17:00
Unions in MySQL | Intermediate MySQL
7:00

Fundamentals

10 lessons
String Functions in MySQL | Intermediate MySQL Series
12:00
Case Statements in MySQL | Intermediate MySQL
9:00
Subqueries in MySQL | Intermediate MySQL
11:00
Window Functions in MySQL | Intermediate MySQL
13:00
CTEs in MySQL | Advanced MySQL Series
11:00
Temp Tables in MySQL | Advanced MySQL Series
8:00
Stored Procedures in MySQL | Advanced MySQL Series
13:00
Triggers and Events in MySQL | Advanced MySQL Series
15:00
Data Cleaning in MySQL | Full Project
51:00
MySQL Exploratory Data Analysis | Full Project
33:00

Core Concepts

10 lessons
Pivot Tables in Excel | Excel Tutorials for Beginners
18:00
Formulas in Excel | Excel Tutorials for Beginners
34:00
XLOOKUP in Excel | Excel Tutorials for Beginners
19:00
Conditional Formatting in Excel | Excel Tutorials for Beginners
21:00
Charts in Excel | Excel Tutorials for Beginners
15:00
Cleaning Data in Excel | Excel Tutorials for Beginners
21:00
Full Project in Excel | Excel Tutorials for Beginners
41:00
How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners
17:00
How to use Calculated Fields and Bins in Tableau | Tableau Tutorials for Beginners
6:00
How to Create Visualizations in Tableau | Tableau Tutorials for Beginners
14:00

Intermediate Topics

10 lessons
How to use Joins in Tableau | Tableau Tutorials for Beginners
14:00
Full Beginner Project in Tableau | Tableau Tutorials for Beginners
44:00
How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners
13:00
How to use Power Query in Power BI | Microsoft Power BI for Beginners
13:00
How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners
9:00
How to use DAX in Power BI | Microsoft Power BI for Beginners
16:00
How to use Drill Down in Power BI | Microsoft Power BI for Beginners
6:00
How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners
10:00
How to use Bins and Lists in Power BI | Microsoft Power BI for Beginners
10:00
Popular Visualizations in Power BI | Microsoft Power BI for Beginners
14:00

Advanced Concepts

10 lessons
Full Power BI Guided Project | Microsoft Power BI for Beginners
43:00
Installing Jupyter Notebooks/Anaconda | Python for Beginners
10:00
Variables in Python | Python for Beginners
13:00
Data Types in Python | Python for Beginners
22:00
Comparison, Logical, and Membership Operators in Python | Python for Beginners
7:00
If Else Statements in Python | Python for Beginners
7:00
For Loops in Python | Python for Beginners
9:00
While Loops in Python | Python for Beginners
6:00
Functions in Python | Python for Beginners
13:00
Converting Data Types in Python | Python for Beginners
7:00

Projects & Practice

10 lessons
Building a BMI Calculator with Python | Python Projects for Beginners
14:00
Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners
17:00
Inspecting Web Pages with HTML | Web Scraping in Python
6:00
BeautifulSoup + Requests | Web Scraping in Python
7:00
Find and Find_All | Web Scraping in Python
12:00
Scraping Data from a Real Website | Web Scraping in Python
25:00
Reading in Files in Pandas | Python Pandas Tutorials
19:00
Filtering Columns and Rows in Pandas | Python Pandas Tutorials
12:00
Indexes in Pandas | Python Pandas Tutorials
11:00
Group By and Aggregate Functions in Pandas | Python Pandas Tutorials
11:00

Deep Dive

10 lessons
Merging DataFrames in Pandas | Python Pandas Tutorials
22:00
Creating Visualizations using Pandas Library | Python Pandas Tutorials
17:00
Data Cleaning in Pandas | Python Pandas Tutorials
39:00
Exploratory Data Analysis in Pandas | Python Pandas Tutorials
32:00
Amazon Web Scraping Using Python | Data Analyst Portfolio Project
47:00
Automating Crypto Website API Pull Using Python | Data Analyst Project
51:00
How to Create a Portfolio Website for FREE
35:00
Create the Perfect Data Analyst Resume | Free Templates!
18:00
Solving Easy SQL Interview Questions on Analyst Builder
12:00
Solving Medium SQL Interview Questions on Analyst Builder
12:00

Expert Level

10 lessons
Solving HARD SQL Interview Questions on Analyst Builder
21:00
Solving VERY HARD SQL Interview Questions on Analyst Builder
17:00
Azure Account Setup + $200 Free Credits | Azure Fundamentals
7:00
Blob Storage and Storage Accounts in Azure | Azure Fundamentals
16:00
How to use Azure SQL Databases | Azure Fundamentals
14:00
Getting Started in Azure Data Factory | Azure Fundamentals
25:00
Getting Started in Azure Synapse Analytics | Azure Fundamentals
20:00
AWS Setup and UI Walkthough | AWS
7:00
S3 Storage in AWS | AWS Essentials
15:00
Amazon Athena in AWS | AWS Fundamentals
25:00

Mastery

4 lessons
AWS Glue DataBrew and Glue | AWS Essentials
46:00
AWS Quicksight | AWS Essentials
12:00
Top 3 Tips on Using LinkedIn to Land a Job
7:00
How To Download Your Data Analyst Bootcamp Certification (Congrats!!)
2:00

Description

Comprehensive data analyst bootcamp covering SQL, Excel, Tableau, Power BI, Python, and Pandas with hands-on projects for building a portfolio.

Original course by freeCodeCamp. Curated and organized for optimal learning on Qasrawii LMS.

Requirements

  • A computer with internet access
  • Willingness to learn

Student Reviews

No reviews yet. Be the first to share your experience!

Preview this course
Free Open Access

This course includes:

84 lessons
1420 minutes of content
Beginner level
EN
Full lifetime access
Certificate of completion