COMPUTER PROGRAMMING (TURKISH)
Associate	TR-NQF-HE: Level 5	QF-EHEA: Short Cycle	EQF-LLL: Level 5

Course Introduction and Application Information

Course Code	Course Name	Semester	Theoretical	Practical	Credit	ECTS
BPR1012	Database II	Spring	1	2	2	5

Basic information

Language of instruction:	Turkish
Type of course:	Must Course
Course Level:	Associate (Short Cycle)
Mode of Delivery:	Face to face
Course Coordinator :	Dr. Öğr. Üyesi ÖZGÜR ERKUT ŞAHİN
Course Lecturer(s):	Dr. Öğr. Üyesi ÖZGÜR ERKUT ŞAHİN Instructor BARIŞ ERDOĞAN Instructor DOĞAN AYDIN
Recommended Optional Program Components:	There is no recommended Optional Program Components
Course Objectives:	In this course students will gain the ability of the theory and practice of database management systems, and database application development.

Learning Outcomes

The students who have succeeded in this course;
1)Running SQL Parsing with transaction systems from database.
2)Implement transaction management systems.
3)Recovery from database and Create user and role
4)Backup and restore from database.
5)Database performans tuning.
6)Database extands and recovery.

Course Content

In this course students will gain the ability of using SQL Server 2005/2008. Additionally monitorin server performance and mnaging sql server, advance table techniques and using T-SQL commands.

Weekly Detailed Course Contents

Week	Subject	Related Preparation
1)	Review of Database I
1)	Update, Delete, Insert commnad with T-SQL
2)	Access to Server and Operations
3)	Functions
4)	Grant permissions and rights to users
5)	Programming with T-SQL
6)	Variables and System functions
7)	T-SQL commands
8)	IF Structures
9)	CASE Statement
10)	WHILE Loop
11)	Data management with CURSOR
12)	Procedures
13)	Dynamic SQL
14)	Review

Sources

Course Notes / Textbooks:	Yaşar Gözüdeli. Yazılımcılar için SQL Server 2005 ve Veri Tabanı Programlama. Seçkin yayınları, 3. Baskı.2008
References:	NA

Evaluation System

Semester Requirements	Number of Activities	Level of Contribution
Attendance	14	% 5
Quizzes	1	% 20
Midterms	1	% 25
Final	1	% 50
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 50
PERCENTAGE OF FINAL WORK		% 50
Total		% 100

ECTS / Workload Table

Activities	Number of Activities	Duration (Hours)	Workload
Course Hours	14	4	56
Laboratory	14	2	28
Study Hours Out of Class	14	3	42
Quizzes	1	1	1
Midterms	1	1	1
Final	1	1	1
Total Workload			129

Contribution of Learning Outcomes to Programme Outcomes

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Program Outcomes	Level of Contribution
1)	Students will have knowledge of fundemantals of mathemetaics and phsics	4
2)	Students will have konowledge of relevant software and hardware requirements in the office environment	2
3)	Having the ability to define and explain the fundemental concepts, principles and essentilas of software and having the ability to develop software.	5
4)	Having the ability to use tools, machines and having the ability to recognize and diagnose problems in the related computer fields.	1
5)	Having the ability to communicate efficiently in verbal and written Turkish, to know at least one foreign language in order to communicate with the colleagues and customers.	4
6)	Having the ability to setup,diagnose and maintanance of databases	5
7)	Having the ability to design graphical animations for desktop applications and internet programming.	4
8)	Having the ability to develop and control internet projects	4
9)	Having the ability to develop group projects, team work, software and hardware projects	4
10)	Having the ability to set up,diagnose operating systems and network systems	1