advanced-sql
There are 37 repositories under advanced-sql topic.
leetlab11/Advanced-SQL-50
LeetCode Premium Advanced SQL 50 List- Solved 50/50 problems
leetlab11/SQL-ALL-sorted-Difficulty
SQL Database questions from LeetCode- as many as I can solve sorted by difficulty; current problems solved- 192
faizns/Udemy-Advanced-MySQL-Data-Analysis
Hands-on : Udemy course, Advanced SQL: MySQL Data Analytics & Business Intelligence, Maven Analytics. Requirements - MySQL Workbench
leetlab11/SQL-ALL
SQL Database questions from LeetCode- as many as I can solve; current problems solved- 192
nidea1/SQL_Examples
This repo contains my sql examples and understanding.
emkhv/FAANG_around
SQL Solutions for FAANG Interview Questions
Faisal786111/DBMS
📊 DBMS Mastery: Queries, concepts, and code snippets for database wizards 🧙♂️💾
fahmizainal17/Advanced_SQL_Use_Cases_for_Vehicle_Auction_Analysis_Project
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.
dchandak99/IPL-database
Advanced SQL queries on IPL data
harshima-pt/SQL-Growth--Khan-Academy-Coursework-Challenges
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.
MinaElkholy42/Train-Reservation-System-Database-Design-and-Analysis
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.
sushantsbelapurkar/Stock-Portfolio-Robo-Advisor_2.0
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.
Tungana-Bhavya/SQL
SQL repository contains my answers to the queries and challenges posed by numerous websites like hackerrank, leetcode, w3schools, datalemur, stratascratch, sqlbolt.
vaxdata22/Water-Quality-DW-on-SQL-Server
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.
anilborhade/analyzing-the-trends-in-used-cars-market
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.
crazy-dot/Operation-Analytics-and-Investigating-Metric-
Analysing a company's end-to-end operations.
debargha002/Instagram_User_Analytics
Instagram User Analytics
dharmik2101/SQL
A comprehensive SQL repository with queries organized by industry sectors, including banking, healthcare, energy, manufacturing, and transportation. Designed to solve real-world problems with optimized and scalable solutions, this repository is ideal for learning and tackling industry-specific challenges.
DhruvSavaliya94/SQL-RSVP-Movies-Case-Study
Problem Introduction RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022.
dmarks84/Ind_Project_Movie-Database-SQLite
Independent Project - I joined and manipulated data from disparate tables of movie information using Python & SQLite; defined schema, created tables/views, queried data, etc. Utilized CTE's, Window Functions, and other DDL, DQL, DML, and DCL scripts.
DSKunth/Deforestation-Exploration
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
Escapist-007/DMQL_Projects
The projects are part of the graduate-level course CSE-560 : Data Models and Query Language [Fall 2019 @ UB_SUNY] ... Course Instructor : Jan Chomicki (https://cse.buffalo.edu/~chomicki/)
JoshuaSmart-Olufemi/sql-cohort-analysis
The goal of the project is to build a cohort transition analysis of a user base by month. On a high level, this analysis should show how users' engagement develops over time and how users come into and fall out of the platform again. A cohort by definition is a certain status that's affixed to both a user and a concrete month, depending on user
LKEthridge/Data_Collection_and_Storage_-SQL-
A Data Collection and Storage project using SQL from TripleTen
rchesak/Database-Programming
Create a 3NF DB and manipulate data programmatically.
SyedaNimraFatima/Coffee-Shop-Sales-Analysis-SQL-PowerBI
This Repository's details will be updated in a while.
vaxdata22/Water-Quality-DW-on-Oracle-Database
This is an Oracle DB 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.
venkatasaikarthikeya/8weeks-sql-challenge
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.
LeohangRai/sql-window-functions-examples
bunch of SQL Window function query examples
salimwid/Visualizing_Maritime_Energy_Efficiency_Statistics
[SQL, Django & Heroku] Deployed a Heroku app that visualizes Maritime Energy Efficiency statistics.
shinde-chandrakant/RSVP-MOVIES-case-study-SQL
Conducted data analysis for RSVP Movies, an Indian film production company, to inform their global release strategy. Analyzed data from movies released in the past three years to draw meaningful insights and help the company plan their next project.