TR EN

ISTANBUL GELİŞİM UNIVERSITY INFORMATION SYSTEM

DATABASE MANAGEMENT SYSTEMS II COURSE IDENTIFICATION AND APPLICATION INFORMATION

Code Name of the Course Unit Semester In-Class Hours (T+P) Credit ECTS Credit
CMP152 DATABASE MANAGEMENT SYSTEMS II 2 2 2 7

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 Research Database Problem Solutions Demonstration
9 Research Advanced SQL Programming Demonstration
10 - MID-TERM EXAM -
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 -