TR EN

DATABASE APPLICATIONS COURSE IDENTIFICATION AND APPLICATION INFORMATION

Code Name of the Course Unit Semester In-Class Hours (T+P) Credit ECTS Credit
BGT207 DATABASE APPLICATIONS 3 3 2 4

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week Preparatory Topics(Subjects) Method
1 - Database Systems and Data Models Instruction
2 Research Relational Database Model Instruction
3 Research Entity-Relationship Model Instruction
4 Research Normalization of Database Tables Demonstration
5 Research Introduction to SQL Programming Language Demonstration
6 Research Functions Used in SQL Language Demonstration
7 Research Functions Used in SQL Language Demonstration
8 - MID-TERM EXAM -
9 - Database Problem Solutions Demonstration
10 Research Advanced SQL Programming Demonstration
11 Research Database Design Demonstration
12 Research Transaction Management and Concurrency Control (Dynamic T-SQL) Demonstration
13 Research Database Performance Settings and Query Optimization Demonstration
14 Research Query and Access Security Demonstration
15 Research Backup and Restoring from Backup Demonstration
16 - FINAL EXAM -
17 - FINAL EXAM -