About 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 module enables you summarize and identify the quality of the data using concepts such as aggregation and window functions.

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

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

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

A comprehensive SQL-based project for managing a Pokémon database. Includes scripts for creating, reading, updating, and deleting trainers, Pokémon, battles, and trainer-Pokémon relationships.

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

This module covers how to assemble multiple tables into a dataset using SQL queries. It also introduces how to transform and clean data using SQL functions.

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.

Hotel chain database

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

This project analyzes sales data for AdventureWorks, focusing on revenue, customer segments, and product performance. The dashboard provides insights into top-selling products, sales by region, and customer trends across multiple years. It helps in identifying sales opportunities and optimizing marketing strategies.

basic sql queries 🏬

Learning SQL basics, intermediate and advance with hands on experience with t-sql version.

In this repository, there are database creation and query commands with sql server.