Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS Credits
5BİL311Database Management Systems3+0+036

Course Details
Language of Instruction Turkish
Level of Course Unit Bachelor's Degree
Department / Program Computer Engineering
Mode of Delivery Face to Face
Type of Course Unit Compulsory
Objectives of the Course With this course, students will be taught the concepts of database, table and record, and will be given the skills to set up and manage a database server and use the most prominent Transact-SQL commands.
Course Content Structure of Microsoft SQL database server; relational database concepts; data storage models; database components; client-server architecture; database products and versions; preparation before installation; instance name; service account setting; etc.; SQL Server Management Studio; Standard SQL server databases; creating and deleting databases; DDL commands; Recovery-Transact Log; compatibility; database table operations; data types; data entry and data deletion; database backup and restore; queries; SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER commands and WHERE, ORDER BY, GROUP BY, HAVING, JOIN structures; data transfer operations; table join structures; constraints (UNIQUE, CHECK, PK, FK); index concept; saved procedures; triggers; SQL Server Agent.
Course Methods and Techniques Lectures, Questions and Answers, Application, Scenario Database Structure Creation Projects.
Prerequisites and co-requisities None
Course Coordinator None
Name of Lecturers Asist Prof. Feridun Cemal Özçakır
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Fundamentals of Database Systems, Elmasri&Navathe, Pearson; 7 edition (2015), ISBN-10: 0133970779, ISBN-13: 978-0133970777 Database SystemConcepts, A.Silberschatz, H.Korth, 2013, ISBN-10: 9332901384, ISBN-13: 9789332901384, McGrawHill
Lectures, Question-Answer, Project.
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
In-Term Studies Quantity Percentage
Mid-terms 1 % 25
Quizzes 5 % 5
Assignment 5 % 5
Attendance 1 % 5
Project 1 % 10
Final examination 1 % 60
Total
14
% 110

 
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
Assignments 14 3 42
Mid-terms 1 3 3
Practice 7 2 14
Laboratory 14 2 28
Final examination 1 3 3
Total Work Load   Number of ECTS Credits 6 174

Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 (Theoretical - Factual) Learning data and database concepts. Understanding the relational database model.
2 (Cognitive - Applied) Gaining database server installation and management skills.
3 (Competencies) Ability to Work Independently and Take Responsibility
4 (Field-Specific Competency) Using structured query language (SQL) competently and effectively.


Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Data and Database concepts, Database Management Systems (Traditional Databases), Data Warehouses, Data Models, OLTP and OLAP, Relational Model
2 Microsoft SQL Server (client-server architecture), SQL server database installation (pre-installation preparations, instance naming -Instance Name, service account determination, etc.), SQL server management studio, SQL server database architecture, standard databases in SQL server, Management Creating a Database, Deleting a Database with Studio.
3 Tables (creating, adding columns, changing column properties, data types, deleting columns, deleting a table), table operations with SQL, Transact SQL (T-SQL): CREATE TABLE, DROP TABLE, INSERT, DELETE, SELECT (WHERE, ORDER BY) commands
4 UPDATE command, table operations with Transact SQL: ALTER commands (ALTER TABLE, ALTER COLUMN, ADD, DROP, DEFAULT)
5 Setting database options such as Collation, Recovery (Full, Bulk-logged, Simple), Compability etc., backing up the database and returning (Full, Transaction Log).
6 Table operations with Transact SQL: SELECT command (HAVING, GROUP BY), Aggregate Functions, Data transfer operations (data import and export)
7 Table Operations with Transact SQL (Linking Tables) – JOIN Rules (INNER, LEFT OUTER, RIGHT OUTER), Constraints (UNIQUE, CHECK), Index concept and index in SQL tables (Clustered Index, Non-clustered Index) , (PRIMARY KEY)
8 Midterm exam.
9 SQLCMD prompt, BCP prompt, Stored Procedure, Procedures Taking Values
10 Data and Database Administration Distributed Databases.
11 Procedures that Provide Values, Triggers: INSERT Trigger
12 Triggers: DELETE Trigger, UPDATE Trigger, INSTEAD OF Triggers
13 Database Management Systems (New Generation Databases, NoSQL, Document, Graph, Key-value, Wide-Column)
14 Big Data (Structured Data, Unstructured Data, 3V, 5V), Big Data Applications


Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11
All 1 3 3 3 3 3 3 1 3 3
C1 1 3 3 3 3 3 3 1 3 3
C2 1 3 3 3 3 3 3 1 3 3
C3 1 3 3 3 3 3 3 1 3 3
C4 1 3 3 3 3 3 3 1 3 3

bbb


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