This repository focuses on developing and optimizing an e-commerce database. It includes comprehensive database design, advanced query techniques, and performance optimization strategies.

120 years of Olympic history: athletes and results from basic biodata on athletes and medal results from Athens 1896 to Rio 2016.

This project involved analyzing data for Rockbuster Stealth LLC, a fictional movie rental company transitioning to an online video rental service.

SQL Project on Pizza Sales

SQL PROJECT FOR DATA ANALYSIS

Demonstrations of subqueries (correlated, uncorrelated, complex, common table expressions), summary queries (aggregate, grouping, summarizing, window, named window, frame functions), joins, date time data types (passing, extracting, date time calculations), IF/IF NULL/COALESCE/CASE statements, regular expressions, ranking functions

Answers for the LeetCode SQl 50 Questions.

Tasks from my course MYSQL at SoftUni

This repository (in spanish language) contains study material, codes, and exercises in the Databases Laboratory course taught at UCSC in the 2024-1 semester.

Analysis using SQL

SQL queries developed as part of a data analysis project. Includes analysis of job data, queries for insights into job categories, salaries, and customer behavior. Techniques used include JOINS, CTEs, subqueries, and aggregate functions. Inspired by DataNerd's YouTube tutorial: https://www.youtube.com/watch?v=7mz73uXD9DA