SQL Projects

SQL queries, stored procedures and database design patterns using SQL Server — practical, real-world enterprise examples.

What Is Inside

• Queries — Joins, CTEs, subqueries, window functions, aggregations
• Stored Procedures — Reusable T-SQL with proper error handling
• Database Design — Schema design, normalisation, indexing strategies
• Performance Tuning — Query optimisation, execution plans, index tuning
• Reporting Queries — Business-ready reporting SQL patterns

Who This Is For

Developers, analysts and DBAs learning SQL Server for real enterprise use cases.

Folder Structure

sql-projects/
├── queries/
├── stored-procedures/
├── database-design/
├── performance/
└── reporting/

How to Use

1. Open any .sql file in SQL Server Management Studio or Azure Data Studio
2. Connect to your SQL Server instance
3. Run the scripts — sample data creation scripts are included where needed

---

Free educational resource — real work, real examples. Star ⭐ if useful!