subqueries

Star

Here are 116 public repositories matching this topic...

tweichle / w3resource-SQL-Exercises

Star

Exercises to help improve SQL skills

sql sql-query data-analysis relational-databases joins aggregations subqueries

Updated Aug 5, 2019

BernhardSchlegel / SQL-dumper

Star

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

csv sql database jar dump sql-files sql-script subqueries sql-dumper

Updated Jul 31, 2022
Java

kpratikin / Hotel-Reservation-System-Database-

Star

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.

sql dbms uml-diagram database-schema normalization-database subqueries sql-join

Updated May 31, 2019

tweichle / Mode-SQL-Tutorial

Star

Learn to answer questions with data using SQL

sql sql-query data-analysis relational-databases joins aggregations subqueries

Updated Apr 17, 2019
PLpgSQL

yunuserbas / SqlQueries

Star

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

views sql database functions joins subqueries

Updated Apr 4, 2023
PLpgSQL

codewithjaspreet / Sql

Star

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!

mysql cte windowfunction subqueries sqlviews top45

Updated Sep 13, 2023

peterlydev / ICCTestCricket2021

Star

Publishing all current matches and scores for the ICC World Test Cricket Championships 2019-21. Matches include the Ashes and all of the other test matches. SQL commands include runs, boundaries, catches, wickets, overs, strike rates and more exciting complex commands

sql cricket postgresql-database cricket-data subqueries test-cricket

Updated Apr 12, 2021
TSQL

eosobande / pdo-database-class

Star

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 Apr 1, 2017
PHP

russeva / Databases-Basics-MS-SQL-Server

Star

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

database transaction exercise trigger mssql mssql-database subqueries

Updated Jun 12, 2018
PLpgSQL

Shantanu36 / SQLAdditionalBasics

Star

Few more basic additional MS-SQL queries in addition to my previous repository to help beginners understand the concepts more deeply.Here we make use of readily available database 'WideWorldImportersDW-Full.bak' to perform our SQL queries.

aggregate-function database database-management foreign-keys joins relational-database sql-queries tsql ssms primary-key subqueries group-by microsoft-sqlserver-database wildcard-matches order-by wideworldimportersdw-backup

Updated Jun 19, 2020
TSQL

girginchev / DataBase-SoftUni-Courses

Star

My homework exercises and exam from Database modul in SoftUni part of the proffesional program for C# developer

json queries sql database xml trigger transactions codefirst database-management efcore joins sqlserver stored-procedures procedures tsql automapper database-first subqueries

Updated Dec 23, 2017
C#

dBalag / Chinook

Star

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.

Updated Oct 12, 2024
Jupyter Notebook

rahkum96 / Olympics-Dataset-by-sql

Star

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

sql power-query data-cleaning subqueries aggregate-functions window-functions temp-tables

Updated Jan 11, 2022

sushma1395 / YouTube-Video-Sharing-Database-Design

Star

This repository performs database functionalities.

sql privileges triggers subqueries stored-procedure

Updated Jan 12, 2019

Senja-P / SQL-Customer-Sales

Star

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 Jan 6, 2022

tweichle / PostgreSQL-Exercises

Star

Exercises to help improve PostgreSQL skills

sql postgresql sql-query data-analysis relational-databases joins aggregations subqueries

Updated Jul 21, 2021

diegoecasas / Top-Video-Games

Star

In this project, we'll explore the top 400 best-selling video games created between 1977 and 2020. We'll compare a dataset on game sales with critic and user reviews to determine whether or not video games have improved as the gaming market has grown.

sql joins subqueries