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 - MID-TERM EXAM -
9 Research Introduction to SQL and Basic Commands (SELECT, FROM, WHERE) Lecture, Application
10 Research Data Manipulation (INSERT, UPDATE, DELETE) Lecture, Application
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 -