Pamukkale University
University is the guide to life
Welcome to PAU;
Prospective Student
Our Students
Our Staff
TR
Information Package & Course Catalogue
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes
SHORT CYCLE - ASSOCIATE'S DEGREE
ÇİVRİL ATASAY KAMER VOCATIONAL SCHOOL
COMPUTER TECHNOLOGIES DEPARTMENT
760 COMPUTER PROGRAMMING (Evening Classes)
Course Information
Course Learning Outcomes
Course's Contribution To Program
ECTS Workload
Course Details
Print
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
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
PO 15
PO 16
PO 17
PO 18
PO 19
LO 001
1
5
LO 002
5
LO 003
5
Sub Total
1
15
Contribution
0
0
0
0
5
0
0
0
0
0
0
0
0
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
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
All Years
2023-2024 Fall
2022-2023 Fall
2021-2022 Fall
2020-2021 Fall
2019-2020 Fall
2018-2019 Fall
2017-2018 Fall
2016-2017 Fall
2015-2016 Fall
2014-2015 Fall
2013-2014 Fall
2012-2013 Fall
Course Term
No
Instructors
Details
2023-2024 Fall
1
ALİ COŞKUN
Print
Course Details
Course Code
Course Title
L+P Hour
Course Code
Language Of Instruction
Course Semester
CBPG 205
DATABASE-II
3 + 1
1
Turkish
2023-2024 Fall
Course Coordinator
E-Mail
Phone Number
Course Location
Attendance
Lecturer ALİ COŞKUN
alicoskun@pau.edu.tr
ÇMYO A0008 Ç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
Assesment Methods
Percentage (%)
Assesment Methods Title
Final Exam
50
Final Exam
Midterm Exam
30
Midterm Exam
Project
20
Project
L+P:
Lecture and Practice
PQ:
Program Learning Outcomes
LO:
Course Learning Outcomes
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes