subqueries

There are 153 repositories under subqueries topic.

  • tweichle/w3resource-SQL-Exercises

    Exercises to help improve SQL skills

    5121101

  • codewithjaspreet/Sql

    Advanced SQL - Discover sequential, step-by-step explanations and solutions, accompanied by the necessary database creation codes, available on Ankit Bansal Sir's YouTube channel for SQL. Give it a ⭐ and stay tuned for more updates!

    26104

  • Subash-d/Shiv-restaurant

    Analyze a restaurant's new menu performance using MySQL. Explore `menu_items` and `order_details` tables to identify popular items, customer preferences, and revenue insights. Includes SQL queries, database schema, and sample data.

    14

  • kpratikin/Hotel-Reservation-System-Database-

    Designed and implemented database schema for hotel reservation system. Identified key business metrics for the system and constructed complex SQL queries to retrieve desired information. Documented the entire system by developing comprehensive UML diagrams.

    11106
  • Introduction-to-SQL

    sondosaabed/Introduction-to-SQL

    Course with udacity that cover SQL for data Scientists, this is my solution for the lessons and the project

    Language:SQL710

  • BernhardSchlegel/SQL-dumper

    Dumps the result of SQL to an CSV on the filesystem. Queries can be split into subqueries, reducing the complexity on the server side.

    Language:Java6536

  • Senja-P/SQL-Customer-Sales

    Examples of SQL queries created for Customer and Sales Data Analysis study project

    6201

  • sushma1395/YouTube-Video-Sharing-Database-Design

    This repository performs database functionalities.

    6006

  • eddahbarasa/AdvancedMySQL

    Pushing beyond simple SQL statements in MySQL to an advanced level dealing with complex stored procedures and functions, using variables and parameters, creating triggers and events, using CTEs, prepared statements, using the JSON data type. emulating full outer join.

    4100

  • eosobande/pdo-database-class

    A php class for using pdo class for your database queries

    Language:PHP4301

  • tweichle/Mode-SQL-Tutorial

    Learn to answer questions with data using SQL

    Language:PLpgSQL4004

  • ashleyj2/DA102-SQL-queries

    Notes from refreshing SQL knowledge

    3100

  • H0NEYP0T-466/SQL_CODES

    🗄️ A collection of SQL codes, queries, and practice exercises for databases. Covers basics like CRUD operations, joins, constraints, and indexing, along with advanced queries. Designed to strengthen database management skills and problem-solving with real-world data handling.

    Language:TSQL3

  • manuseiro/sql-cheat-sheet

    O SQL Basics Cheat Sheet fornece a sintaxe de todas as cláusulas básicas, e mostra como escrever condições diferentes seguido com exemplos.

    3101

  • MaxLopezSalgado/sql-playground

    This project is a SQL database management system that handles multiple tables and performs various queries and operations on them. It involves four different tasks, each with its own set of tables and questions to solve. The tasks cover a range of scenarios, that allow to apply basic, intermediate and advance SQL queries to different datasets.

    3100

  • russeva/Databases-Basics-MS-SQL-Server

    Part of the overall program with C # courses and tutorials for the "C # programmer" training at the University of Software

    Language:PLpgSQL3001

  • yunuserbas/SqlQueries

    All the SQL queries repository with examples from the first steps to advanced queries.

    Language:PLpgSQL3103

  • ATomar2150/Database

    SQL Queries, MS SQL Server

    2100

  • jani-excergy/SQL-QUERIES-_-JUPYTER-NOTEBOOK

    SQL QUERIES FROM Basic to Pro level in JUPYTER NOTEBOOK

    Language:Jupyter Notebook2100

  • KG-GitHubRepo/SQL-Projects

    💻 Leveraging the power of SQL to extract actionable insights from complex datasets.

    2100

  • PratikMajage/MYSQL

    SQL_PRACTICE_QUESTIONS | NOTES. 📝 | APNA COLLAGE | SMITH INSTITUTE | FUSSION INSTITUTE | 📚 THIS REPOSITORY DOCUMENTS MY JOURNEY OF LEARNING MYSQL, ONE OF THE MOST POPULAR RELATIONAL DATABASE MANAGEMENT SYSTEMS. 🗄️

    2

  • rahkum96/Olympics-Dataset-by-sql

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

    2101

  • shivanidashore777/FAASOS_SQL_ANALYSIS_PROJECT

    Faasos (now Rebel Foods) is a popular Indian food delivery company. It started as a restaurant chain, then shifted online. They offer affordable meals, diverse cuisines, and efficient delivery. Rebel Foods operates multiple brands, using technology to enhance the food delivery experience.

    2100

  • tomarshabh2199/Advanced-Sql-Interview-Questions

    Advanced Sql Interview Questions that covers topics like CTE, Analytics Window Functions, Aggregation Functions, Subqueries these topics will help you to boost your interview questions

    Language:C++2200

  • vikas98SSS/pizzahut_sales--sql

    Hello, my Name is vikas i've created a project in sql

    210

  • Ankush-Santra/SQL_Projects

    This repository showcases a curated collection of my SQL projects, demonstrating skills from foundational concepts like SELECT, INSERT, and ALTER to advanced techniques such as CTEs and Window Functions.

    1100

  • dBalag/Chinook

    The Chinook Data Analysis Project leverages PostgreSQL, Python, and Google Spreadsheets to explore and analyze the Chinook music store database. Insights will be presented through Tableau Dashboards and Stories. Stay tuned for updates as the project evolves.

    Language:Jupyter Notebook1101

  • dBalag/Nike-CTEs

    Unlock the power of SQL’s Common Table Expressions (CTEs) to transform data analysis capabilities! In this project, I demonstrate how to leverage CTEs to answer complex business questions with clarity and efficiency. Whether you’re dealing with hierarchical data, simplifying complex queries, or improving readability, CTEs are a game-changer.

    1100

  • DevBigBoy/MYSQL-CRASH-COURSE

    The book introduces you to the basics of MySQL development. MySQL development techniques are explained with an emphasis on using Structured Query Language (SQL). Learn to use and create MySQL databases, tables, functions, procedures, views, and triggers

    10

  • dheepika-chokkalingam/Online-Video-Streaming-Analysis-Using-SQL

    Answers to complex business questions posed by fictitious online video streaming company's management board using SQL.

    1100

  • eddahbarasa/DatabaseStructuresAndManagementWithMySQL

    DBMS skills such as data creation, joins, grouping, constraints, subqueries, views, functions and simple procedures

    1100

  • Lynsild55/SQL_portfolio

    50 sql tasks w/ description and solution (mysql, select, joins, subqueries, aggregate functions, sorting and grouping, advanced select and joins, advanced string functions)

    1
  • DataAnalysis-IPL-Datasets-2008-to-2017

    SampathVSS/DataAnalysis-IPL-Datasets-2008-to-2017

    Analysis was executed using MySQL on the IPL granular datasets which was available for the period 2008 to 2017

    1100

  • sora-tavares/Mastering-SQL-Subqueries-Postgresql

    SQL subqueries practice project using PostgreSQL

    1
  • Data-Driven-Decision-Making-in-SQL

    VibeHarboe/Data-Driven-Decision-Making-in-SQL

    Advanced SQL project focused on data-driven decision making.

    Language:Jupyter Notebook1

  • VladimirZelenokor1/CodeBasics-SQL

    This repository contains solutions to exercises from "SQL Beginner to Advanced For Data Professionals" course by CodeBasics.

    1