subqueries-and-joins
There are 17 repositories under subqueries-and-joins topic.
heshammohamedaldaidamony/E-Commerce-DB
This repository focuses on developing and optimizing an e-commerce database. It includes comprehensive database design, advanced query techniques, and performance optimization strategies.
Ajit49/SQL-Project-On-Pizza-Sales
SQL Project on Pizza Sales
AngEvd/PostgreSQL
Homework solutions for SoftUni PostgreSQL course
AnoshZahir/sql-project-data-job-analysis
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
Ashu3291/Olympic-dataset
120 years of Olympic history: athletes and results from basic biodata on athletes and medal results from Athens 1896 to Rio 2016.
leonardgenders/SQL
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
LKEthridge/Data_Collection_and_Storage_-SQL-
A Data Collection and Storage project using SQL from TripleTen
Megha270302/Pizza_sales_sql_analysis
SQL PROJECT FOR DATA ANALYSIS
SatvikPraveen/RSVP_Case_Study
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.
theo-liang/SQL-and-Tableau-Project-Analysis-for-Rockbuster-Stealth
This project involved analyzing data for Rockbuster Stealth LLC, a fictional movie rental company transitioning to an online video rental service.
trayanaboykova/MySQL
Tasks from my course MYSQL at SoftUni
vinayak-sharma2002/Blood-Bank-Management-SQL-database
This repository has the code for my SQL project where I have created a database in MySQL for a blood bank containing all the necessary information such as the details of the staff such as: Managers, Recording Staff, Disease Finders, etc. Details of Blood Specimens and donors and visits as well. It also has queries that can be used on real data.
AlvaroMolinaCL/TallerBasesDeDatos-UCSC
This repository (in spanish language) contains study material, codes, and exercises in the Databases Laboratory course taught at UCSC in the 2024-1 semester.
shohail-DeV/LeetCode-SQL-50
Answers for the LeetCode SQl 50 Questions.
vishnupriya9629/Libraray-Management--SQL-Project
Analysis using SQL