- Course Code
- SBST209
- Semester
- Third Term (Fall)
- Theory+Practice
- 2 + 1
- ECTS
- 5
| Course Type | Compulsory Course |
|---|
| Course Level | Associate Degree |
|---|
| Year of Study | 2 |
|---|
| Semester | Third Term (Fall) |
|---|
| ECTS | 5 |
|---|
| Name of Lecturer(s) |
|
| Learning Outcomes |
At the end of this course, the students;
- This section explains the fundamental differences between NoSQL database systems and evaluates their architecture.
- It performs data insertion, reading, updating, and deletion operations.
- Indexing improves query performance by using operators and clustering.
- Cloud databases evaluate and implement data security and backup strategies.
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | SBST 106 DATABASE I |
|---|
| Course Description | Within the scope of this course; Oracle Database Architecture, Working with SQL Commands in Oracle, Using Functions, Database Management Topics, Background Operations, Using Oracle Objects, Backing Up and Performance Issues. |
|---|
| Course Contents |
| WEEK |
TOPICS |
|
1st Week |
Introduction to Oracle |
|
2nd Week |
Oracle Database Architecture |
|
3rd Week |
Oracle Database Setup and Developer Usage |
|
4th Week |
Creating an Oracle Database |
|
5th Week |
Working with SQL Commands in the Oracle Database |
|
6th Week |
Working with SQL Commands in the Oracle Database |
|
7th Week |
Use of Functions in Oracle Database |
|
8th Week |
MIDTERM WEEK |
|
9th Week |
Oracle Database Management |
|
10th Week |
Oracle Background Operations |
|
11th Week |
Oracle Instance Management |
|
12th Week |
Managing Tablespace Objects and Datafile Files in the Oracle Database |
|
13th Week |
Oracle Database Backup |
|
14th Week |
Database Performance - Globalization |
|
15th Week |
|
|
| Recommended or Required Reading | ORACLE 11g R2, Teoman DİNÇEL, KODLAB |
|---|
| Planned Learning Activities and Teaching Methods |
- Lecture
- Practice
- Discussion
- Questions/Answers
- Problem Solving
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
25 |
| Quiz |
2 |
20 |
| Practice |
2 |
20 |
| Total(%) |
|
65 |
| Contribution of In-term Studies to Overall Grade(%) |
|
65 |
| Contribution of Final Examination to Overall Grade(%) |
|
35 |
| Total(%) |
|
100 |
|
| ECTS Allocated Based on Student Workload |
| Activities |
Quantity |
Duration (Hour) |
Total Workload (Hour) |
| Midterm exam |
1 |
1 |
1 |
| Preparation for Quiz |
2 |
10 |
20 |
| Individual or group work |
4 |
12 |
48 |
| Preparation for Final exam |
1 |
20 |
20 |
| Course hours |
14 |
2 |
28 |
| Preparation for Midterm exam |
1 |
10 |
10 |
| Laboratory (including preparation) |
14 |
1 |
14 |
| Final exam |
1 |
1 |
1 |
| Homework |
0 |
0 |
0 |
| Quiz |
2 |
1 |
2 |
| Performance Practice |
2 |
1 |
2 |
| Total Work Load | 146 |
| Total Work Load / 30 (h) | 4.86 |
| ECTS Credit of the Course | 5 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
Programme Qualifications / Learning Outcomes
|
LO1 |
LO2 |
LO3 |
LO4 |
| K1 |
X |
|
X |
X |
| K2 |
|
|
|
|
| K3 |
X |
X |
X |
X |
| K4 |
|
|
X |
X |
| K5 |
X |
X |
|
|
| K6 |
|
|
|
|
| K7 |
|
X |
|
|
| K8 |
|
|
|
|
| K9 |
|
|
X |
|
| K10 |
|
|
|
|
| K11 |
|
|
|
|
| K12 |
|
|
|
|
| K13 |
|
X |
X |
X |
| K14 |
|
|
|
|
| K15 |
|
|
|
|
| K16 |
|
|
|
|
| K17 |
|
|
|
|
| K18 |
|
|
|
|
