SQL For Data Analysis (SQD03)

This course will teach you how to use SQL, the industry-standard language for databases. Learn essential SQL skills for modern development and data analysis, enabling you to extract, manipulate, and analyse data effectively.

Buy £199.00

Course curriculum

1. Lesson 1. - Introduction
2. Lesson 1.1 - From Flat Files to Databases
3. Lesson 1.2 - What is a Relational Database?
4. Lesson 1.3 - Primary Keys & Relationships
5. Lesson 1.4 - Relational vs Non-Relational
6. Lesson 1.5 - What is SQL
7. Lesson 1.6 - Setting Up Our Environment
8. Lesson 1.6 - Resources
9. Lesson 1.7 - Course Project Direction
10. Module 1 - Quiz
1. Lesson 2. Module Introduction
2. Lesson 2.1 - Exploring Tables Like a Blueprint
3. Lesson 2.2 - Columns & Data Types
4. Lesson 2.3 - Primary Keys
5. Lesson 2.4 - Foreign Keys & Relationships
6. Lesson 2.5 - Why Data Is Split Across Tables
7. Lesson 2.6 - Data Profiling Mindset
8. Lesson 2.7 - Module Wrap Up
9. Module 2 - Quiz
1. Lesson 3. - Module Introduction
2. Lesson 3.1 - SELECT Statement
3. Lesson 3.2 - SELECT* vs Specific Columns
4. Lesson 3.3 - Aliases
5. Lesson 3.4 - Calculated Fields
6. Lesson 3.5 - DISTINCT
7. Lesson 3.6 - ORDER BY
8. Lesson 3.7 - LIMIT
9. Lesson 3.8 - Module Wrap Up
10. Module 3 - Quiz
1. Lesson 4. - Module Introduction
2. Lesson 4.1 - WHERE Clause
3. Lesson 4.2 - Comparison Operators
4. Lesson 4.3 – Combining Multiple Conditions
5. Lesson 4.4 - IN
6. Lesson 4.5 - BETWEEN
7. Lesson 4.6 - LIKE
8. Lesson 4.7 - Handling NULL's
9. Lesson 4.8 - Aggregation
10. Lesson 4.9 - GROUP BY
11. Lesson 4.10 - HAVING
12. Lesson 4.11 - Nested Queries (Subqueries)
13. Lesson 4.12 - Thinking Like an Analyst
14. Lesson 4.13 - Module Wrap Up
15. Module 4 - Quiz
1. Lesson 5.0 - Model Introduction
2. Lesson 5.1 - Data Profiling
3. Lesson 5.2 - Investigating True Duplicates
4. Lesson 5.2 - Resources
5. Lesson 5.3 - Understanding NULL
6. Lesson 5.4 - Date Formatting
7. Lesson 5.5 - Text to Numeric
8. Lesson 5.6 - Standardisation
9. Lesson 5.7 - Text Case Issues
10. Lesson 5.8 - Final Validation
11. Lesson 5.9 - Module Wrap Up
12. Module 5 - Quiz
1. Lesson 6.0 - Module Introduction
2. Lesson 6.1 - Why Raw Data Cannot Go Straight In
3. Lesson 6.2 – Populating address Table
4. Lesson 6.3 – Populating customers
5. Lesson 6.4 – Populating products
6. Lesson 6.5 – Populating orders
7. Lesson 6.6 – Populating order_items
8. Lesson 6.7 – Validation Checks
9. Lesson 6.8 – Lock the Data
10. Lesson 6.9 - Module Wrap Up
11. Module 6 - Quiz
1. Lesson 7.0 – Module Introduction
2. Lesson 7.1 – Introduction to Aggregation Functions
3. Lesson 7.2 – Total Profit
4. Lesson 7.3 – Total Number of Orders
5. Lesson 7.4 – GROUP BY
6. Lesson 7.5 – Revenue by Region
7. Lesson 7.6 – Average Order Value
8. Lesson 7.7 – HAVING (Filtering Aggregated Results)
9. Lesson 7.8 – Top 10 Products by Revenue
10. Lesson 7.9 - Multiple Metrics Together
11. Lesson 7.10 – Business Framing
12. Lesson 7.11 – Module Closure
13. Module 7 - Quiz
1. Lesson 8.0 - Module Introduction
2. Lesson 8.1 - Using Date Components
3. Lesson 8.2 - Increasing Granularity
4. Lesson 8.3 - Business-Friendly Output
5. Lesson 8.4 - Measuring Growth
6. Lesson 8.5 - Revenue vs Profit Trends
7. Lesson 8.6 - Detecting Seasonality
8. Lesson 8.7 - Nested Aggregation
9. Lesson 8.8 - Interpretation & Insight
10. Lesson 8.9 - Module Wrap Up
11. Module 8 - Quiz
1. Lesson 9.0 – Module Introduction
2. Lesson 9.1 – Customer Lifetime Revenue (CLV)
3. Lesson 9.2 – Customer Lifetime Profit
4. Lesson 9.3 – Number of Orders Per Customer
5. Lesson 9.4 – Average Order Value Per Customer
6. Lesson 9.5 – Segment-Level Analysis
7. Lesson 9.6 – Customers by Region
8. Lesson 9.7 – Identifying High-Value Customers
9. Lesson 9.8 – Identifying Potential Churn Risk
10. Lesson 9.9 - Module Warp Up
11. Module 9 - Quiz
1. Lesson 10 - Module Introduction
2. Lesson 10.1 - Total Sales By Product
3. Lesson 10.2 - Profit by Product
4. Lesson 10.3 – Profit Margin Analysis
5. Lesson 10.4 – Category-Level Performance
6. Lesson 10.5 – Sub-Category Analysis
7. Lesson 10.6 - Top 10 Products by Profit
8. Lesson 10.7 - Underperforming Products (Negative Profit)
9. lesson 10.8 - Product Contribution Percentage
10. Lesson 10.9 – Pareto Analysis (The 80/20 Rule)
11. Lesson 10.10 – Product Performance Over Time
12. Lesson 10.11 – Module Wrap Up
13. Module 10 - Quiz
1. Lesson 11.0 – Module Introduction
2. Lesson 11.1 – Window Functions vs GROUP BY
3. Lesson 11.2 – ROW_NUMBER()
4. Lesson 11.3 – RANK() Allows Ties
5. Lesson 11.4 – Partitioning
6. Lesson 11.5 – Running Totals
7. Lesson 11.6 – Moving Average
8. Lesson 11.7 – Customer Ranking by Lifetime Revenue
9. Lesson 11.8 – Top N Per Category
10. Lesson 11.9 – Business Interpretation
11. Lesson 11.10 – Module Wrap Up
12. Module 11 - Quiz
1. Lesson 12.0 – Module Introduction
2. Lesson 12.1 – Why Create Views?
3. Lesson 12.2 – Creating a Revenue View
4. Lesson 12.3 – Product Performance View
5. Lesson 12.4 – Time-Based Analytical View
6. Lesson 12.5 – Layering Views
7. Lesson 12.6 – Query Optimisation Concepts (High-Level)
8. Lesson 12.7 – Clean Query Structure & Readability
9. Lesson 12.8 – Analytical Workflow Structure
10. Lesson 12.9 – Business Framing
11. Lesson 12.10 – Module Wrap Up
12. Module 12 - Quiz
1. Lesson 13.0 – Module Introduction
2. Lesson 13.1 – Using SQL with Python
3. Lesson 13.2 – Using SQL with Tableau
4. Lesson 13.3 – Using SQL with Microsoft Power BI
5. Lesson 13.4 – Choosing the Right Tool
6. Lesson 13.5 – Business Framing
7. Lesson 13.6 – Final Course Reflection
1. Course Feedback Form

About this course

£199.00
147 lessons
0 hours of video content

Discover your potential, starting today

Enroll today

ITonlinelearning Academy

SQL For Data Analysis (SQD03)

Course curriculum

Module 1 - Databases in the Real World & Environment Setup

Module 2 - Understanding the Retail Database Structure

Module 3 - SQL Fundamentals for Data Retrieval

Module 4 - Filtering & Logical Querying

Module 5 -Data Cleaning & Preparation in SQL

Module 6 - Data Transformation & Population

Module 7 - Aggregation & KPI Reporting

Module 8 - Time Series & Trend Analysis

Module 9 - Customer Analytics & Segmentation

Module 10 - Product Performance & Contribution Analysis

Module 11 - Advanced SQL: Window Functions & Ranking

Module 12 - Analytical Views & Query Optimisation

Module 13 - Final Integrating SQL with Data Analysis Tools

Course Feedback

About this course

Discover your potential, starting today