Course Information

Semester	Course Unit Code	Course Unit Title	T+P+L	Credit	Number of ECTS Credits
-1	BLP209	Database Management Systems	2+2+0	3	5

Course Details

Language of Instruction	Turkish
Level of Course Unit	Associate Degree
Department / Program	Computer Programming
Mode of Delivery	Face to Face
Type of Course Unit	Elective
Objectives of the Course	Having the ability to create database, data processing and query using Database Management System Application program (MYSQL and Oracle) visual interface and T-SQL by giving database design logic.
Course Content	Running queries on MySQL database with T-SQL language. Performing DDL DML operations. Designing and creating a database. Performing performance tests and making improvements on the created database.
Course Methods and Techniques
Prerequisites and co-requisities	None
Course Coordinator	None
Name of Lecturers	Instructor Kerem Çınar kerem.cinar@gedik.edu.tr
Assistants	None
Work Placement(s)	No

Recommended or Required Reading

Course Category

Mathematics and Basic Sciences	%10
Engineering	%20
Engineering Design	%30
Field	%40

Planned Learning Activities and Teaching Methods

Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"

Assessment Methods and Criteria

ECTS Allocated Based on Student Workload

Activities	Quantity	Duration	Total Work Load
Course Duration	14	4	56
Hours for off-the-c.r.stud	14	4	56
Mid-terms	1	1	1
Practice	1	1	1
Laboratory	14	2	28
Project	2	2	4
Final examination	1	1	1
Total Work Load			Number of ECTS Credits 5 147

Course Learning Outcomes: Upon the successful completion of this course, students will be able to:

No	Learning Outcomes
1	Knows basic database concepts, database advantages, database creation rules.
2	Install and learn to use a network database software.
3	It can perform basic and intermediate level queries with structured query language (SQL).
4	Knows the basic features of relational database, key and relation types.
5	It ensures the security and maintenance of the network database and its portability to different platforms.

Weekly Detailed Course Contents

Week	Topics	Study Materials	Materials
1	Database Management and Fundamentals - Basic Concepts - Primary Key - Foreign Key - Index Key
2	Relationship Models - Entity-Relationship Model - Relational Data Model
3	Normalization Rules and Database Design
4	Network Database Software (SQL SERVER, MySQL, ORACLE) - Related Database introduction - Installation - Management with graphical interface (Sql Server Management Studio, Oracle Developer)
5	Database Design with graphical interface - Table design - Field creation and Data Type definition - Primary Key, Foreign Key and Index Key creation
6	Structured Query Language (SQL – 1) - “Select” queries - Condition statements with “Where” (“Between” and “In” Statements) - Sorting with “Order By” (“Top N” Structure)
7	Structured Query Language (SQL – 2) - SQL functions (Count, Max, Min, Avg, Sum) - Grouping with “Group By” and “Having”
8	Structured Query Language (SQL – 3) - Nested “Select” structures
9	Structured Query Language (SQL – 4) - Insert (INSERT), Delete (DELETE) and Update (UPDATE) queries (MILF)
10	Structured Query Language (Advanced SQL) - Table association commands - INNER JOIN - LEFT JOIN - RIGHT JOIN - CROSS JOIN Queries
12	SQL Programming – 2 (T-SQL and PL-SQL) - Data integrity and constraints - Stored Procedure
13	SQL Programming – 2 (T-SQL and PL-SQL) - Data integrity and constraints (Triggers - Triggers)
14	Mongodb database setup and query execution.

Contribution of Learning Outcomes to Programme Outcomes

bbb

https://obs.gedik.edu.tr/oibs/bologna/progCourseDetails.aspx?curCourse=113569&curProgID=44&lang=en