Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | YÖN312B.3 | Oracle Database SQL | Elective | 3 | 6 | 4 |
|
Level of Course Unit |
First Cycle |
Objectives of the Course |
By using ORACLE DBMS toolkit, database design and application modeling provide a broad base for data definition, data learning. To teach basic database concepts and methods for designing and developing database systems. |
Name of Lecturer(s) |
- |
Learning Outcomes |
1 | Develop an analytical approach to a real-world situation. | 2 | Develop problem solving skills | 3 | To build a data model, logical database design, database application and processing | 4 | Preparing queries using SQL language |
|
Mode of Delivery |
Normal Education |
Prerequisites and co-requisities |
None |
Recommended Optional Programme Components |
None |
Course Contents |
- |
Weekly Detailed Course Contents |
|
1 | Database Systems Concepts | | | 2 | Relational Database Modeling VI Modeling | | | 3 | Relational Database Model | | | 4 | Case Studies | | | 5 | Databases and Oracle database features | | | 6 | Oracle database and interface usage | | | 7 | Creating tables in Oracle and registration operations | | | 8 | Course return (Midterm exam) | | | 9 | Functions in Oracle | | | 10 | Sorting, recalling, updating and deleting operations in Oracle | | | 11 | Oracle table design examples and query techniques | | | 12 | Oracle APEX | | | 13 | SQL Concept | | | 14 | SQL: Creating Tables and Defining Constraints | | | 15 | An overview (FINAL EXAM) | | |
|
Recommended or Required Reading |
* “Fundamentals of Database Systems”, Elmasri & Navathe, 5th Edition, Pearson Addison Wesley
* Veri Tabanına Yöntemine Giriş oracle Database, Talip Hakan Öztürk, Abaküs Kitap
|
Planned Learning Activities and Teaching Methods |
|
Assessment Methods and Criteria | |
Midterm Examination | 1 | 80 | Homework | 1 | 20 | SUM | 100 | |
Final Examination | 1 | 100 | SUM | 100 | Term (or Year) Learning Activities | 40 | End Of Term (or Year) Learning Activities | 60 | SUM | 100 |
| Language of Instruction | Turkish | Work Placement(s) | None |
|
Workload Calculation |
|
Midterm Examination | 1 | 1 | 1 |
Final Examination | 1 | 2 | 2 |
Attending Lectures | 14 | 3 | 42 |
Question-Answer | 14 | 3 | 42 |
Self Study | 10 | 3 | 30 |
Individual Study for Mid term Examination | 1 | 3 | 3 |
Individual Study for Final Examination | 1 | 3 | 3 |
Homework | 1 | 4 | 4 |
|
Contribution of Learning Outcomes to Programme Outcomes |
|
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
|
|