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

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
CBPG 205	DATABASE-II	3 + 1	3rd Semester	5

COURSE DESCRIPTION

Course Level	Associate's Degree
Course Type	Compulsory
Course Objective	With this course, students, aimed to gain qualifications relevant to managing the database and servers.
Course Content	At least two different manufacturers to establish an industry standard server software Establish a panel, database management, database users to create and define the Create a database and identify users, identify the tables and diagrams to manage Diagram to identify and manage tables, making the data transfer operations Data transfer to operations, the existing database, create a new database Existing database, create a new database, view, triggers, and indexes to edit subroutines Views, triggers, and indexes to edit subroutines Views, triggers, and indexes to edit subroutines, user roles, user-defined data types to edit User roles, user-defined data types to edit Terms and edit the default values Terms and edit the default values, data replication operations and maintenance plan to make Operations and maintenance plan to make data replication Performance analysis and to make improvements Performance analysis and to make improvements
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

1	To do basic table operations
2	To do advance table operations
3	Manage the database server

COURSE'S CONTRIBUTION TO PROGRAM

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	3	42
Assignments	3	6	18
Mid-terms	1	6	6
Final examination	1	8	8
Total Work Load ECTS Credit of the Course			130 5

COURSE DETAILS

Select Year

	Course Term	No	Instructors
Details	2019-2020 Fall	1	ALİ COŞKUN

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester
CBPG 205	DATABASE-II	3 + 1	1	Turkish	2019-2020 Fall

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Lecturer ALİ COŞKUN	alicoskun@pau.edu.tr		ÇMYO A0064	%70

Goals		With this course, students, aimed to gain qualifications relevant to managing the database and servers.
Content		At least two different manufacturers to establish an industry standard server software Establish a panel, database management, database users to create and define the Create a database and identify users, identify the tables and diagrams to manage Diagram to identify and manage tables, making the data transfer operations Data transfer to operations, the existing database, create a new database Existing database, create a new database, view, triggers, and indexes to edit subroutines Views, triggers, and indexes to edit subroutines Views, triggers, and indexes to edit subroutines, user roles, user-defined data types to edit User roles, user-defined data types to edit Terms and edit the default values Terms and edit the default values, data replication operations and maintenance plan to make Operations and maintenance plan to make data replication Performance analysis and to make improvements Performance analysis and to make improvements

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	Data Type
8	Advanced using SQL
9	Stored Procedures
10	SQL Functions
11	Triggers and Jobs
12	Programming with SQL
13	Set, Get , Declare
14	Project Presentation

Materials

Materials are not specified.

Resources

Resources	Resources Language
Veri Tabanı Yönetim Sistemleri 2- Murathan Yayınevi- Turgut Özseven	Türkçe

Course Assessment

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

Prospective Student