a7medhazem/SQL-SERVER-TASKS
This repository contains a complete set of SQL Server tasks and solutions based on the ITI course by Eng. Rami. It covers topics from database fundamentals to advanced SQL Server concepts, serving as a structured reference for learning, practicing, and revision.
SQL-Server-Tasks – ITI Course with Eng. Rami
This repository includes a complete set of SQL Server tasks and concepts based on the YouTube course by Eng. Rami from the ITI program.
It’s designed as a structured reference for learning, practicing, and revising SQL Server – from fundamentals to advanced topics.
⚠️ Note: This repository contains only the questions and their solutions.
No actual database files or schemas are included. All solutions are written manually based on course content.
📚 Topics Covered
✅ Day 1
- Database Lifecycle
- Database Design
- ERD (Entity Relationship Diagram)
- File-Based Systems
- Database Systems
✅ Day 2
- Database Mapping
- Databases
- Schemas
- SQL Basics
- Creating a Database
✅ Day 3
- SQL Joins
- Normalization
✅ Day 4
- Aggregation Functions
- Grouping
- UNION & Subqueries
- Enhanced ERD (EERD)
✅ Day 5
- Database Engine
- Services
- Ranking Functions
- Transact-SQL (T-SQL)
✅ Day 6
- Database Constraints
- Creating Databases in SQL Server
✅ Day 7
- Variables
- Control Flow (IF, WHILE...)
- Functions
✅ Day 8
- Views
- Indexes
- Merge & Pivot Tables
✅ Day 9
- Stored Procedures
- Triggers
- XML in SQL Server
✅ Day 10
- Backup & Restore
- Database Mirroring
- Cursors
- Jobs
- SQLCLR
📝 Notes
💡 All tasks and solutions in this repository are personally solved by me.
I believe all answers are correct, and I’ve put effort into making them accurate and useful.
If you come across any mistakes or have suggestions, please feel free to reach out – I'm always open to feedback and learning more.
🔗 Course Reference
- 📺 YouTube Playlist: ITI SQL Server by Eng. Rami
📄 License
This project is licensed under the MIT License.
You are free to use, modify, and distribute the content for personal or educational purposes, provided that proper credit is given to the original author.