| Course Title | Code | Language | Type | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|---|---|
| Database II | ABL4014 | Turkish | Compulsory | 4. Semester | 3 + 1 | 4.0 | 5.0 |
| Prerequisite Courses | |
| Course Level | Associate |
| Mode of delivery | Face to Face |
| Course Coordinator | Dr. Öğr. Üyesi Fatih İLKBAHAR |
| Instructor(s) | |
| Goals | To teach concepts about database management systems |
| Course Content | Basic and advanced table operations, management of database servers |
| # | Öğrenme Kazanımı |
| 1 | İnstalling DBMS, design and creating database |
| 2 | Basic table operations |
| 3 | Advanced table operations |
| 4 | Managing DBMS |
| Week | Topics/Applications | Method |
|---|---|---|
| 1. Week | Installing two different DBMS | |
| 2. Week | Setting up DBMS control panel, design and create database, create logins/users | |
| 3. Week | Desing and create database, create users/logins, desing and create tables, diagrams | |
| 4. Week | Create and design tables, diagrams, data transferring | |
| 5. Week | Data transferring, creating a copy of existing database | |
| 6. Week | Views, triggers, sub programs/queries and indexes | |
| 7. Week | Views, triggers, sub programs/queries and indexes | |
| 8. Week | Views, triggers, sub programs/queries, indexes | |
| 9. Week | User roles, user defined data types | |
| 10. Week | Rules and defaults | |
| 11. Week | Rules and defaults, backup and maintenance plans | |
| 12. Week | Backup and maintenance plans | |
| 13. Week | Performance analysis and optimizations | |
| 14. Week | Performance analysis and optimization |
| Program Requirements | DK1 | DK2 | DK3 | DK4 |
|---|
| Ders Kitabı veya Notu | Ders Kitabı veya Ders Notu bulunmamaktadır. |
|---|---|
| Diğer Kaynaklar |
|
| ECTS credits and course workload | Quantity | Duration (Hour) | Total Workload (Hour) | |
|---|---|---|---|---|
|
Ders İçi |
Class Hours | 14 | 4 | 56 |
|
Ders Dışı |
Preparation, After Class Study | 14 | 2 | 28 |
|
Sınavlar |
Midterm 1 | 1 | 1 | 1 |
| Midterm 2 | 1 | 1 | 1 | |
| Homework 1 | 2 | 2 | 4 | |
| Homework 2 | 2 | 2 | 4 | |
| Quiz 1 | 1 | 1 | 1 | |
| Quiz 2 | 1 | 1 | 1 | |
| Final | 1 | 1 | 1 | |
| Practice | 2 | 2 | 4 | |
| Practice End-Of-Term | 1 | 1 | 1 | |
| Total Workload | 102 | |||
| *AKTS = (Total Workload) / 25,5 | ECTS Credit of the Course | 5.0 | ||
