LeetCode Premium Advanced SQL 50 List- Solved 50/50 problems

SQL Database questions from LeetCode- as many as I can solve sorted by difficulty; current problems solved- 192

Hands-on : Udemy course, Advanced SQL: MySQL Data Analytics & Business Intelligence, Maven Analytics. Requirements - MySQL Workbench

SQL Database questions from LeetCode- as many as I can solve; current problems solved- 192

This repo contains my sql examples and understanding.

📊 DBMS Mastery: Queries, concepts, and code snippets for database wizards 🧙‍♂️💾

SQL Solutions for FAANG Interview Questions

This project showcases advanced SQL queries and data analysis techniques applied to a dataset of vehicle auctions. The dataset includes data from multiple competitors over several months, with details about car brands, models, manufacture years, auction periods, starting prices, final bid prices, and listing counts.

Khan Academy is an American non-profit educational organization. This is a directory of links to coursework includes: SQL Basic, More Advanced SQL Queries, Relational Queries in SQL, Modifying Databases with SQL.

SQL repository contains my answers to the queries and challenges posed by numerous websites like hackerrank, leetcode, w3schools, datalemur, stratascratch, sqlbolt.

Database Analysis and Design for Train Reservation System. Analysis of User Requirments Phase, Design of ERD, Schema, Implementation of Physical Tables, Populating Data, and Queries to Analyze the Data. Views for the security of data and helping analyze the rest of the tables.

This is an MSSQL Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.

This advanced version of the initial Stock-Portfolio-Robo-Advisor project utilizes advanced SQL, Python, and Airflow for data storage and analysis. The data warehouse contains millions of rows and fetches results for each company and historical prices from an API, enabling comprehensive analysis using different complex algorithmic techniques.

Advanced SQL

A Data Collection and Storage project using SQL from TripleTen

Create views, simple and complex SQL queries to answer questions from the fictitious ForestQuery management about the deforestation’s global situation, regional outlook, and country-level details

Advanced SQL queries on IPL data

Get ready to boost your SQL proficiency, solve intriguing data problems, and earn a sense of accomplishment as you complete this 8-week journey. Whether you're a data analyst, a database administrator, or simply passionate about data, the '8 Weeks of SQL Challenge' will help you level up your SQL skills and open up new opportunities.

In the "Analyzing Trends in the Used Cars Market" project, I leveraged advanced SQL functions and subqueries to perform an in-depth analysis of the Cars-24 dataset. By employing SQL aggregate functions and complex queries, I extracted meaningful insights, identified significant trends, and optimized operations.