Course Information

Semester	Course Unit Code	Course Unit Title	T+P+L	Credit	Number of ECTS Credits
4	YBS204	Database Management Systems	3+2+0	4	6

Course Details

Language of Instruction	Turkish
Level of Course Unit	Bachelor's Degree
Department / Program	Management Information Systems
Mode of Delivery	Face to Face
Type of Course Unit	Compulsory
Objectives of the Course	The aim of this course is to teach students the basic concepts and technologies related to databases and to provide them with the knowledge and skills to design, implement and manage database systems.
Course Content	The database management systems course will teach students the fundamentals of databases and provide an in-depth understanding of the relational data model, SQL queries, database design and management. This course teaches students how database systems work, how databases are created, updated and queried, while also addressing important issues such as data integrity, security and performance optimization. Students will develop their database management skills by practicing with examples based on real-world scenarios. In addition, this course will partly follow Project Based Learning (PBL). Each student will do a project on a different topic. Students will be assigned projects from a project list. Projects will be done alone.
Course Methods and Techniques	Lectures, Question-Answer, Project.
Prerequisites and co-requisities	None
Course Coordinator	Asist Prof. Vassilya UZUN
Name of Lecturers	Asist Prof. HALİME SUVAY EKER
Assistants	None
Work Placement(s)	No

Recommended or Required Reading

Resources	Post, G. V. (2009). Database management systems. PHI Learning Pvt. Limited. Codd, E. F. (1990). The relational model for database management: version 2. Addison-Wesley Longman Publishing Co., Inc..
	Özseven, T. (2012). Veri tabanı yönetim sistemleri-2. Murathan Yayınevi.

	Bir grup projesi
	Vize ve Final Sınavları

Course Category

Mathematics and Basic Sciences	%0
Engineering	%10
Engineering Design	%10
Social Sciences	%0
Education	%0
Science	%0
Health	%0
Field	%80

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	3	42
Hours for off-the-c.r.stud	14	3	42
Mid-terms	1	20	20
Project	1	20	20
Final examination	1	30	30
Total Work Load			Number of ECTS Credits 6 154

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

No	Learning Outcomes
1	Students will be able to explain the concepts of data, information, knowledge and database.
2	They can apply DML operations in database management.
3	They can perform DDL operations in database management.
4	Students will be able to perform Order By and Group By operations in SQL query language.
5	They can set up and manage relational and non-relational database models.
6	They can write subqueries in the SQL query language.
7	Students can use Views in SQL.

Weekly Detailed Course Contents

Week	Topics	Study Materials	Materials
1	Syllabus discussion, concepts of data, information and knowledge
2	Creating, deleting and updating databases (create, alter, drop operations) Identification of Projects
3	Creating, deleting and updating databases (Create, Alter, Drop operations)
4	Basic SQL queries (Select, Where)
5	Basic SQL queries (Insert, Update, Del
6	Data Grouping Operations (Group By: Avg, Sum)
7	Subject Review Review of Projects
8	Data Grouping Operations (Group By: Count, Min, Max)
9	Data Sorting Operations (Order By: Asc, Desc)
10	Linking Tables (JOIN Rules: Inner, Left Outer, Right Outer, Full Outer)
11	Linking Tables (JOIN Rules: Inner, Left Outer, Right Outer, Full Outer)
12	Subqueries
13	Views
14	Project Delivery

Contribution of Learning Outcomes to Programme Outcomes

bbb

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