Skip to content

README.md

Latest commit

 

History

History
125 lines (84 loc) · 2.7 KB

README.md

File metadata and controls

125 lines (84 loc) · 2.7 KB

📘 SQL Learning & Practice Repository

This repository is a personal archive of SQL projects, sample databases, and practice challenges I’ve worked through. It’s where I keep track of the tools I’ve used, the datasets I’ve explored, and the kinds of problems I’ve tackled across different SQL environments

🎓 Courses & Training

SQL Essential Training

Foundational SQL concepts including:

  • SELECT, WHERE, ORDER BY
  • JOINs and relationships
  • Aggregations and grouping
  • Basic data cleaning patterns

SQL for Data Analysis: Advanced Querying Techniques

Focused on analytical SQL patterns:

  • Window functions
  • Subqueries and nested logic
  • CTEs and recursive queries
  • Real‑world business scenarios

🗂️ Practice Databases & Projects

MathDB

A practice database for exploring:

  • Mathematical expressions
  • Aggregate functions
  • Order of operations
  • “What‑if” calculations and scenario analysis

This project helped reinforce how SQL handles arithmetic, grouping, and numeric logic.
Tutorial credit: DigitalOcean.

Chinook Digital Music Store

A data analysis project based on a fictional digital music store.
Includes information on:

  • Artists, albums, and tracks
  • Employees and customers
  • Invoices and sales

Used to practice:

  • Multi‑table joins
  • Customer behavior analysis
  • Sales insights
  • Query optimization

AdventureWorks 2022

A full OLTP database for a fictional bicycle manufacturer.
Covers:

  • Manufacturing
  • Sales
  • Purchasing
  • Product management
  • Human resources

Used for:

  • Complex joins
  • Relational modeling
  • Business‑style reporting queries

Northwind Traders — Maven Analytics Challenge

Sales and order data for a fictional gourmet food supplier.
Includes:

  • Customers
  • Products
  • Orders
  • Shippers
  • Employees

This dataset was part of a Maven Analytics challenge (May 2023) and is great for practicing:

  • Sales analysis
  • KPI development
  • Trend exploration
  • Multi‑table joins

🐘 PostgreSQL Practice

Hands‑on SQL work using PostgreSQL, including:

  • Database creation
  • Schema exploration
  • Data cleaning
  • Window functions
  • CTE‑based analysis

🧰 Tools Used

  • SQL Server Management Studio (SSMS)
  • MySQL / MariaDB
  • PostgreSQL (psql, pgAdmin, VS Code extension)
  • DB Browser for SQLite
  • VS Code

🎯 Purpose of This Repository

This repo is just a place for me to collect the databases I practice on and the SQL projects and challenges I’ve worked through. It reflects ongoing learning and hands‑on exploration across multiple SQL platforms.