PostgreSQL performance essentials in 1 hour

postgres sql postgresql query-optimization database-perfomance btree-indexes slow-queries table-partitioning query-plan nested-loops hash-join sql-join index-scan sequential-scan merge-join gin-indexes hash-indexes partial-indexes bitmap-scans multicolumn-indexes

• Updated Jul 10, 2022

This repository contains SQL queries from various popular online learning resources e.g. Vertabelo Academy, SQLZoo etc.

mysql sql database beginner-friendly academy sqlzoo groupby beginners-guide step-by-step sqlzoo-solutions having sql-aggregation sql-join vertabelo-academy

• Updated Jul 29, 2026
• SQL

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

Master SQL interview with ease! SQL tricky interview questions covers join operations, complex queries, and more. Stand out in your next interview!

sql data-analysis interview-questions datanalytics sql-join sqlqueries sqlquestions

• Updated Feb 25, 2023

Course Files for Javascript, Jquery and Json Coursera. References include jquery and php usage, ajax , jquery autocomplete, sql join usage, php post redirects, sessions usage.

jquery php ajax php-redirections sql-join jquery-autocomplete

• Updated Oct 22, 2020
• PHP

This repository contains solutions to various SQL problems from LeetCode, categorized by difficulty level (Easy, Medium, Hard). Each problem is provided with a SQL script demonstrating its solution.

mysql sql database leetcode sql-query leetcode-solutions sql-join sql-select-statements sql-group-by sql-order-by

• Updated Sep 11, 2024

ASP.NET MVC Framework used to create multi-user inventory management and scheduling system. The project features an HTTP session-based login and delivers user-tailored CRUD operations. Video Walkthrough Below

mysql csharp dapper relational-databases asp-net-mvc inventory-management-system sql-join

• Updated Mar 25, 2024
• C#

Step-by-step SQL tutorials and practical examples covering queries, constraints, transactions, and more. Ideal for beginners, interview prep, and anyone looking to master SQL—from basics to advanced.

mysql sql learning-path postgresql constraints sql-query mysql-server transactions mysql-database joins beginner-friendly sql-queries learn-sql sql-course sql-tutorial sql-join learn-sql-language sql-joins sql-examples

• Updated Sep 23, 2025

Pizza Restaurant Database Design -- Design a pizza restaurant database schema for orders. Include tables for customers, pizzas, and orders with a join table for many-to-many relationships. Populate the database, and write SQL queries to analyze customer spending and order details.

mysql sql sql-query one-to-many many-to-many sql-join

• Updated Mar 18, 2025
• SQL

Analysed data to identify top-selling artists, top customers, and top performing genre

sql postgresql data-analysis sql-queries pgadmin4 sql-functions sql-join sql-cte

• Updated Sep 5, 2023

Analyzed a social media–style database using SQL to uncover user behavior, engagement patterns, and potential bot activity. Designed a relational schema with users, posts, likes, comments, followers, and tags, ensuring referential integrity. Implemented analytical queries to identify top users, posting trends, and interaction insights.

sql social-media-analysis sql-join

• Updated Jan 13, 2026

A TypeScript library providing SQL-like join operations for JavaScript objects. Merge two objects using one of 9 composable join types, with support for deep merging of nested objects.

javascript utility library typescript object merge typescript-library join currying object-merge deep-merge sql-join object-join

• Updated Feb 24, 2026
• TypeScript

SQL projects

mysql sql transaction trigger sql-views hospital-management-system sql-join

• Updated Jan 13, 2019
• PLpgSQL

Sekedar dokumentasi.

mysql php database-management sql-join

• Updated Sep 4, 2022
• PHP

Pizza Restaurant Database Design Assignment - Use SQL to design and create a pizza restaurant database schema for orders. This design includes tables for customers, pizzas, and orders. Utilizing the one-to-many and many-to-many relationships in the databases tables. Create using SQL and write queries to analyze the data contained.

mysql sql mysql-database sql-join one-to-many-relationship many-to-many-relationship

• Updated Apr 21, 2024

Implemented the two-phase merge sort algorithm to sort and then join 2 large SQL relations

external-sorting two-way-merge-sort scratch-implementation sql-join sort-merge-join

• Updated May 23, 2021
• C++

在 java8 的基础上提供一些实用的扩展，让java更加好用

java java8 sql-join

• Updated Oct 25, 2023
• Java

Raw SQL in. Typed Python Objects out. The only ORM that just does ORM.

python sql orm sqlite postgresql introspection code-generation data-models raw-sql object-relational-mapping sql-join uniquery sqlglot typed-orm

• Updated Aug 14, 2025
• Python

Studi kasus sql join pada dropdown auto select.

mysql php ajax dropdown jquery-ajax sql-join

• Updated Jan 29, 2023
• Hack

Indian Census Data Analysis - SQL

sql analysis data-driven postgresql data-analysis sql-join windows-function

• Updated May 26, 2023