Data Analyst Bootcamp
Unlock Your Data Journey: Become a Data Analyst for Free with Alex The Analyst!
What you'll learn
- Understand database installation and management using MySQL
- Learn data visualization techniques in Excel and Tableau
- Develop basic programming skills in Python for data analysis
- Gain knowledge in using Azure and AWS for data storage and processing
This course includes
- 23.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 68 lessons • 23.5 hours of video
Master Data Analysis: Your Free Bootcamp Journey
68 lessons
• 18.5 hours
Master Data Analysis: Your Free Bootcamp Journey
- FREE Data Analyst Bootcamp!! 06: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 03:46
- Limit + Aliasing in MySQL | MySQL Beginner Series 03:57
- Joins in MySQL | Intermediate MySQL 17:11
- Unions in MySQL | Intermediate MySQL 07:22
- String Functions in MySQL | Intermediate MySQL Series 11:54
- Case Statements in MySQL | Intermediate MySQL 08: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 07: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
- 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 06: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
- 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 07:15
- If Else Statements in Python | Python for Beginners 06:40
- For Loops in Python | Python for Beginners 09:17
- While Loops in Python | Python for Beginners 05:40
- Functions in Python | Python for Beginners 12:44
- Converting Data Types in Python | Python for Beginners 06: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 05:55
- BeautifulSoup + Requests | Web Scraping in Python 06: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 06: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 07: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 06:50
- How To Download Your Data Analyst Bootcamp Certification (Congrats!!) 01:41
