Skip to content
#

advanced-sql

Here are 52 public repositories matching this topic...

In this course, master PostgreSQL through hands-on labs covering relationships, advanced data types, indexing, transactions, views, permissions, queries, triggers, backups, partitioning, full-text search, and more.

  • Updated Oct 23, 2025

This is an MSSQL Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.

  • Updated Mar 19, 2025
  • Jupyter Notebook

📚 An End-to-End Advanced SQL Project covering Data Warehousing, ETL Pipeline (Bronze → Silver → Gold), Star Schema Modeling, EDA, and Advanced SQL Analytics. Built using PostgreSQL, this project simulates a real-world Data Engineering + Data Analytics workflow using raw ERP & CRM data to generate production-ready customer and product insights.

  • Updated Dec 2, 2025
  • PLpgSQL

Improve this page

Add a description, image, and links to the advanced-sql topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the advanced-sql topic, visit your repo's landing page and select "manage topics."

Learn more