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

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
IBGL 207	DATABASE II	3 + 1	2nd Semester	5

COURSE DESCRIPTION

Course Level	Associate's Degree
Course Type	Compulsory
Course Objective	With this course students be able to manage databases and database servers.
Course Content	Installation of database management panel, Databse creation and user definitios, Tables, Diagram management, Data transfer operations, Views, Triggers, Stored Procedures, Indexes, User Roles, User defined data types, Rules, Backup plan, Performance analysis and improvement
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

1	Installs a database
2	Makes basic table operations
3	Makes advanced table operations
4	Manages database server

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	PO 13	PO 14
LO 001	5	4	5	5	5	4		5
LO 002	5	5	4	4	4	4		4
LO 003	5	4	4	5	5	4		5
LO 004	5	4	4	5	5	4		5
Sub Total	20	17	17	19	19	16		19
Contribution	5	4	4	5	5	4	0	5	0	0	0	0	0	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	4	56
Hours for off-the-classroom study (Pre-study, practice)	14	4	56
Mid-terms	1	8	8
Final examination	1	10	10
Total Work Load ECTS Credit of the Course			130 5

COURSE DETAILS

Select Year

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester
IBGL 207	DATABASE II	3 + 1	1	Turkish	2023-2024 Spring

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Lecturer İHSAN ÖZER	ihsano@pau.edu.tr		DTMYO C0002-03	%

Goals		With this course students be able to manage databases and database servers.
Content		Installation of database management panel, Databse creation and user definitios, Tables, Diagram management, Data transfer operations, Views, Triggers, Stored Procedures, Indexes, User Roles, User defined data types, Rules, Backup plan, Performance analysis and improvement

Topics

Weeks	Topics
1	Remembering of SQL
2	Samples about SELECT, UPDATE, DELETE, INSERT INTO
3	Normalization
4	JOIN processes
5	Embedded SQL
6	Using of SQL on SQL Server
7	Eveluation and Presenting Homework 1
8	Advanced using SQL
9	Stored Procedures
10	SQL Functions
11	Triggers and Jobs
12	Programming with SQL
13	Set, Get , Declare
14	Reporting with SQL

Materials

Materials are not specified.

Resources

Course Assessment

Assesment Methods	Percentage (%)	Assesment Methods Title
Final Exam	50	Final Exam
Midterm Exam	50	Midterm Exam

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

Prospective Student