PostgreSQL performance essentials in 1 hour

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

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.

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

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.

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.

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.

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

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.

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

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.

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.

SQL projects

Studi kasus sql join pada dropdown auto select.

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

Indian Census Data Analysis - SQL

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

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

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.

Sekedar dokumentasi.