Information Package / Course Catalogue
Database III
Course Code: BPR202
Course Type: Required
Couse Group: Short Cycle (Associate's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 1
Prt.: 1
Credit: 2
Lab: 0
ECTS: 5
Objectives of the Course

This course aims to provide the student with the competencies to manage the Oracle database.

Course Content

Oracle Database Installation and Configuration, Data Modeling and Definition (DDL), Data Manipulation Language (DML), Data Control Language (DCL).

Name of Lecturer(s)
Learning Outcomes
1.Knows the working logic of Oracle database.
2.Knows the concept of relational database and general RDBMS structure.
3.Analyzes the effects of database systems on system performance.
4.Designs the desired data system using the Oracle Database management system
5.Analyzes a system developed on Oracle database.
Recommended or Required Reading
1.Oracle Database 19c for Beginners: Introduction to Database Administration by Talip Hakan Öztürk
Weekly Detailed Course Contents
Week 1 - Theoretical
Oracle Database Installation and Configuration
Week 2 - Theoretical
Data Modeling and Definition (DDL)
Week 3 - Theoretical
Data Modeling and Definition (DDL)
Week 4 - Theoretical
Data Modeling and Definition (DDL)
Week 5 - Theoretical
Data Manipulation Language (DML)
Week 6 - Theoretical
Data Manipulation Language (DML)
Week 7 - Theoretical
Data Manipulation Language (DML)
Week 8 - Theoretical
Data Manipulation Language (DML) (Midterm Exam)
Week 9 - Theoretical
Data Manipulation Language (DML)
Week 10 - Theoretical
Data Control Language (DCL)
Week 11 - Theoretical
Data Control Language (DCL)
Week 12 - Theoretical
Data Control Language (DCL)
Week 13 - Theoretical
Data Control Language (DCL)
Week 14 - Theoretical
Data Control Language (DCL)
Assessment Methods and Criteria
Type of AssessmentCountPercent
Assignment1%10
Quiz1%10
Midterm Examination1%20
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory140114
Lecture - Practice140114
Assignment120121
Quiz130131
Midterm Examination120121
Final Examination123124
TOTAL WORKLOAD (hours)125
Contribution of Learning Outcomes to Programme Outcomes
PÇ-1
PÇ-2
PÇ-3
PÇ-4
PÇ-5
PÇ-6
PÇ-7
PÇ-8
PÇ-9
PÇ-10
PÇ-11
OÇ-1
2
5
4
2
4
3
3
4
4
4
5
OÇ-2
2
5
4
2
4
3
3
4
4
4
4
OÇ-3
2
5
4
2
4
3
3
4
4
4
5
OÇ-4
2
5
4
2
4
3
3
4
4
4
4
OÇ-5
2
5
4
2
4
3
3
4
4
4
4
Adnan Menderes University - Information Package / Course Catalogue
2026