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

Exercises to help improve SQL skills

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!

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.

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.

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.

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.

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

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

This repository performs database functionalities.

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

Learn to answer questions with data using SQL

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

Notes from refreshing SQL knowledge

A php class for using pdo class for your database queries

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.

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.

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

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.

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