| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| Database II | ABL4014 | 4. Semester | 3 + 1 | 4.0 | 5.0 |
| Prerequisites | None |
| Language of Instruction | Turkish |
| Course Level | Associate |
| Course Type | |
| Mode of delivery | Face to Face |
| Course Coordinator |
Lect. Erdi YALÇIN |
| Instructor(s) |
Erdi YALÇIN |
| Assistants | |
| Goals | To teach concepts about database management systems |
| Course Content | Basic and advanced table operations, management of database servers |
| Learning Outcomes |
- İnstalling DBMS, design and creating database - Basic table operations - Advanced table operations - Managing DBMS |
| Week | Topics | Learning Methods |
|---|---|---|
| 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 |
| Ozseven, T., Database Management Systems 2, Murathan Press, Trabzon |
| Gozudeli, Y., SQL Server 2005 and Database Programming, Seckin Press |
| www.w3schools.com |
| www.functionx.com |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | Measurement Method |
|---|
| 0 | 1 | 2 | 3 | 4 | 5 | |
|---|---|---|---|---|---|---|
| Course's Level of contribution | None | Very Low | Low | Fair | High | Very High |
| Method of assessment/evaluation | Written exam | Oral Exams | Assignment/Project | Laboratory work | Presentation/Seminar |
| Event | Quantity | Duration (Hour) | Total Workload (Hour) |
|---|---|---|---|
| Course Hours | 14 | 4 | 56 |
| Preparation, After Class Study | 14 | 2 | 28 |
| 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 | ||
| ECTS Credit of the Course | 5.0 | ||
