| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | YÖN310.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 | Develop database using SQL language | | 5 | 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 |
| LO1 | 4 | 4 | 5 | 5 | 4 | 4 | | LO2 | 4 | 4 | 4 | 4 | 4 | 4 | | LO3 | 5 | 5 | 5 | 5 | 5 | 5 | | LO4 | 4 | 4 | 5 | 5 | 5 | 5 | | LO5 | 5 | 5 | 5 | 5 | 5 | 5 |
|
| * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
 |
| |