DATABASE AND MANAGEMENT PROGRAMME COURSE DESCRIPTION

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

GENERAL INFORMATION
Language of Instruction :	Turkish
Level of the Course Unit :	, TYY: + , EQF-LLL: , QF-EHEA:
Type of the Course :	Compulsory
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit
Instructor(s) of the Course Unit
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	The aim of this course is to teach students the basic and advanced concepts, architectural structures and applications of database systems.
Contents of the Course Unit:	Students will be introduced to topics such as data warehouse design, ETL processes, data mining, and business intelligence, teaching the practical use of modern data management systems and their strategic advantages. The second half of the course will include an introduction to SQL commands and practical exercises.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Recognize the fundamental concepts of database systems and different database types.
Explain the architectural structure and functions of database management systems.
Learn and design data warehouses and OLAP systems.
Plan and implement ETL processes. Learn about data mining techniques and the importance of business intelligence.
Query and manipulate data using SQL commands.

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	-

SOURCE MATERIALS & RECOMMENDED READING
Winand, M. (2024). SQL Performance Explained. 2nd ed. Markus Winand.
Ramakrishnan, R., & Gehrke, J. (2024). Database Management Systems (4th ed.). McGraw-Hill
Various academic articles and lecture notes. SQL documentation and applications

ASSESSMENT
Assessment & Grading of In-Term Activities	Number of Activities	Degree of Contribution (%)	Description	Examination Method
Mid-Term Exam	1	50
Final Exam	1	50
TOTAL	2	100

Level of Contribution
0	1	2	3	4	5

KNOWLEDGE
Theoretical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Knows the necessary terms and information in the computer field.
2	Gains knowledge of the concept of information security.

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Gains the ability to learn the necessary concepts in the computer field.

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to identify, define, formulate and solve complex Information Security problems; for this purpose, the ability to select and apply appropriate analysis and modeling methods

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to design a complex computer-based system, process, security to meet specific requirements under realistic constraints and conditions; for this purpose, the ability to apply modern design methods.

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to design, conduct experiments, collect data, analyze and interpret results for examining Information Security problems
2	Ability to work effectively within the discipline of Information Security and in multi-disciplinary teams; individual study skills
3	Professional and ethical responsibility awareness
4	Knowledge of project management and business practices such as risk management and change management; awareness of entrepreneurship, innovation and sustainable development

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to develop, select and use modern techniques and tools required for Information Security applications
2	Awareness of the necessity of lifelong learning; ability to access information, follow developments in science and technology, and constantly renew oneself

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to communicate effectively in Turkish orally and in writing, foreign language knowledge

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Information about the effects of Information Security practices on health, environment and security in universal and social dimensions and the problems of the age; Awareness of the legal consequences of Information Security solutions

WORKLOAD & ECTS CREDITS OF THE COURSE UNIT
Workload for Learning & Teaching Activities
Type of the Learning Activites	Learning Activities (# of week)	Duration (hours, h)	Workload (h)
Lecture & In-Class Activities	14	3	42
Preliminary & Further Study	14	3	42
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	14	2	28
Reading	0	0	0
Assignment (Homework)	0	0	0
Project Work	4	3	12
Seminar	0	0	0
Internship	0	0	0
Technical Visit	0	0	0
Web Based Learning	0	0	0
Implementation/Application/Practice	0	0	0
Practice at a workplace	0	0	0
Occupational Activity	0	0	0
Social Activity	0	0	0
Thesis Work	0	0	0
Field Study	0	0	0
Report Writing	0	0	0
Final Exam	1	1	1
Preparation for the Final Exam	14	1	14
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	7	1	7
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	69	0	147