|
|
| YBS2002 | Database Management Systems | 2+1+0 | ECTS:7 | | Year / Semester | Spring Semester | | Level of Course | First Cycle | | Status | Compulsory | | Department | DEPARTMENT of MANAGEMENT INFORMATION SYSTEMS | | Prerequisites and co-requisites | None | | Mode of Delivery | | | Contact Hours | 14 weeks - 2 hours of lectures and 1 hour of practicals per week | | Lecturer | Dr. Öğr. Üyesi Murat KILINÇ | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | The aim of this course is to enable students to gain knowledge and skills about advanced database management and usage. |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | Know advanced SQL issues | 2 - 4 - 6 | | | LO - 2 : | Know the security principles in databases | 2 - 4 - 6 | | | LO - 3 : | Know user management in databases | 2 - 4 - 6 | | | LO - 4 : | Uses standard data formats such as XML and JSON | 2 - 4 - 6 | | | 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 | | |
| In this course, advanced SQL issues in database management systems, user management and security in databases, XML and JSON data formats and examples are given. |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | SQL(Views) | | | Week 2 | SQL(Functions) | | | Week 3 | SQL(JOIN) | | | Week 4 | SQL(Stored Procedures) | | | Week 5 | SQL(Regular Expressions) | | | Week 6 | SQL(Injection) | | | Week 7 | SQL (Transactions) | | | Week 8 | SQL (Cursor) | | | Week 9 | Midterm Exam | | | Week 10 | User Management | | | Week 11 | XML and JSON | | | Week 12 | Sample Applications-1 | | | Week 13 | Sample Applications-2 | | | Week 14 | Sample Applications-3 | | | Week 15 | Sample Applications-4 | | | Week 16 | Final Exam | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | 19/04/2024 | 1 | 50 | | End-of-term exam | 16 | 10/06/2024 | 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 | 14 | 42 | | Sınıf dışı çalışma | 1 | 14 | 14 | | Arasınav için hazırlık | 2 | 8 | 16 | | Arasınav | 1 | 1 | 1 | | Dönem sonu sınavı için hazırlık | 2 | 6 | 12 | | Dönem sonu sınavı | 1 | 1 | 1 | | Total work load | | | 86 |
|