SQL & PL/SQL solutions for Oracle DB — advanced queries and database structures.
-
Updated
May 16, 2025 - PLSQL
#
advanced-query-in-sql
Here are 5 public repositories matching this topic...
Python + SQL — 3 database creation paths (mysql-connector, Workbench Forward Engineering, scripted SQL); automated HR analytics with HRIS-style KPIs, cohort analysis, and a consulting report.
sql etl pandas-dataframe eda seaborn mysql-database matplotlib pyhton mysql-workbench mysql-connector numpy-python advanced-query-in-sql
-
Updated
Oct 10, 2025 - Jupyter Notebook
Comprehensive MLB analytics project using the Lahman Database (1871–2024). Features advanced SQL (joins, CTEs, window functions, optimised views), schema design, reusable transformations, and multi-part analyses on player development, payroll dynamics, and career trajectories — with supporting Python visualisation.
-
Updated
Jan 27, 2026
Este repositorio contiene consultas avanzadas en MySQL usando la base de datos Northwind.
-
Updated
Feb 14, 2025
Analyzing the database of a retailer specializing in scale models of classic cars.
-
Updated
Jul 10, 2023
Improve this page
Add a description, image, and links to the advanced-query-in-sql topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the advanced-query-in-sql topic, visit your repo's landing page and select "manage topics."