|
|
| YZT2001 | Object Oriented Programming- I | 3+2+0 | ECTS:5 | | Year / Semester | Fall Semester | | Level of Course | Short Cycle | | Status | Compulsory | | Department | Computer Technology | | Prerequisites and co-requisites | None | | Mode of Delivery | | | Contact Hours | 14 weeks - 3 hours of lectures and 2 hours of practicals per week | | Lecturer | Öğr. Gör. Elif ARAS | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | The Database Technologies course aims to provide students with an understanding of modern database systems used for the effective storage, management, and processing of data. This course focuses on database design, data modeling, SQL querying, data security, performance optimization, and the applications of contemporary database technologies. The goal is to equip students with both theoretical and practical knowledge, enabling them to excel in database management and solving data-driven problems.
|
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | SQL deyimleri | 1,3,5,7 | 1, | | LO - 2 : | Writing Example Queries Related to SQL Statements | 1,2,3,7 | | | LO - 3 : | Creating Database Queries | 1,2,3,7 | | | LO - 4 : | Performing Database-Related Operations | | | | LO - 5 : | Performing Auxiliary Operations Related to Databases | 1,2,3,7 | | | LO - 6 : | Creating a Database | 1,2,3,7 | | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome | | |
| Introduction to Database Technology with SQL |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | SQL Installation | | | Week 2 | Database Components | | | Week 3 | Relational Database Management | | | Week 4 | Data Storage Models | | | Week 5 | Network Database Component | | | Week 6 | Programming Tools
| | | Week 7 | SQL Management Programs / Midterm | | | Week 8 | SQL Graph | | | Week 9 | Midterm Exam | | | Week 10 | SQL Server Architecture
| | | Week 11 | Disk Management Architecture
| | | Week 12 | User Management Architecture | | | Week 13 | Server Tools | | | Week 14 | File Systems | | | Week 15 | Operating System Selection / Final | | | Week 16 | Final Exam | | | |
| 1 | ÖZSEVEN TURGUT, VERİTABANI YÖNETİM SİSTEMLERİ 1 MURATHAN YAYINLARI | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | | 1 | 50 | | In-term studies (second mid-term exam) | 16 | | 1 | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | Yüz yüze eğitim | 3 | 15 | 45 | | Sınıf dışı çalışma | 2 | 15 | 30 | | Laboratuar çalışması | 2 | 15 | 30 | | Arasınav için hazırlık | 1 | 8 | 8 | | Arasınav | 1 | 1 | 1 | | Ödev | 1 | 15 | 15 | | Proje | 2 | 15 | 30 | | Dönem sonu sınavı için hazırlık | 1 | 15 | 15 | | Dönem sonu sınavı | 1 | 1 | 1 | | Total work load | | | 175 |
|