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)
Ins. Erkan GÜLER
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
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory140114
Lecture - Practice140114
Assignment142142
Project45540
Reading1033
Midterm Examination1516
Final Examination1516
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
5
5
4
3
3
4
3
4
4
2
2
OÇ-2
5
5
4
3
3
4
3
4
4
2
2
OÇ-3
5
5
4
3
3
4
3
4
4
2
2
OÇ-4
5
5
4
3
3
4
3
4
4
2
2
OÇ-5
5
5
4
3
3
4
3
4
4
2
2
Adnan Menderes University - Information Package / Course Catalogue
2026