subqueries-and-joins

Here are 13 public repositories matching this 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.

ecommerce query sql database view dbms indexing plsql trigger subquery database-design denormalization stored-procedure clustring databasemanagementsystem database-management-system database-optimization subqueries-and-joins

Updated Oct 30, 2024
PLpgSQL

sujith014 / leetcode-sql-solutions

Star

sorting select strings joins aggregation grouping subqueries subqueries-and-joins

Updated Sep 24, 2024

Ashu3291 / Olympic-dataset

Star

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

data-mining sql powerquery datacleaning aggregatefunctions temptables subqueries-and-joins

Updated Aug 11, 2024

theo-liang / SQL-and-Tableau-Project-Analysis-for-Rockbuster-Stealth

Star

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

sql relational-databases cleaning-data filtering-data common-table-expressions subqueries-and-joins

Updated Sep 5, 2024

SatvikPraveen / RSVP_Case_Study

Star

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.

sql business-intelligence data-analysis relational-database database-design imdb-dataset entity-relationship-diagram data-driven-decisions data-querying aggregate-functions common-table-expressions subqueries-and-joins

Updated Nov 23, 2024

Ajit49 / SQL-Project-On-Pizza-Sales

Star

SQL Project on Pizza Sales

mysql sql-query group-by whereclause aggregate-functions subqueries-and-joins order-by-clause

Updated May 2, 2024

Megha270302 / Pizza_sales_sql_analysis

Star

SQL PROJECT FOR DATA ANALYSIS

queries sql mysqlworkbench aggregate-functions subqueries-and-joins

Updated Apr 20, 2024

leonardgenders / SQL

Star

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

case casting regular-expressions converting coalesce subqueries-and-joins ranking-functions

Updated Nov 25, 2024

vishnupriya9629 / Libraray-Management--SQL-Project

Star

Analysis using SQL

aggregate joins windowsfunction basic-sql intermediate-sql subqueries-and-joins

Updated Sep 15, 2024

AnoshZahir / sql-project-data-job-analysis

Star

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

sql data-analysis cte joins subquery aggregate-functions job-analysis ctes subqueries-and-joins data-nerd

Updated Sep 16, 2024
PLpgSQL

AlvaroMolinaCL / TallerBasesDeDatos-UCSC

Star

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

sql postgresql databases plpgsql sql-views sql-functions sql-triggers sql-cursor subqueries-and-joins