sql-portfolio

A simple tutorial on how to use the Markdown markup language to showcase your SQL/Data Analytics portfolio on Github.

A full lifecycle of a database system for a small fast-food restaurant, covering design, deployment, and data analysis. Includes ER diagrams, schema design, and advanced SQL queries. Tools used: MySQL, Docker, and Azure Data Studio. All essential files are provided to replicate the database and conduct analysis.

SQL-based analytical case study on a Rapido ride-hailing dataset, covering user behavior, ride patterns, vehicle performance, and cohort analysis using BigQuery SQL.

Gaming, CRM, Fintech ve WFM gibi 6 farklı sektörde; Retention, Churn, Whale Analysis ve RFM Segmentasyonu gibi kritik iş problemlerini SQL ile çözümlediğim kapsamlı bir portfolyo çalışmasıdır.

Analyzing $33B in lending data across 2 Million+ records to identify credit risk patterns using Python, SQL, and Power BI.

SQL Database project based on Online Bookstore System. Includes database schema design, CSV dataset import, SQL queries, data analysis, revenue & inventory insights using PostgreSQL.

Structured SQL portfolio covering database design,joins,subqueries,CTEs,window,functions,transactions,and analytical SQL using My SQL

Enterprise-grade SQL portfolio isolating advanced database engineering from any dashboard or app layer — window functions, recursive CTEs, transactional stored procedures, triggers, and measured query optimization on PostgreSQL, verified with real EXPLAIN ANALYZE evidence.

SQL-based business analytics on the Online Retail II dataset, answering core customer, revenue, retention, and product performance questions.

Digital Music Store Data Analysis via SQL. Features sequential schema joins, dynamic scalar subqueries, CTEs, and DENSE_RANK() window functions to isolate top spenders and handle multi-genre regional ties cleanly.

A collection of my SQL projects with insights into real-world datasets.

SQL-portfolio project for a food delivery app - schema-designs,joins,window functions,aggregation ,..

Clinical Trial Data Analysis: SQL Portfolio Project. This project simulates a real-world Clinical Trial Data Management System for the pharmaceutical industry. The objective is to analyze patient enrollment, clinical trial phases, drug efficacy (via dropout rates), and adverse drug reactions (side effects) using SQL

ostgreSQL database analysis project solving community council queries using advanced SQL techniques including JOINs, aggregations, and window functions

End-to-end SQL project in MySQL: a data warehouse (Medallion Architecture, Bronze/Silver/Gold) built from CRM & ERP data, plus a full analytics layer covering exploration, segmentation, ranking, trends, and customer/product reporting.

SQL portfolio project analyzing 2,000 barbershop customer visits — customer segmentation, retention/churn, service revenue mix, and Pareto analysis using window functions, CTEs, and conditional aggregation in SQLite.

End-to-end data analysis project using SQL, Python, and Power BI to predict and mitigate customer churn.

SQL portfolio project analyzing the Netflix Movies & TV Shows dataset in PostgreSQL — 15 real-world business problems solved using window functions, CTEs, array parsing, and date functions.

SQL solutions for Case Study #1 (Danny's Diner) from the 8 Week SQL Challenge

33 SQL queries (basic → advanced → window functions) solved on a self-designed 6-table dataset — joins, subqueries, pivots, running totals