Rapor Tarihi: 11.04.2026 16:28
| Course Title | Code | Language | Type | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|---|---|
| - | ETP2309 | Turkish | Compulsory | 3. Semester | 2 + 1 | 3.0 | 4.0 |
| Prerequisite Courses | |
| Course Level | Associate |
| Mode of delivery | Face to Face |
| Course Coordinator | Öğr. Gör. Adem OKUMUŞ |
| Instructor(s) | Öğr. Gör. Adem OKUMUŞ (Bahar), Öğr. Gör. Adem OKUMUŞ (Güz) |
| Goals | The aim of this course is to teach the fundamental concepts of databases, the basics of relational data models, relational database design, and creating and using database objects. In this course, students will learn how to design a database step by step. |
| Course Content | Database Management Systems and Fundamental Concepts, Data Models, Relational Database Model, Entity-Relationship Model, Database Tables, SQL Structured Query Language, SQL Operators, Advanced SELECT Queries, Virtual Tables, Advanced Operators, SQL Functions, DML Operations, TSQL Statements, User-Defined Functions, Stored Procedures, Views, Triggers. |
| # | Öğrenme Kazanımı |
| 1 | Knows basic database concepts. |
| 2 | Designs Databases |
| 3 | Creates/Uses Database Objects |
| 4 | Knows/Uses Structured Query Language |
| Week | Topics/Applications | Method |
|---|---|---|
| 1. Week | Basic Concepts | Practice |
| 2. Week | DDL, DML and Arithmetic Operators | Practice |
| 3. Week | Built-in Functions | Practice |
| 4. Week | Merging Tables | Practice |
| 5. Week | Grouping | Practice |
| 6. Week | Subqueries | Practice |
| 7. Week | Views | Practice |
| 8. Week | Combining Temporary Tables and Query Results | Practice |
| 9. Week | Procedural Structures | Practice |
| 10. Week | Stored Procedures | Practice |
| 11. Week | Triggers | Practice |
| 12. Week | Functions | Practice |
| 13. Week | Error Management, Backup and Restore | Practice |
| 14. Week | Project Presentations | Interview, Presentation (Preparation), Practice |
| No | Program Requirements | Level of Contribution | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 2 | They will gain knowledge about occupational health and safety, environmental awareness, and quality processes. | ✔ | |||||
| Program Requirements | DK1 | DK2 | DK3 | DK4 |
|---|---|---|---|---|
| PY2 | 3 | 3 | 3 | 3 |
| Ders Kitabı veya Notu | Ders Kitabı veya Ders Notu bulunmamaktadır. |
|---|---|
| Diğer Kaynaklar |
|
| Güz Dönemi | |||
| Responsible Personnel | Grup | Evaluation Method | Percentage |
|---|---|---|---|
| Öğr. Gör. Adem OKUMUŞ | Vize | 20.00 | |
| Öğr. Gör. Adem OKUMUŞ | Ödev | 40.00 | |
| Öğr. Gör. Adem OKUMUŞ | Final | 40.00 | |
| Toplam | 100.00 | ||
| ECTS credits and course workload | Quantity | Duration (Hour) | Total Workload (Hour) | |
|---|---|---|---|---|
|
Ders İçi |
Class Hours | 14 | 3 | 42 |
|
Ders Dışı |
Preparation, After Class Study | 11 | 2 | 22 |
| Presentation (Preparation) | 1 | 1 | 1 | |
| Practice | 9 | 1 | 9 | |
| Other Activities | 3 | 1 | 3 | |
|
Sınavlar |
Midterm | 1 | 2 | 2 |
| Homework | 1 | 11 | 11 | |
| Final | 1 | 2 | 2 | |
| Practice End-Of-Term | 10 | 1 | 10 | |
| Total Workload | 102 | |||
| *AKTS = (Total Workload) / 25,5 | ECTS Credit of the Course | 4.0 | ||
