advanced-sql | Topic | Ecosyste.ms: Repos

Topic: "advanced-sql"

nidea1/SQL_Examples

This repo contains my sql examples and understanding.

Language: TSQL - Size: 16.6 KB - Last synced at: 7 months ago - Pushed at: over 2 years ago - Stars: 4 - Forks: 2

leetlab11/SQL-ALL

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

Size: 567 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 3 - Forks: 0

leetlab11/Advanced-SQL-50

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

Size: 159 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 3 - Forks: 0

labex-labs/advanced-postgresql-practical-labs

In this course, master PostgreSQL through hands-on labs covering relationships, advanced data types, indexing, transactions, views, permissions, queries, triggers, backups, partitioning, full-text search, and more.

Size: 58.6 KB - Last synced at: 15 days ago - Pushed at: 15 days ago - Stars: 2 - Forks: 0

emkhv/FAANG_around

SQL Solutions for FAANG Interview Questions

Size: 80.1 KB - Last synced at: 11 months ago - Pushed at: 11 months ago - Stars: 2 - Forks: 1

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.

Size: 208 KB - Last synced at: 8 months ago - Pushed at: about 1 year ago - Stars: 2 - Forks: 0

faizns/Udemy-Advanced-MySQL-Data-Analysis

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

Size: 1.25 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 2 - Forks: 1

Tungana-Bhavya/SQL

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

Size: 14.3 MB - Last synced at: 17 days ago - Pushed at: 18 days ago - Stars: 1 - Forks: 1

OsarohEkhoragbon/Employee-Data-Insights-HR-Analytics-SQL

This project demonstrates how SQL can be leveraged to provide HR with meaningful, data-backed insights using PostgreSQL to uncover insights into employee retention, performance trends, attendance behavior, and salary fairness at a growing tech company, NextGen Corp

Size: 20.4 MB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 1 - Forks: 0

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.

Language: Jupyter Notebook - Size: 394 KB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 1 - Forks: 1

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.

Language: SQL - Size: 3.07 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

leetlab11/SQL-ALL-sorted-Difficulty

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

Size: 252 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 1

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.

Size: 11.4 MB - Last synced at: 17 days ago - Pushed at: almost 3 years ago - Stars: 1 - Forks: 1

dchandak99/IPL-database

Advanced SQL queries on IPL data

Language: Python - Size: 154 KB - Last synced at: over 2 years ago - Pushed at: over 4 years ago - Stars: 1 - Forks: 0

labex-labs/sqlite-intermediate-to-advanced

In this course, delve into advanced SQLite techniques. Master constraints, indexing, joins, subqueries, transactions, triggers, views, full-text search, JSON, backups, PRAGMA tuning, CTEs, window functions, and more!

Size: 33.2 KB - Last synced at: 15 days ago - Pushed at: 15 days ago - Stars: 0 - Forks: 0

marias101/Advanced-SQL-Analytics-Toolkit

Advanced SQL toolkit featuring recursive CTEs, window functions, JSON parsing, dynamic pivoting, lateral joins, and query optimization for scalable, high-performance data analytics and MAANG-level technical mastery.

Size: 512 KB - Last synced at: 18 days ago - Pushed at: 19 days ago - Stars: 0 - Forks: 0

HussienDataAnalyst/SQL-Practice-Questions

A collection of real-world SQL practice questions with solutions, designed to strengthen query skills for data analysis and business insights. Includes scenarios for aggregation, joins, filtering, and advanced SQL techniques.

Size: 3.91 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Gaurav-3002/Cognizant-Deep-Skilling_6362814

A week‑by‑week, module‑wise archive of hands‑on solutions from Cognizant’s 8‑week Deep Skilling DotNet FSE program.

Size: 2.28 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

manishamanchana/sql-learning

🧠 Structured SQL Learning Repository | Beginner to Advanced Topics + Real Projects 🎯 Covers core SQL skills, window functions, performance tuning, and hands-on data warehousing/EDA projects

Language: TSQL - Size: 3.76 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

shivee-code/sql_project_portfolio

A collection of real-world SQL projects focused on business insights, data analysis, and advanced querying using MySQL.

Size: 199 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

SyedaNimraFatima/Coffee-Shop-Sales-Analysis-SQL-PowerBI

A dynamic Power BI dashboard for analyzing sales, product trends, and customer behavior across NYC coffee shops. Built using Excel, DAX, and custom visuals to support business intelligence and decision-making.

Size: 8.33 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

piyushkumar2025/Analytical-SQL-Project-Exploring-Trends-Segmentation-KPIs

A complete SQL analytics project using a simulated data warehouse. It analyzes sales, customer, and product data with CTEs, joins, window functions, subqueries, and views to deliver insights on trends, segmentation, and KPIs, showing how SQL enables data-driven decisions without BI tools.

Size: 4.15 MB - Last synced at: 4 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

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.

Language: Jupyter Notebook - Size: 380 KB - Last synced at: 5 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

velvirt/Data_Collection_and_Storage_-SQL-

A Data Collection and Storage project using SQL from TripleTen

Size: 1000 Bytes - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

LKEthridge/Data_Collection_and_Storage_-SQL-

A Data Collection and Storage project using SQL from TripleTen

Language: Jupyter Notebook - Size: 162 KB - Last synced at: 10 days ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

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

Size: 8.79 KB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 1

crazy-dot/Operation-Analytics-and-Investigating-Metric-

Analysing a company's end-to-end operations.

Size: 743 KB - Last synced at: 7 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

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.

Size: 1000 Bytes - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0