1	Course Title:	DATABASE MANAGEMENT SYSTEMS
2	Course Code:	BIL2106
3	Type of Course:	Compulsory
4	Level of Course:	First Cycle
5	Year of Study:	2
6	Semester:	4
7	ECTS Credits Allocated:	3
8	Theoretical (hour/week):	3
9	Practice (hour/week) :	0
10	Laboratory (hour/week) :	0
11	Prerequisites:	-
12	Recommended optional programme components:	None
13	Language:	Turkish
14	Mode of Delivery:	Face to face
15	Course Coordinator:	Prof. Dr. ADEM UZUN
16	Course Lecturers:
17	Contactinformation of the Course Coordinator:
18	Website:	www.uzaktanogren.ademuzun.com
19	Objective of the Course:	The purpose of this course is to provide teacher candidates ability to manage data using database management systems.
20	Contribution of the Course to Professional Development	It enables them to use the theories and applications specified in the purpose of the course in their professional practice.

21

Learning Outcomes:

1 Explains the basic concepts of data and database managements systems.; 2 Installs and manages SQL Server.; 3 Defines the data types used in SQL Server.; 4 Writes queries using SQL language; 5 Maintains the security settings in SQL Server.; 6 Works with stored procedures and triggers.;

22	Course Content:

Week	Theoretical	Practical
1	The basic concepts of database and database managements systems
2	Installing SQL Server
3	The basic database operations in SQL Server
4	Data types in SQL Server
5	Data types in SQL Server
6	Structured Query Language (SQL)
7	Querying data with SQL
8	Querying data in more than one table with SQL
9	Adding and removing data with SQL
10	Updating data using SQL
11	Table operations in SQL
12	Securiy in SQL Server
13	Stored procedures ing SQL Server
14	Triggers in SQL Server

23	Textbooks, References and/or Other Materials:	Introducing Microsoft SQL Server 2008 R2, 2010, Microsoft Press Adım Adım Microsoft SQL Server 2000 Programlama, 2001, Arkadaş Yayınevi Beginning SQL Server 2005 Express, 2006, Rick Dobson, Apress
24	Assesment

TERM LEARNING ACTIVITIES	NUMBER	PERCENT
Midterm Exam	1	40
Quiz	0	0
Homeworks, Performances	0	0
Final Exam	1	60
Total	2	100
Contribution of Term (Year) Learning Activities to Success Grade		40
Contribution of Final Exam to Success Grade		60
Total		100
Measurement and Evaluation Techniques Used in the Course	Process evaluation will be applied during the period. Test method will be applied in midterm and final exam.
Information

25

ECTS / WORK LOAD TABLE

Activites	NUMBER	TIME [Hour]	Total WorkLoad [Hour]
Theoretical	14	3	42
Practicals/Labs	0	0	0
Self Study and Preparation	14	2	28
Homeworks, Performances	0	0	0
Projects	0	0	0
Field Studies	0	0	0
Midtermexams	1	10	10
Others	0	0	0
Final Exams	1	10	10
Total WorkLoad			100
Total workload/ 30 hr			3
ECTS Credit of the Course			3

26	CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS
PQ1 PQ2 PQ3 PQ4 PQ5 PQ6 PQ7 PQ8 PQ9 PQ10 PQ11 PQ12 PQ13 PQ14 PQ15 PQ16 LO1 5 4 4 4 0 0 0 0 0 0 0 0 0 0 0 0 LO2 5 5 4 4 0 0 0 0 0 0 0 0 0 0 0 0 LO3 5 4 4 4 0 0 0 0 0 0 0 0 0 0 0 0 LO4 5 5 5 5 0 0 0 0 0 0 0 0 0 0 0 0 LO5 4 5 5 4 0 0 0 0 0 0 0 0 0 0 0 0 LO6 4 5 5 5 0 0 0 0 0 0 0 0 0 0 0 0

LO: Learning Objectives

PQ: Program Qualifications

Contribution Level:

1 Very Low

2 Low

3 Medium

4 High

5 Very High