Alex the Analyst Courses

Python Programming Fundamentals - From Variables to Web Scraping with Projects

Master Python fundamentals from variables to web scraping, including hands-on projects like BMI calculator and data extraction. Perfect for beginners wanting practical programming skills.

• YouTube
• 2 hours 32 minutes
• Self-Paced
• Free Video

SQL - From Beginner to Advanced: Database Operations and Analysis

Master SQL fundamentals through advanced concepts with hands-on practice in database management, queries, functions, and real-world projects for data cleaning and exploratory analysis.

• YouTube
• 4 hours 5 minutes
• Self-Paced
• Free Video

AWS Glue and DataBrew - Data Integration and Preparation Essentials

Discover how to leverage AWS Glue and Glue DataBrew for efficient data preparation, transformation, and ETL workflows in AWS cloud environment, with hands-on demonstrations and practical examples.

• YouTube
• 46 minutes
• Self-Paced
• Free Video

Building a Fully Interactive Housing Data Web App with Shiny for Python

Master the creation of interactive web applications with Shiny for Python by building a dynamic housing data dashboard from scratch, incorporating real-world data analysis and visualization techniques.

• YouTube
• 1 hour
• Self-Paced
• Free Video

Shiny for Python - Components and Layouts for Web App Customization

Master the art of customizing web applications with Shiny for Python by exploring essential components and layout techniques for creating dynamic, interactive interfaces.

• YouTube
• 24 minutes
• Self-Paced
• Free Video

MySQL Exploratory Data Analysis Project

Dive into hands-on exploratory data analysis using MySQL through a practical project that demonstrates essential data cleaning and analysis techniques.

• YouTube
• 33 minutes
• Self-Paced
• Free Video

Data Cleaning in MySQL - Full Project Tutorial

Master practical data cleaning techniques in MySQL through a hands-on project focused on processing and transforming layoff dataset using SQL queries and best practices.

• YouTube
• 51 minutes
• Self-Paced
• Free Video

Microsoft Copilot Review - AI Features in Office Applications

Discover how Microsoft Copilot enhances productivity across Word, PowerPoint, Excel and OneNote through practical demonstrations, real-world testing, and an in-depth analysis of its capabilities and limitations.

• YouTube
• 25 minutes
• Self-Paced
• Free Video

Solving Hard SQL Interview Questions - Technical Interview Practice

Master complex SQL interview challenges with hands-on practice solving hard technical questions, focusing on real-world scenarios like customer purchase analysis and temperature data manipulation.

• YouTube
• 21 minutes
• Self-Paced
• Free Video

Regular Expression Metacharacters in Python

Master Python's regular expression metacharacters to enhance pattern matching and text manipulation capabilities for more efficient string processing and data extraction.

• YouTube
• 20 minutes
• Self-Paced
• Free Video

Web Scraping Data from Real Websites with Python

Master web scraping techniques to extract real website data using Python, focusing on practical implementation and data collection methods.

• YouTube
• 25 minutes
• Self-Paced
• Free Video

SQL - From Beginner to Advanced Concepts

Master essential SQL skills from basic queries to advanced database operations in a comprehensive one-hour accelerated learning experience designed for aspiring data analysts.

• YouTube
• 1 hour 8 minutes
• Self-Paced
• Free Video

Exploratory Data Analysis in Python Using Pandas

Master essential data analysis techniques using Pandas, from basic data exploration to advanced visualization with seaborn. Learn to handle null values, create correlations, group data, and identify outliers effectively.

• YouTube
• 32 minutes
• Self-Paced
• Free Video

Data Cleaning with Python Pandas - A Complete Tutorial

Master essential data cleaning techniques in Python Pandas, including handling duplicates, standardizing values, splitting columns, and managing null values through hands-on demonstrations and practical examples.

• YouTube
• 39 minutes
• Self-Paced
• Free Video

Merging DataFrames in Python Pandas

Master essential techniques for merging, joining, and concatenating DataFrames in Pandas to efficiently combine and analyze multiple datasets using Python's powerful data manipulation library.

• YouTube
• 22 minutes
• Self-Paced
• Free Video