Information Systems (Master) (Without Thesis) (English)
Master	TR-NQF-HE: Level 7	QF-EHEA: Second Cycle	EQF-LLL: Level 7

General course introduction information

Course Code:

EBIS516

Course Name:

Advanced Database Applications

Course Semester:

Fall
Spring

Course Credits:

Theoretical	Practical	Credit	ECTS
3	0	3	10

Language of instruction:

Course Requisites:

Does the Course Require Work Experience?:

Type of course:

Department Elective

Course Level:

Master

TR-NQF-HE:7. Master`s Degree

QF-EHEA:Second Cycle

EQF-LLL:7. Master`s Degree

Mode of Delivery:

Face to face

Course Coordinator :

Dr.Öğr.Üyesi FERİDUN CEMAL ÖZÇAKIR

Course Lecturer(s):

Course Assistants:

Course Objective and Content

Course Objectives:	Creating relational database modeling, learning database advanced query techniques and procedural database programming.
Course Content:	Designing relational databases, configuring the security mechanism of database servers, stored procedures, functions, triggers, procedural programming, using comparison and control statements on database, using loop statements, efficient database procedural programming with cursor structures.

Learning Outcomes

The students who have succeeded in this course;

Learning Outcomes

1 - Knowledge
Theoretical - Conceptual
1) To learn advanced query techniques.
2 - Skills
Cognitive - Practical
1) Creating relational database modeling.
3 - Competences
Communication and Social Competence
Learning Competence
Field Specific Competence
1) To develop procedural procedural programming.
Competence to Work Independently and Take Responsibility

Lesson Plan

Week	Subject	Related Preparation
1)	Overview of Database and SQL Server Structure
2)	SQL Server and SQL Server Security Mechanism, Relational Database Model
3)	Data Definition Language Commands (DDL) (CREATE, DROP, ALTER ..) and Data Manipulation Language Commands (DML) (SELECT, INSERT, DELETE, UPDATE)
4)	Joins (INNER, LEFT OUTER, RIGHT OUTER), Relations - Restrictions (CONSTRAINTS)
5)	Triggers (INSERT, DELETE, UPDATE)
6)	Data Control Language statements (Expression and Object permissions, GRANT, DENY and REVOKE)
7)	Variables, Comparison and Control Statements (IF / ELSE, BEGIN / END, WHILE, GOTO and CASE commands)
8)	Midterm Exam
9)	Stored Procedures - Input and Output Parameters
10)	User Defined Functions (Table-valued, Scalar-valued)
11)	Advanced Query Design (Subqueries - add, delete and update data with queries)
12)	Cursors (Navigational, Static, Dynamic, Keyed, Salt-Forward cursors)
13)	Transactions and Locks
14)	Creating Scheduled Tasks
15)	Final Exam

Sources

Course Notes / Textbooks:	Microsoft SQL Docs - Programming
References:	- Inside Microsoft SQL Server 2008: T-SQL Programming (Itzik Ben-Gan, Dejan Sarka, Ed Katibah, Greg Low, Roger Wolter, Isaac Kunen) - Microsoft Press - Programming Microsoft SQL Server 2012 (Leonard Lobel, Andrew Brust) - Microsoft Press

Course-Program Learning Outcome Relationship

Learning Outcomes	1	2	3
Program Outcomes

Course - Learning Outcome Relationship

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

Program Outcomes

Level of Contribution

Learning Activity and Teaching Methods

Individual study and homework
Lesson
Group study and homework
Homework
Problem Solving

Assessment & Grading Methods and Criteria

Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing)
Homework
Application
Individual Project
Group project
Case study presentation

Assessment & Grading

Semester Requirements	Number of Activities	Level of Contribution
Attendance	42	% 5
Quizzes	2	% 10
Presentation	1	% 10
Midterms	1	% 25
Final	1	% 50
total		% 100
PERCENTAGE OF SEMESTER WORK		% 50
PERCENTAGE OF FINAL WORK		% 50
total		% 100

Workload and ECTS Credit Grading

Activities	Number of Activities	Duration (Hours)	Workload
Course Hours	14	3	42
Laboratory	12	2	24
Application	14	3	42
Study Hours Out of Class	5	2	10
Presentations / Seminar	2	5	10
Homework Assignments	5	2	10
Quizzes	6	1	6
Midterms	1	3	3
Final	1	3	3
Total Workload			150