Open source SQL Server troubleshooting: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, and other SQL Server scripts for performance troubleshooting

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

🌎World countries, states/regions, cities served inn various formats. All Countries, Cities, States with ISO2, ISO3

This repository contains SQL problems from HackerRank, DataLemur and other challenges. Contains solutions to improve skills in database querying, optimization, and data manipulation.

Este repositório contém todas as Queries SQL que desenvolvi para coleta de dados do banco de dados do sistema ERP Siagri Agribusiness.

In this repository I prove my knowledge and technical skills using this tool as a Data Analyst.

Created a database schema for a dental clinic management system. This database can also be useful when creating a hospital database. The schema includes tables for doctors, technicians, patients, appointments, examinations, medications, diagnoses, prescriptions, invoices and payments.

Database Lab Homeworks

Designing data ERD | Table Schema | DB init script

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.

A modern SQL toolkit for data-driven applications built for engineers, analysts, and performance

Microsoft SQL Server es un sistema de gestión de bases de datos relacionales (RDBMS) que admite una amplia variedad de aplicaciones de procesamiento de transacciones, inteligencia empresarial y análisis en entornos informáticos corporativos.

This project aim is to manage a stock of Osher Ad

A playground for SQL (Structured Query Language).

Taller de Gestión de Datos e Información I con Gustavo Coronel.

This database stores information about flight schedules for an airline company and uses JDBC to interact with it in Java

End-to-end data analysis project using SQL.