Skip to main content

Explore Problems

Certifications Quiz Pricing

⌘K

Real-World SQL Projects

Course Contents

Project Resources

SQL Project Types

Intro to Data Warehouse

Get Project Resources

Notion for Project Management

Understand Project Requirements

Data Architecture Approaches

Design the Data Warehouse Layers

Draw DWH Architecture

Refine the Project Plan

Define The Naming Conventions

Prepare Your GIT Repo

Create The Database

Bronze Layer | Analyze Source Systems

Bronze Layer | DDL Create Tables

Bronze Layer | Load Scripts

Bronze Layer | Build Stored Procedure

Bronze Layer | Document The Work

Silver Layer | Exploring Data

Silver Layer | DDL Create Tables

Silver Layer | Load Script 1

Silver Layer | Load Script 2

Silver Layer | Load Script 3

Silver Layer | Load Script 4

Silver Layer | Build Stored Procedure

Silver Layer | Document The Work

Gold Layer | Data Modelling

Gold Layer | Analysis

Gold Layer | Build Dimension Customers

Gold Layer | Build Dimension Products

Gold Layer | Build Fact Sales

Gold Layer | Draw The Data Model

Gold Layer | Create Data Catalog

Gold Layer | Document The Work

Project Resources

Introduction to EDA

Data Analytics Project Roadmap

Get Project Resources

Dimensions vs Measures

Database Exploration

Dimensions Exploration

Date Exploration

Measure Exploration

Magnitude Analysis

Ranking Analysis

EDA Recap: What It Is and Why Data Analysts Do It

Introduction to the Project

Change Over Time Analysis

Cumulative Analysis

Performance Analysis

Part to Whole Analysis

Data Segmentation

Build Customers Report

Build Products Report

Document Your Work in GIT

Congratulations & THANK YOU

Ranking Analysis

Identify top and bottom performers with ranking analysis in SQL — simple ranking with TOP, the top and bottom products by revenue, flexible ranking with window functions, and when to use each approach.

Loading...

Loading content...