subqueries 开源项目推荐（276 个）

DataWithBaraa /sql-ultimate-course

The materials of the free 30-hour SQL course: the databases for SQL Server, MySQL and PostgreSQL, every query of the 41 chapters, and the slides.

santoshkhatri9860 /advanced-sql-practice-mysql

Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.

tweichle /w3resource-SQL-Exercises

Exercises to help improve SQL skills

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!

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.

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.

VIJAYAPANDIANT /leetcode-sql50

A comprehensive collection of 50 optimized SQL solutions for the LeetCode SQL 50 study plan, covering fundamental to advanced database querying concepts like Joins, Subqueries, and Window Functions.

VIJAYAPANDIANT /elevate-labs-sql-task9

Elevate Lab SQL Task 9: A professional SQL project demonstrating advanced database queries, specifically focusing on understanding, utilizing, and optimizing different types of SQL Subqueries.

sondosaabed /Introduction-to-SQL

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

Senja-P /SQL-Customer-Sales

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

sushma1395 /YouTube-Video-Sharing-Database-Design

This repository performs database functionalities.

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.

eosobande /pdo-database-class

A php class for using pdo class for your database queries

ashleyj2 /DA102-SQL-queries

Notes from refreshing SQL knowledge

tweichle /Mode-SQL-Tutorial

Learn to answer questions with data using SQL

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.

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.

H0NEYP0T-466 /sql_workbench

🗄️ 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.

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

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.