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.

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

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

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

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.

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.

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.

SQL projects

Indian Census Data Analysis - SQL

Studi kasus sql join pada dropdown auto select.

Sekedar dokumentasi.

test repository

Utilized MySQL to run queries and analyze the Sakila schema

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.

Query a Digital Music Store Database, For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information.

This is a Portfolio Project exploring covid 19 data using SQL.

DataCamp project (SQL) - When Was the Golden Age of Video Games?