TR EN

DATABASE BASICS COURSE IDENTIFICATION AND APPLICATION INFORMATION

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

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week Preparatory Topics(Subjects) Method
1 Literature research Data and Database Concepts, Needs Analysis Expression
2 Research Data Models, Entity Relationship Diagram Expression
3 Research Normalization Application
4 Research Installing Database Tools, Creating Tables and Specifying Properties Application
5 Research Creating Tables and Specifying Properties Application
6 Research Create Query and Using The Type Application
7 Research Creating Query and Using Its Types, Preparing Query with Related Tables Application
8 - MID-TERM EXAM -
9 Research Preparing Query with Related Tables Application
10 Research Using DML Queries Application
11 Research Using DML Queries, Writing User Queries Application
12 Research Writing View Queries, Writing Trigger Queries Application
13 Research Writing Subprogram Queries, Making Transactions Application
14 Research Writing Index Queries Application
15 Research Database Security and Backup Application
16 - FINAL EXAM -
17 - FINAL EXAM -