INTRODUCTION TO DATABASE PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
YBS205	INTRODUCTION TO DATABASE	3	3	3	6

GENERAL INFORMATION
Language of Instruction :	Turkish
Level of the Course Unit :	BACHELOR'S DEGREE, TYY: + 6.Level, EQF-LLL: 6.Level, QF-EHEA: First Cycle
Type of the Course :	Compulsory
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit	Assist.Prof. DİDEM TETİK KÜÇÜKELÇİ
Instructor(s) of the Course Unit	Assist.Prof. MERVE VURAL ALLAHAM
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	This course aims to understand the concept of data, to model different structures, to list the functions of databases, to create the necessary infrastructure to develop queries by using relational databases.
Contents of the Course Unit:	Contents of the course include the subjects such as data concept, data structures, data models, access to databases, database components, relational databases, table creation, indexing, sorting and querying.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Describe concepts of data and database.
Discover the relational data model.
Experiment the relational structure of a business's information system.
Act data transfer from external environments.
Practice various queries on tables.
Design data entry forms.
Prepare reports from data.

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	-	Introduction to Databases and Basic Concepts	Lecture & Discussion & Practice
2	Literature Review	Database Management Systems	Lecture & Discussion & Practice
3	Literature Review	ER (Entity-Relationship) Models and Diagrams	Lecture & Discussion & Practice
4	Literature Review	Normalization	Lecture & Discussion & Practice
5	Literature Review	Introduction to Microsoft SQL Server and Basic Commands	Lecture & Discussion & Practice
6	Literature Review	Data Types and Table Creation	Lecture & Discussion & Practice
7	Literature Review	Data Update and Deletion Operations (DDL and DML Commands – CREATE, ALTER, DROP, SELECT, INSERT, UPDATE, DELETE)	Lecture & Discussion & Practice
8	Literature Review	Filtering with WHERE, AND, OR Queries	Lecture & Discussion & Practice
9	Literature Review	Sorting and Grouping with ORDER BY and GROUP BY	Lecture & Discussion & Practice
10	-	MID-TERM EXAM	-
11	Literature Review	Mathematical Functions	Lecture & Discussion & Practice
12	Literature Review	Join Operations (LEFT JOIN, RIGHT JOIN, and FULL JOIN)	Lecture & Discussion & Practice
13	Literature Review	Subqueries	Lecture & Discussion & Practice
14	Literature Review	String Functions	Lecture & Discussion & Practice
15	Literature Review	Date Functions	Lecture & Discussion & Practice
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
Şehirli, E., Turan, M. K., & Özdemir, B. G. (2023). Veritabanı geliştirme temelleri - Veritabanı kavramları, veritabanı tasarımı SQL ile çözümlü örnekler (1. baskı). Ankara: Nobel Akademik Yayıncılık.
Aydemir, E. (2023). MS-SQL ile veritabanı ve veritabanı yönetim sistemleri (1. baskı). Ankara: Nobel Akademik Yayıncılık.
Kıran, S. (2021). İlişkisel veritabanı tasarlama ve SQL ile geliştirme (1. baskı). Ankara: Nobel Akademik Yayıncılık.

ASSESSMENT
Assessment & Grading of In-Term Activities	Number of Activities	Degree of Contribution (%)	Description	Examination Method
Mid-Term Exam	1	30		Classical Exam
Homework Assessment	1	10
Practice	1	10
Final Exam	1	50		Classical Exam
TOTAL	4	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	Define concepts such as management, manager and leader.				3
2	Analyze the accuracy, reliability and validity of the new information obtained from the data.					4

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Report the obtained data.						5
2	Prepare software and projects related with the field.						5

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Use the appropriate resources for data analysis related with the field.						5
2	Analyze the work processes.						5

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Manage projects as part of a team.						5
2	Apply the material, techniques and analyzes in relation with the subject for project and work flows.						5

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Fulfill responsibility with a focus on result in individual and team studies.						5

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Recognizes what he/she knows about his/her field or not.						5
2	Act the theoretical knowledge in real life with learning to learn approach.						5
3	Apply different methods and techniques with an innovative approach in his/her research.						5

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Apply the results obtained in accordance with voluntarism and social responsibility projects.						5
2	Establish a healthy contact with colleagues						5
3	Share the analyzes and obtained results with colleagues.						5
4	Cooperate with colleagues at international level with the help of foreign language competency.					4

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Behave in accordance with ethical values regarding the collection, analysis and reporting of data.					4
2	Participate the design of work processes and systems with full quality.						5
3	Cooperate with other employees for the continuation of sustainability in the profession.					4

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	13	2	26
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	12	1	12
Project Work	0	0	0
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	7	5	35
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	6	6	36
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	54	0	153