Exercises to help improve SQL skills
- Updated
#
subqueries
Here are 187 public repositories matching this topic...
Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.
mysql sql data-analytics cte data-analyst subqueries advanced-sql window-functions sql-practice sql-interview sql-interview-questions recursive-ctes recursive-cte
- Updated
- HTML
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!
- Updated
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.
- Updated
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.
- Updated
Dumps the result of SQL to an CSV on the filesystem. Queries can be split into subqueries, reducing the complexity on the server side.
- Updated
- Java
Course with udacity that cover SQL for data Scientists, this is my solution for the lessons and the project
- Updated
- SQL
This repository performs database functionalities.
- Updated
Examples of SQL queries created for Customer and Sales Data Analysis study project
sql postgresql snowflake data-analytics rdbms data-dictionary data-analysis relational-databases tableau pgadmin4 join-tables subqueries tableau-public common-table-expression data-analysis-sql
- Updated
Learn to answer questions with data using SQL
- Updated
- PLpgSQL
A php class for using pdo class for your database queries
php database pdo sql-builder pdo-wrapper sql-generation pdo-mysql insert-query prepared-queries join-tables subqueries
- Updated
- PHP
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.
mysql views json-data indexing transactions prepared-statements cte trigger-events joins stored-procedures subqueries mysqlfunctions
- Updated
Part of the overall program with C # courses and tutorials for the "C # programmer" training at the University of Software
- Updated
- PLpgSQL
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.
- Updated
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.
- Updated
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.
mysql cte joins groupby orderby subqueries ddl-commands mysqlworkbench whereclause dml-commands windowfunctions datefunctions stringfunctions dql-command casestatement
- Updated
SQL QUERIES FROM Basic to Pro level in JUPYTER NOTEBOOK
select dml offset aggregate limit distinct ddl null create joins where describe orderby dcl subqueries having showtables comparisonoperators logicaloperaters
- Updated
- Jupyter Notebook
Hello, my Name is vikas i've created a project in sql
- Updated
Improve this page
Add a description, image, and links to the subqueries topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the subqueries topic, visit your repo's landing page and select "manage topics."