About the project

This repository contains a curated collection of Transact-SQL (T-SQL) scripts designed for learning, reference, and practice using the AdventureWorks sample database.
Each script demonstrates key SQL Server concepts and operations, from basic querying and joins to more advanced topics like window functions, stored procedures, and common table expressions (CTEs).


Link to the project files: github.com/Al-1n/T-SQL

Requirements

Microsoft SQL Server (T-SQL)
AdventureWorks Database
Visual Studio Code


How to use this project

  1. Clone the repository
  2. Connect VS Code to your SQL Server instance
  3. Open and execute any .sql file against the AdventureWorks database

Contributors

Alin Airinei


Features


  • Organized T-SQL examples by topic (reading data, inserting data, updating data, transactions, stored procedures, etc.)
  • Compatible with SQL Server and VS Code SQL extensions
  • Tested against the AdventureWorks database
  • Ideal for reference, learning, or interview preparation


Sample Workspace