A comprehensive SQL learning repository containing SQL practice queries, assignments, joins, nested queries, triggers, table creation scripts, and advanced database concepts using SQL Server Management Studio (SSMS).
This repository is created as part of my learning journey in Data Analytics, Business Intelligence, and Database Management.
This repository includes hands-on SQL practice files covering:
- Basic SQL Queries
- CRUD Operations
- Joins
- Subqueries
- Nested Queries
- Triggers
- Constraints
- Table Creation
- SQL Assignments
- Advanced SQL Concepts
The goal of this repository is to strengthen database querying skills and build a strong foundation for Data Analyst, BI, and Data Engineering roles.
- Microsoft SQL Server
- SQL Server Management Studio (SSMS)
- SQL Queries
- Relational Database Concepts
Contains beginner-level SQL syntax and practice queries.
Includes:
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
Practice files related to:
- Nested SELECT statements
- Correlated subqueries
- Multi-level queries
SQL trigger examples and trigger assignments.
Database and table creation scripts using constraints and keys.
Practice assignments based on real SQL concepts and problem-solving.
Advanced SQL query practice and optimization concepts.
- SELECT Statements
- WHERE Clause
- ORDER BY
- GROUP BY
- HAVING
- Aggregate Functions
- Joins
- Subqueries
- Nested Queries
- Constraints
- Primary & Foreign Keys
- Triggers
- CRUD Operations
- Database Design Basics
This repository was created to:
- Practice SQL concepts regularly
- Build strong database fundamentals
- Prepare for technical interviews
- Improve query writing skills
- Develop real-world database problem-solving ability
- Stored Procedures
- Views
- Functions
- Window Functions
- CTEs
- Query Optimization
- Real-world SQL Projects