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

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

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.

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.

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

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

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.

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.

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 repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis

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.