The most comprehensive SQL guide from a real-world expert! Learn everything from basics to advanced queries, optimizations, and real-world SQL

A comprehensive guide to building a modern data warehouse with SQL Server, including ETL processes, data modeling, and analytics.

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

Starter project for building an ETL pipeline using SSIS in Visual Studio 2019

Explore my SQL Data Engineering portfolio. See how I use SQL to organize data and create smart solutions for better insights and smoother processes.

Project 4: Udacity Nanodegree Program - Data Engineering with Microsoft Azure

A comprehensive guide to building a modern data warehouse with SQL Server, including ETL processes, data modeling, and analytics.

This repository contains all the assignments, workshops and mini-projects of course - DAMG7370 Designing Advanced Data Architectures for Business Intelligence

Designed Multi Star schema with 10 Fact & 33 Dimension tables & developed Data Integration Pipeline by ETL workflow to load all tables (380M+ rows) from multiple sources such as CSV, MySQL, MSSQL & PostgreSQL by using Talend. Implemented Data Profiling, Error Handling, Load Statistics, Cleansing and Performance Tuning to address data quality gap…

Using TPC-DI to benchmark MS SQL server using SQL script for extract, transform and load (ETL).

This is a full example of E2E data processing using Microsoft Fabric with some publically available NHS data. Feel free to explore/fork/reuse etc...

Hybrid E-Marketing using Web Page Mining for Website Monetization

🚗 Data engineering scenario for a Car Sales company Achieved Distinction for this module with SQL proficiency

Building a modern data warehouse with AQL Server, including ETL processes, data modeling and analytics.

Building a modern data warehouse including, ETL process, data modeling and analytics

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cummulative, performance, data segmentation, part-to-whole analysis.

Building a modern data warehouse with SQL Server, including ETL Processes, Data Modeling and Analytics

Database design for a fictituous fintech company named Velora

Constructing a contemporary data warehouse that spans multiple databases, with complete ETL pipelines, structured data models, and robust analytics tools.

😊️️️️️️ Leetcode database part solutions