TR EN

DATABASE AND MANAGEMENT COURSE IDENTIFICATION AND APPLICATION INFORMATION

Code Name of the Course Unit Semester In-Class Hours (T+P) Credit ECTS Credit
BGT253 DATABASE AND MANAGEMENT 3 3 3 6

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY

Week Preparatory Topics(Subjects) Method
1 - Introduction and Basic Concepts (Data, information, database concepts) Expression
2 Research Database Types and Architectural Structures (Central, distributed and cloud-based database structures) Expression
3 Research DBMS and Advanced Topics (Data integrity, transaction management, ACID rules) Expression
4 Research Data Warehouses and OLAP Systems (Data warehouse concept, OLAP architectures) Expression
5 Research Data Warehouse Design and ETL Processes (ETL processes and data integration techniques) Expression
6 Research Data Mining and Business Intelligence (Data mining techniques, business intelligence concepts and applications) Expression
7 Research Pre-Visa Review -
8 Research Introduction to SQL and Basic Commands (SELECT, FROM, WHERE) Lecture, Application
9 Research Data Manipulation (INSERT, UPDATE, DELETE) Lecture, Application
10 - MID-TERM EXAM -
11 Research SQL Functions and Grouping (HAVING, GROUP BY) Lecture, Application
12 Research Advanced SQL Commands (JOIN, subqueries) Lecture, Application
13 Research Applications and Exam Preparation (Practical studies) Application
14 - Applications and Exam Preparation (Practical studies) Application
15 - Applications and Exam Preparation (Practical studies) Application
16 - FINAL EXAM -
17 - FINAL EXAM -