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

A SQL-based fraud detection project using PostgreSQL to analyze transaction data for a bank and uncover high-risk behaviors, repeat offenders, and location-based anomalies.

This SQL-based project analyzes Pizza Hut's sales data to uncover insights about customer behavior, product performance, and store efficiency. It focuses on optimizing decision-making by leveraging advanced SQL techniques.

Structured practice and projects to master SQL from basics to advanced.

Data exploration

This repository contains SQL queries for the SQL for Data Analysis given by Udacity. The queries include commands to define, select, manipulate, control access, aggregate, and join data and data tables.

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

Exercício de criação de uma locadora de carros em MySQL para a inserção de dados e para o uso de pesquisas e sub-pesquisas utilizando os métodos "join", "left join", "where", "from" entre outros..

SQL Project on Pizza Sales

SQL-based sales analysis project using MySQL to derive business insights with joins, CTEs, subqueries, and window functions.

A comprehensive IMDB dataset analysis using SQL. Includes database setup, advanced queries, and actionable insights. Organized with files for database creation, queries, and solutions. Features an Entity-Relationship Diagram (ERD), executive summary, and SQL scripts. Perfect for SQL workflows and business intelligence in the film industry.

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

Employee Insights Dashboard

SQL PROJECT FOR DATA ANALYSIS

A Data Collection and Storage project using SQL from TripleTen

SQL analysis of Indian census data.

SQL analysis of Forbes Global 2000 using CTEs, window functions, subqueries and views.

This portfolio highlights advanced SQL — joins, subqueries, and CTEs — applied to realistic business cases using the Northwind database as a model of an enterprise setting. It shows how data insights support decisions in fintech, consulting, and retail analytics.

Answers for the LeetCode SQl 50 Questions.

Homework solutions for SoftUni PostgreSQL course