| Teaching Staff
|
Dr. Öğr. Üyesi Mehmet Ali ÇİNİCİ |
| Language of Instruction |
Türkçe (Turkish) |
| Type Of Course |
Compulsory |
| Prerequisites |
|
| Recommended Optional Programme Component |
Teaching consists of lectures, questions and answers, seminars, lab applications and practical studies and case studies (database designs). Practical work is done in groups or individually. It is compulsory to attend these events. |
| Course Objectives |
With this course, it is aimed to give the student the competencies of performing advanced operations on the database, using the administrative functions of database management systems and servers. |
| Course Content |
Course content:
Advanced concepts related to database management systems,
• Design / management of data models for database design,
• Query / transaction processing / optimization, normalization and association issues,
• Database system architectures / security, etc. To gain the necessary skills at the comprehension and application level of the subjects. |
| Learning Outcomes (LO) |
After completion of this course the students will be able:
LO.1: To know database systems infrastructure and data models;
LO.2: Performing advanced data operations in the database;
LO.3: To do advanced table operations;
LO.4: Performing normalization processes;
LO.5: Performing other advanced operations;
LO.6: To do basic XML operations;
LO.7: Setting up and configuring the database;
LO.8: To manage, secure and maintain the database server. |
| Mode of Delivery |
Face to face |
| Course Outline |
| Week |
Topics |
| 1. Week |
Installing the database management tool/panel and using its functions |
| 2. Week |
To do the conceptual and physical design of a sample database |
| 3. Week |
Normalization (defining / managing tables / diagrams) |
| 4. Week |
Sequences |
| 5. Week |
Indexes |
| 6. Week |
Synonyms |
| 7. Week |
Views |
| 8. Week |
Midterm Exam |
| 9. Week |
Functions |
| 10. Week |
Stored Procedures |
| 11. Week |
Cursors |
| 12. Week |
Triggers |
| 13. Week |
Transanction and XML concepts/standards |
| 14. Week |
Handling advanced SQL / table operations and exception handling |
|
| Assessment |
| |
Percentage(%) |
| Mid-term (%) |
40 |
| Quizes (%) |
|
| Homeworks/Term papers (%) |
|
| Practice (%) |
|
| Labs (%) |
|
| Projects/Field Work (%) |
|
| Seminars/Workshops (%) |
|
| Final (%) |
60 |
| Other (%) |
|
| Total(%) |
100 |
|
| Course Book (s) and/or References |
1. Prof. Dr. A. Ünal YARIMAĞAN (2000). Veri Tabanı Sistemleri. Akademi & Türkiye Bilişim Vakfı.
2. Ramez Elmasri & Shamkant B. Navathe (2016). Fundamentals of Database Systems. Pearson Higher Education. 7th Global Edition.
3. Atatürk Üniversitesi (2020). Veri Tabanı Yönetim Sistemleri.YÖK Dersleri Platformu. |
| Work Placement(s) |
|
| The Relationship between Program Qualifications (PQ) and Course Learning Outcomes (LO) |
| | PQ.1 | PQ.2 | PQ.3 | PQ.4 | PQ.5 | PQ.6 | PQ.7 | PQ.8 | PQ.9 | PQ.10 | PQ.11 | LO.1 | 4 | 5 | 5 | 5 | | 2 | 2 | | | | | LO.2 | 5 | 5 | 5 | 5 | 3 | | 3 | | | 2 | | LO.3 | 5 | 5 | 5 | 5 | | 4 | 2 | | | | 3 | LO.4 | 5 | | 5 | 5 | 2 | 3 | 3 | | 3 | | | LO.5 | 5 | 5 | 5 | 5 | 4 | | 3 | | | | | LO.6 | 5 | 5 | 5 | 5 | | 3 | 3 | | | 2 | | LO.7 | 5 | 5 | 5 | 5 | | 3 | 3 | | | 2 | | LO.8 | 5 | 5 | 5 | 5 | | 3 | 3 | | | 2 | |
|