|
TBIL2017 | Database II | 3+1+0 | ECTS:4 | Year / Semester | Fall Semester | Level of Course | Short Cycle | Status | Compulsory | Department | DEPARTMENT of COMPUTER TECHNOLOGIES | Prerequisites and co-requisites | None | Mode of Delivery | Face to face, Lab work , Practical | Contact Hours | 14 weeks - 3 hours of lectures and 1 hour of practicals per week | Lecturer | Dr. Öğr. Üyesi Beste ÜSTÜBİOĞLU | Co-Lecturer | | Language of instruction | Turkish | Professional practise ( internship ) | None | | The aim of the course: | Be able to gain competencies about managing the database and servers. Prepare interface/report on the client / server database.
|
Learning Outcomes | CTPO | TOA | Upon successful completion of the course, the students will be able to : | | | LO - 1 : | Design the database.
| 1,2,8 | 1,3,6 | LO - 2 : | Use the SQL Server management software effectively.
| 1,2,8 | 1,3,6 | LO - 3 : | Take the necessary steps on Relational Databases.
| 1,2,8 | 1,3,6 | LO - 4 : | Make database performance analysis and optimization. | 1,2,8 | 1,3,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 | |
1. Design criteria for databases,
2. Setup at least two server software from two different industry standard manufacturers.
3. Create the database and define users, identify tables and manage diagrams.
4. Create a new database from an existing database, edit the view, the trigger, the indexes and the subroutines.
5. Edit the user roles and user-defined data types.
6. Make performance analysis and improvements.
|
|
Course Syllabus | Week | Subject | Related Notes / Files | Week 1 | Setup at least two server software from two different industry standard manufacturers.
| | Week 2 | Setup database management panel, create the database and define users.
| | Week 3 | Create the database and define users, identify tables and manage diagrams.
| | Week 4 | Identify tables and manage diagrams, make the data transfer operations.
| | Week 5 | Data transfer operations, create a new database from an existing database.
| | Week 6 | Create a new database from an existing database, edit the view, the trigger, the indexes and the subroutines.
| | Week 7 | Edit the view, the trigger, the indexes and the subroutines.
| | Week 8 | Edit the view, the trigger, the indexes and the subroutines, edit the user roles and user-defined data types. | | Week 9 | Midterm Exam | | Week 10 | Edit the user roles and user-defined data types.
| | Week 11 | Edit the rules and the default values. | | Week 12 | Edit the rules and the default values, and make data replication operations and maintenance plan. | | Week 13 | Make data replication operations and maintenance plan. | | Week 14 | Make performance analysis and improvements. | | Week 15 | Learn the database management rules. Ensure the security of the database. | | Week 16 | Final Exam | | |
1 | Gözüdeli, Y. 2013. Yazılımcılar için SQL Server 2012 Veri Tabanı Programlama, Seçkin Yayıncılık, Ankara | | |
1 | Inan, Y. ve Demirli, N. 2005. Visual C(Sharp) . NET ile veri tabani, Palme Yay | | 2 | Özkan, Y. 2009. Veri Tabani Sistemleri, Alfa Yayinevi, Istanbul. | | |
Method of Assessment | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | Mid-term exam | 9 | | 1 | 30 | End-of-term exam | 16 | | 1 | 70 | |
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 | Laboratuar çalışması | 1 | 14 | 14 | Arasınav için hazırlık | 6 | 1 | 6 | Arasınav | 1 | 1 | 1 | Uygulama | 1 | 14 | 14 | Klinik Uygulama | 0 | 0 | 0 | Ödev | 0 | 0 | 0 | Proje | 0 | 0 | 0 | Kısa sınav | 0 | 0 | 0 | Dönem sonu sınavı için hazırlık | 8 | 1 | 8 | Dönem sonu sınavı | 1 | 1 | 1 | Diğer 1 | 0 | 0 | 0 | Diğer 2 | 0 | 0 | 0 | Total work load | | | 100 |
|