advanced-sql
Here are 75 public repositories matching this topic...
LeetCode Premium Advanced SQL 50 List- Solved 50/50 problems
-
Updated
Feb 24, 2024
Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.
-
Updated
Jan 11, 2026 - HTML
SQL Database questions from LeetCode- as many as I can solve sorted by difficulty; current problems solved- 192
-
Updated
Jun 19, 2024
Hands-on : Udemy course, Advanced SQL: MySQL Data Analytics & Business Intelligence, Maven Analytics. Requirements - MySQL Workbench
-
Updated
Sep 13, 2023
SQL Database questions from LeetCode- as many as I can solve; current problems solved- 192
-
Updated
Mar 12, 2024
𝗗𝗕𝗠𝗦 𝗟𝗮𝗯 | 𝗖𝗦𝟯𝟵𝟮𝟬𝟮 | 𝗘𝗥-𝗗𝗶𝗮𝗴𝗿𝗮𝗺, 𝗦𝗤𝗟 𝗮𝗻𝗱 𝗦𝗤𝗟 𝗖𝗼𝗻𝗻𝗲𝗰𝘁𝗶𝘃𝗶𝘁𝘆
-
Updated
Apr 18, 2025 - Java
Advanced SQL in MySQL 8.0: window functions, pivot tables, regex, stored procedures, employee management project, ML data prep
-
Updated
May 29, 2026 - SQL
Comprehensive SQL learning repository with structured, hands-on SQL scripts covering basics to advanced topics. Includes practical examples, exercises, and real-world use cases for progressive mastery.
-
Updated
Dec 19, 2025
📚 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 9, 2025 - PLpgSQL
This repo contains my sql examples and understanding.
-
Updated
Jul 7, 2023 - TSQL
📊 DBMS Mastery: Queries, concepts, and code snippets for database wizards 🧙♂️💾
-
Updated
Oct 16, 2024
This project showcases advanced SQL queries and data analysis techniques applied to a dataset of vehicle auctions. The dataset includes data from multiple competitors over several months, with details about car brands, models, manufacture years, auction periods, starting prices, final bid prices, and listing counts.
-
Updated
Aug 28, 2024
A hands on SQL Data Warehouse project with mySQL, including ETL processes, data modelling and analytics.
-
Updated
Aug 5, 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
A comprehensive SQL repository with queries organized by industry sectors, including banking, healthcare, energy, manufacturing, and transportation. Designed to solve real-world problems with optimized and scalable solutions, this repository is ideal for learning and tackling industry-specific challenges.
-
Updated
Jan 2, 2025
SQL repository contains my answers to the queries and challenges posed by numerous websites like hackerrank, leetcode, w3schools, datalemur, stratascratch, sqlbolt.
-
Updated
Nov 4, 2025
This advanced version of the initial Stock-Portfolio-Robo-Advisor project utilizes advanced SQL, Python, and Airflow for data storage and analysis. The data warehouse contains millions of rows and fetches results for each company and historical prices from an API, enabling comprehensive analysis using different complex algorithmic techniques.
-
Updated
May 24, 2024 - SQL
Database Analysis and Design for Train Reservation System. Analysis of User Requirments Phase, Design of ERD, Schema, Implementation of Physical Tables, Populating Data, and Queries to Analyze the Data. Views for the security of data and helping analyze the rest of the tables.
-
Updated
Dec 21, 2022
This bootcamp aims to provide a comprehensive introduction to data engineering, equipping participants with the knowledge and hands-on experience needed to build and maintain robust data pipelines and data warehouses.
-
Updated
Feb 3, 2025
Improve this page
Add a description, image, and links to the advanced-sql topic page so that developers can more easily learn about it.
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."