Skip to content
#

subqueries-and-joins

Star

Here are 16 public repositories matching this topic...

Language: All
Filter by language
All 16 PLpgSQL 4 HTML 1
Sort: Most stars
Sort options
Most stars Fewest stars Most forks Fewest forks Recently updated Least recently updated

heshammohamedaldaidamony / E-Commerce-DB

Star 21

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

SatvikPraveen / RSVP_Case_Study

Star 0

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

vinayak-sharma2002 / Blood-Bank-Management-SQL-database

Star 0

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.

mysql data-science data sql data-analytics mysql-database joins subqueries-and-joins
  • Updated Dec 28, 2024

leonardgenders / SQL

Star 0

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

AnoshZahir / sql-project-data-job-analysis

Star 0

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

Improve this page

Add a description, image, and links to the subqueries-and-joins topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the subqueries-and-joins topic, visit your repo's landing page and select "manage topics."

Learn more