SQL-SERVER-TASKS

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

SQL-SERVER-TASKS

(★ 45)

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 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 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](https://www.youtube.com/playlist?list=PLoRh0POuk1Rw-BZU-DPI6cA_c5W9_2uF_)

---

## 📄 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.

SQL-SERVER-TASKS

SQL-SERVER-TASKS 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

SQL-SERVER-TASKS

SQL-SERVER-TASKS 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README