PAÜ .:. Eğitim Öğretim Bilgi Sistemi

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
CENG 315	DATABASE MANAGEMENT AND MODELING LABORATUARY	0 + 2	5th Semester	2,5

COURSE DESCRIPTION

Course Level	Bachelor's Degree
Course Type	Compulsory
Course Objective	Aim of this course is to make applications of already learned database concepts in an up-to-date database management system.
Course Content	Queries, join queries, sorting in queries, grouping, views, stored procedures, functions and triggers.
Prerequisites	No the prerequisite of lesson.
Corequisite	CENG 313 DATABASE MANAGEMENT AND MODELING
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

1	Writes SQL queries
2	Writes join and complex queries
3	Does sorting and grouping in queries
4	Writes functions and stored procedures
5	Writes triggers

COURSE'S CONTRIBUTION TO PROGRAM

	PO 01	PO 02	PO 03	PO 04	PO 05	PO 06	PO 07	PO 08	PO 09	PO 10	PO 11	PO 12
LO 001	5	1	2	2	2	5	3		2		2
LO 002	5	1	2	2	2	5	3		2		2
LO 003	5	1	2	2	2	5	3		2		2
LO 004	5	1	2	2	2	5	3		2		2
LO 005	5	1	2	2	2	5	3		2		2
Sub Total	25	5	10	10	10	25	15		10		10
Contribution	5	1	2	2	2	5	3	0	2	0	2	0

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION

Activities	Quantity	Duration (Hour)	Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)	14	2	28
Hours for off-the-classroom study (Pre-study, practice)	14	2	28
Mid-terms	1	4	4
Final examination	1	5	5
Total Work Load ECTS Credit of the Course			65 2,5

COURSE DETAILS

Select Year

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester
CENG 315	DATABASE MANAGEMENT AND MODELING LABORATUARY	0 + 2	1	Turkish	2023-2024 Fall

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Asts. Prof. Dr. FATMANA ŞENTÜRK	fatmanas@pau.edu.tr		MUH A0435	%70

Goals		Aim of this course is to make applications of already learned database concepts in an up-to-date database management system.
Content		Queries, join queries, sorting in queries, grouping, views, stored procedures, functions and triggers.

Topics

Weeks	Topics
1	Introduction to Database Concepts
2	Database Types, Relational Database Design
3	ER Diagrams and Normalization
4	SQL Server Interface, Database Objects
5	T-SQL and SQL Queries
6	Index and Views
7	Stored Procedure and Functions
8	Triggers
9	Transactions and Backup
10	User Types and User Management
11	No-SQL Databases
12	No-SQL Databases
13	Project Presentation
14	Project Presentation

Materials

Materials are not specified.

Resources

Course Assessment

L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes

Prospective Student