Information Security Technologies (Evening Education) Preview
Associate	TR-NQF-HE: Level 5	QF-EHEA: Short Cycle	EQF-LLL: Level 5

Course Introduction and Application Information

Course Code:

BGT201

Course Name:

Database Management

Semester:

Fall

Course Credits:

ECTS

Language of instruction:

Turkish

Course Condition:

Does the Course Require Work Experience?:

Type of course:

Compulsory Courses

Course Level:

Associate

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

QF-EHEA:Short Cycle

EQF-LLL:5. Master`s Degree

Mode of Delivery:

Face to face

Course Coordinator:

Öğr. Gör. RAMAZAN ŞEN

Course Lecturer(s):

Mustafa Kutlutürk

Course Assistants:

Course Objective and Content

Course Objectives:

In this course, it is aimed to understand basic concepts of database management systems, design and create a sample database, writing SQL commands, using SQL operators and functions, develop ability to design and manage relational database systems.

Course Content:

Basic Concepts Database Systems, Entity-Relationsip (ER) Model, Normalization Rules, Relational Database Management Systems and Introduction to MS SQL Server, Creating a Sample Database on MS SQL Server, Relationships Between Tables, Introduction to SQL, SQL Commands, SQL Operators and SQL Functions on MS SQL Server, Table Joining (JOIN) Operations and Index Usage, Structure of VIEWs and Indexing, Stored Procedures and Triggers on MS SQL Server

Learning Outcomes

The students who have succeeded in this course;
1) To comprehend the basic concepts of database, structure of table, understanding data types, understanding properties and usage of primary key and foreign key in tables.
2) To be able to design relational database.
3) To be able to use and apply the normalization rules.
4) To be able to create a sample database on MS SQL Server.
5) To be able to write basic queries with SQL commands.
6) To be able to use SLQ operators and functions on MS SQL Server.
7) To be able perform JOIN operations and to use Index.
8) To be able to use of VIEW, Stored Procedure and Trigger structures on MS SQL Server

Course Flow Plan

Week	Subject	Related Preparation
1)	Introduction to Database and Basic Concepts
2)	Introduction to Relational Database Model and Database Design Phases
3)	Normalization Rules and Sample Database Design
4)	Architecture of MS SQL Server and Create Sample Database (Tables and Keys)
5)	Joining Tables on MS SQL Server and Introduction to SQL
6)	Writing Queries with SQL and DDL SQL Commands (CREATE, ALTER, DROP)
7)	Data Defination SQL Commands (CREATE, ALTER, DROP)
7)	Writing Queries with SQL and DDL SQL Commands (CREATE, ALTER, DROP) (Continued..)
8)	Midterm Exam
9)	DML SQL Commands (INSERT, UPDATE, DELETE vs. TRUNCATE)
10)	DQL SQL Command (SELECT)
11)	Structure of SELECT and SQL Operators
12)	SQL Functions (Aggregate, Strin-Character, Date etc.) and Grouping (GROUP BY)
13)	Table Join Operation (JOIN) and Indexing
14)	VIEW, Stored Procedure (SP) and Triggers
15)	Final Exam
16)	Final Exam

Sources

Course Notes / Textbooks:	Veritabanı Mantığı, Kerem Köseoğlu, Pusula Yayıncılık / Programlama Kitapları Dizisi
References:	Veritabanı Mantığı, Kerem Köseoğlu, Pusula Yayıncılık / Programlama Kitapları Dizisi

Course - Program Learning Outcome Relationship

Course Learning Outcomes	1	2	3	4	5	6	7	8
Program Outcomes

Course - Learning Outcome Relationship

No Effect	1 Lowest	2 Average	3 Highest

Program Outcomes

Level of Contribution

Assessment & Grading

Semester Requirements	Number of Activities	Level of Contribution
Attendance	1	% 10
Homework Assignments	2	% 10
Midterms	1	% 30
Final	1	% 50
total		% 100
PERCENTAGE OF SEMESTER WORK		% 50
PERCENTAGE OF FINAL WORK		% 50
total		% 100

Workload and ECTS Credit Calculation

Activities	Number of Activities	Workload
Course Hours	14	42
Laboratory	14	28
Homework Assignments	2	20
Midterms	1	10
Final	1	16
Total Workload		116