Alex the Analyst Courses

SQL Basics for Data Analysts

Syllabus: SQL Basics Tutorial For Beginners | Installing SQL Server Management Studio and Create Tables | 1/4. SQL Basics Tutorial For Beginners | Select + From Statements | 2/4. SQL Basics Tutorial For Beginners | Where Statement | 3/4. SQL Basics Tutor…

• YouTube
• Less than 1 hour of material
• Self paced
• Free Online Course

Intermediate SQL Tutorials

Syllabus: Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases. Intermediate SQL Tutorial | Unions | Union Operator. Intermediate SQL Tutorial | Case Statement | Use Cases. Intermediate SQL Tutorial | Having Clause. Intermediate SQL Tutorial | Updat…

• YouTube
• Less than 1 hour of material
• Self paced
• Free Online Course

Advanced SQL Tutorials

Syllabus: Advanced SQL Tutorial | CTE (Common Table Expression). Advanced SQL Tutorial | Temp Tables. Advanced SQL Tutorial | String Functions + Use Cases. Advanced SQL Tutorial | Stored Procedures + Use Cases. Advanced SQL Tutorial | Subqueries.

• YouTube
• Less than 1 hour of material
• Self paced
• Free Online Course

Data Analyst Portfolio Projects

Syllabus: Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4. Data Analyst Portfolio Project | Tableau Visualization | Project 2/4. Data Analyst Portfolio Project | Data Cleaning in SQL | Project 3/4. Data Analyst Portfolio Project | Cor…

• YouTube
• 7 hours worth of material
• Self paced
• Free Online Course

Tableau Tutorials For Beginners

Syllabus: Tableau Tutorial for Beginners | Installing Tableau | Building First Visualization | Part 1/5. Tableau Tutorial for Beginners | Calculated Fields | Bins | Part 2/5. Tableau Tutorial for Beginners | Density Maps | Bar and Line Graphs | More Visu…

• YouTube
• 1-2 hours worth of material
• Self paced
• Free Online Course