Courses › Data Science
Data Analyst Bootcamp
By Alex The Analyst · English · Beginner
SQL, Excel, Tableau, Power BI and Python — a complete free data analyst course.
A free YouTube playlist, organised on Codify: your progress is saved, you can take timestamped notes and practise in the code editor under every video. All videos belong to their creator.
What this course covers (84 videos)
- FREE Data Analyst Bootcamp!! (6:52)
- How to Become a Data Analyst in 2023 (Completely FREE!) (13:59)
- Installing MySQL and Creating Databases | MySQL for Beginners (12:04)
- Select Statement in MySQL | Beginner MySQL Series (11:00)
- Where Clause in MySQL | Beginner MySQL Series (12:27)
- Group By + Order By in MySQL | Beginner MySQL Series (10:46)
- Having vs Where in MySQL | Beginner MySQL Series (3:46)
- Limit + Aliasing in MySQL | MySQL Beginner Series (3:57)
- Joins in MySQL | Intermediate MySQL (17:11)
- Unions in MySQL | Intermediate MySQL (7:22)
- String Functions in MySQL | Intermediate MySQL Series (11:54)
- Case Statements in MySQL | Intermediate MySQL (8:53)
- Subqueries in MySQL | Intermediate MySQL (11:01)
- Window Functions in MySQL | Intermediate MySQL (13:29)
- CTEs in MySQL | Advanced MySQL Series (10:31)
- Temp Tables in MySQL | Advanced MySQL Series (7:46)
- Stored Procedures in MySQL | Advanced MySQL Series (12:37)
- Triggers and Events in MySQL | Advanced MySQL Series (14:42)
- Data Cleaning in MySQL | Full Project (51:11)
- MySQL Exploratory Data Analysis | Full Project (32:44)
- Pivot Tables in Excel | Excel Tutorials for Beginners (17:35)
- Formulas in Excel | Excel Tutorials for Beginners (33:54)
- XLOOKUP in Excel | Excel Tutorials for Beginners (18:47)
- Conditional Formatting in Excel | Excel Tutorials for Beginners (20:59)
- Charts in Excel | Excel Tutorials for Beginners (15:11)
- Cleaning Data in Excel | Excel Tutorials for Beginners (21:04)
- Full Project in Excel | Excel Tutorials for Beginners (40:50)
- How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners (17:04)
- How to use Calculated Fields and Bins in Tableau | Tableau Tutorials for Beginners (6:25)
- How to Create Visualizations in Tableau | Tableau Tutorials for Beginners (14:05)
- How to use Joins in Tableau | Tableau Tutorials for Beginners (14:29)
- Full Beginner Project in Tableau | Tableau Tutorials for Beginners (44:18)
- How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners (12:50)
- How to use Power Query in Power BI | Microsoft Power BI for Beginners (13:07)
- How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners (8:36)
- How to use DAX in Power BI | Microsoft Power BI for Beginners (15:44)
- How to use Drill Down in Power BI | Microsoft Power BI for Beginners (6:02)
- How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners (9:54)
- How to use Bins and Lists in Power BI | Microsoft Power BI for Beginners (9:31)
- Popular Visualizations in Power BI | Microsoft Power BI for Beginners (14:14)
- Full Power BI Guided Project | Microsoft Power BI for Beginners (42:37)
- Installing Jupyter Notebooks/Anaconda | Python for Beginners (10:03)
- Variables in Python | Python for Beginners (13:17)
- Data Types in Python | Python for Beginners (21:58)
- Comparison, Logical, and Membership Operators in Python | Python for Beginners (7:15)
- If Else Statements in Python | Python for Beginners (6:40)
- For Loops in Python | Python for Beginners (9:17)
- While Loops in Python | Python for Beginners (5:40)
- Functions in Python | Python for Beginners (12:44)
- Converting Data Types in Python | Python for Beginners (6:36)
- Building a BMI Calculator with Python | Python Projects for Beginners (14:23)
- Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners (16:51)
- Inspecting Web Pages with HTML | Web Scraping in Python (5:55)
- BeautifulSoup + Requests | Web Scraping in Python (6:58)
- Find and Find_All | Web Scraping in Python (12:10)
- Scraping Data from a Real Website | Web Scraping in Python (25:23)
- Reading in Files in Pandas | Python Pandas Tutorials (19:17)
- Filtering Columns and Rows in Pandas | Python Pandas Tutorials (11:49)
- Indexes in Pandas | Python Pandas Tutorials (11:22)
- Group By and Aggregate Functions in Pandas | Python Pandas Tutorials (11:05)
- Merging DataFrames in Pandas | Python Pandas Tutorials (22:09)
- Creating Visualizations using Pandas Library | Python Pandas Tutorials (16:50)
- Data Cleaning in Pandas | Python Pandas Tutorials (38:37)
- Exploratory Data Analysis in Pandas | Python Pandas Tutorials (32:13)
- Amazon Web Scraping Using Python | Data Analyst Portfolio Project (47:14)
- Automating Crypto Website API Pull Using Python | Data Analyst Project (51:14)
- How to Create a Portfolio Website for FREE (35:29)
- Create the Perfect Data Analyst Resume | Free Templates! (17:37)
- Solving Easy SQL Interview Questions on Analyst Builder (12:18)
- Solving Medium SQL Interview Questions on Analyst Builder (12:24)
- Solving HARD SQL Interview Questions on Analyst Builder (21:26)
- Solving VERY HARD SQL Interview Questions on Analyst Builder (17:03)
- Azure Account Setup + $200 Free Credits | Azure Fundamentals (6:37)
- Blob Storage and Storage Accounts in Azure | Azure Fundamentals (15:41)
- How to use Azure SQL Databases | Azure Fundamentals (13:46)
- Getting Started in Azure Data Factory | Azure Fundamentals (24:31)
- Getting Started in Azure Synapse Analytics | Azure Fundamentals (19:37)
- AWS Setup and UI Walkthough | AWS (7:21)
- S3 Storage in AWS | AWS Essentials (14:38)
- Amazon Athena in AWS | AWS Fundamentals (24:33)
- AWS Glue DataBrew and Glue | AWS Essentials (45:32)
- AWS Quicksight | AWS Essentials (12:10)
- Top 3 Tips on Using LinkedIn to Land a Job (6:50)
- How To Download Your Data Analyst Bootcamp Certification (Congrats!!) (1:41)
More Data Science courses
- 100 Days of Machine Learning — CampusX · Data Science · Hindi
- 100 Days of Deep Learning — CampusX · Data Science · Hindi
- Generative AI & Agentic AI — Krish Naik Hindi · Data Science · Hindi