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

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.

An ongoing & curated collection of awesome software libraries, learning tutorials, Useful links & scripts, tools, resources and cool stuff about Microsoft SQL Server

This repository contains a complete set of SQL Server tasks and solutions based on the ITI course by Eng. Rami. It covers topics from database fundamentals to advanced SQL Server concepts, serving as a structured reference for learning, practicing, and revision.

In this repository you will find SQL queries of multi-difficulty levels that can applied on to large datasets for various business requirements.

Solutions for Hackerrank SQL problems

Example SQL database and querying using Cornell's eBird database

Final project for CS50 SQL – A normalized media database to manage movies, series, contributors, users, comments, and views.

This module enables you summarize and identify the quality of the data using concepts such as aggregation and window functions.

Using SQL queries to select various data from a hypothetical big department store database.

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.

Obligatorio Base de Datos 2 (Semestre 3 - Agosto 2021) Calificación: 40/40

Obligatorio 1 y 2 de Base de Datos 1 (Semestre 2 - Marzo 2021) Calificación: 41/45

A hands-on SQL project simulating data analysis using fact and dimension tables, covering trends over time, cumulative metrics, performance breakdowns, segmentation, and reporting via SQL.

Few more basic additional MS-SQL queries in addition to my previous repository to help beginners understand the concepts more deeply.Here we make use of readily available database 'WideWorldImportersDW-Full.bak' to perform our SQL queries.

Building a data warehouse using with SQL Server, including ETL processes, data modeling, and analytics

Building a modern data warehouse with SQL Server, including ETL Process, data modelling and analytics

This module covers performing descriptive analytics on time series data, geospatial data, complex data types (arrays, JSON, and JSONB), and text.

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.