Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS Credits
-1BLP209Database Management Systems2+2+035

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 Face to face
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
Resources www.mysqltutorial.org
"Database System Concepts" – Abraham Silberschatz, Henry F. Korth, S. Sudarshan
"SQL for Data Science" – Cathy Tanimura
"Fundamentals of Database Systems" – Ramez Elmasri, Shamkant B. Navathe
"NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence" – Pramod J. Sadalage, Martin Fowler
mysqltutorial.org
mysqltutorial.org
Vize Uygulama Final

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
In-Term Studies Quantity Percentage
Mid-terms 1 % 30
Practice 1 % 20
Final examination 1 % 50
Total
3
% 100

 
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 2 28
Mid-terms 1 15 15
Practice 1 10 10
Final examination 1 20 20
Total Work Load   Number of ECTS Credits 5 129

Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Students will be able to explain the basic concepts of database management systems (DBMS), data models (relational, hierarchical, network) and database design processes.
2 Students will be able to design a consistent and efficient database by using normalization principles (1NF, 2NF, 3NF, BCNF) during database design.
3 Students will be able to perform basic and advanced data query, data insertion, deletion, and update operations using the SQL language, and manage relationships between tables using JOIN structures.
4 Students will be able to install database management systems such as SQL Server, MySQL, Oracle, and perform user management, data backup and restore operations in these systems.
5 Students will be able to make database systems more secure and efficient by applying database security and performance improvement techniques (indexing, query optimization).
6 Students will be able to compare SQL and NoSQL databases, learn about NoSQL data models (Key-Value, Document, Column-family, Graph) and explain in which cases these systems are preferred.


Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
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
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 Introduction to NoSQL databases: Key-Value, Document, Column-family, Graph databases NoSQL and SQL comparison Future trends and new technologies


Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10
All 4 5 4 3 2 4 3 1 1
C1 4 5 3 2 2 3 2 1 1 1
C2 3 5 4 3 2 3 3 1 1 2
C3 3 5 5 3 2 4 3 1 1 2
C4 3 5 5 4 2 5 3 1 1 3
C5 3 5 4 4 2 4 3 1 1 4
C6 4 4 4 3 2 3 4 1 1 2

bbb


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