ISTANBUL OKAN UNIVERSITY INFORMATION PACKAGE / COURSE CATALOGUE
| Information Systems and Technologies | |||||
| Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 | ||
General course introduction information
| Course Code: | BST482 | ||||||||
| Course Name: | Procedural Database PL/SQL | ||||||||
| Course Semester: | Fall | ||||||||
| Course Credits: |
|
||||||||
| Language of instruction: | TR | ||||||||
| Course Requisites: | |||||||||
| Does the Course Require Work Experience?: | No | ||||||||
| Type of course: | Department Elective | ||||||||
| Course Level: |
|
||||||||
| Mode of Delivery: | Face to face | ||||||||
| Course Coordinator : | Dr.Öğr.Üyesi NURŞEN TOPÇUBAŞI | ||||||||
| Course Lecturer(s): |
|
||||||||
| Course Assistants: |
Course Objective and Content
| Course Objectives: | This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. |
| Course Content: | This course is given in cooperation with the Oracle Academy and course content is PL/SQL. Introduction to PL/SQL; Benefits of PL/SQL; Creating PL/SQL Blocks; Defining Variables and Datatypes; Using SQL in PL/SQL; Conditional Control Statements (IF; CASE/WHEN); Iterative Control (Basic Loops; While; For and Nested Loops); Cursors; Composite Datatypes; Exception Handling; Using and Managing Procedures; Functions; Using and Managing Packages; Using and Managing Triggers. |
Learning Outcomes
The students who have succeeded in this course;
|
||||||||||||||||||||||||||||||||||
Lesson Plan
| Week | Subject | Related Preparation |
| 1) | Fundamentals (Introduction to PL/SQL, Benefits of PL/SQL, Creating PL/SQL Blocks) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 2) | Defining Variables and Datatypes (Using Variables in PL/SQL, Recognizing PL/SQL Lexical Units, Recognizing Data Types, Using Scalar Data Types, Writing PL/SQL Executable Statements, Nested Blocks and Variable Scope) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 3) | Using SQL in PL/SQL (Review of SQL DML, Retrieving Data in PL/SQL, Manipulating Data in PL/SQL, Using Transaction Control Statements) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 4) | Program Structures to Control Execution Flow (Conditional Control: IF Statements, Case Statements, Iterative Control: Basic Loops, While and For Loops, Nested Loops) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 5) | Using Cursors and Parameters (Introduction to Explicit Cursors, Using Explicit Cursor Attributes) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 6) | Using Cursors and Parameters (Cursor FOR Loops, Cursors with Parameters, Using Cursors For Update, Using Multiple Cursors) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 7) | Using Composite Datatypes (User-Defined Records, Indexing Tables of Records) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 8) | Midterm Exam | |
| 9) | Exception Handling (Handling Exceptions, Trapping Oracle Server Exceptions, Trapping User-Defined Exceptions, Recognizing the Scope of Exceptions) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 10) | Using and Managing Procedures (Creating Procedures, Using Parameters in Procedures, Passing Parameters) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 11) | Using and Managing Functions (Creating Functions, Using Functions in SQL Statements, Review of the Data Dictionary, Managing Procedures and Functions, Review of Object Privileges) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 12) | Using and Managing Packages (Creating Packages, Managing Package Concepts, Advanced Package Concepts) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 13) | Getting the Best out of Packages, Improving PL/SQL Performance | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
| 14) | Using and Managing Triggers (Introduction to Triggers, Creating DML Triggers, Creating DDL and Database Event Triggers, Managing Triggers) | Oracle iLearning (Oracle Academy) - Oracle Application Express (APEX) |
Sources
| Course Notes / Textbooks: | Oracle Database PL/SQL Language Reference – Sheila Moore - Oracle Corporation |
| References: | Oracle PL/SQL Programming - Steven Feuerstein, Bill Pribyl – O’Reilly Publishing Mastering Oracle PL/SQL: Practical Solutions, Connor McDonald, Chaim Katz, Christopher Beck, Joel R. Kallman, David C. Knox – Apress Publishing |
Course-Program Learning Outcome Relationship
| Learning Outcomes | 1 |
3 |
2 |
|||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Program Outcomes | ||||||||||
| 1) Defines the fundamental components of information systems and explains their operation. | ||||||||||
| 2) Interprets and compares information regarding computer hardware, software, and network structures. | ||||||||||
| 3) Applies and integrates technologies such as big data, artificial intelligence, and data analytics into projects. | ||||||||||
| 4) Designs algorithms and implements software solutions for complex IT problems. | ||||||||||
| 5) Designs, installs, and operates database systems through queries. | ||||||||||
| 6) Applies project management techniques and contributes to teamwork in software projects. | ||||||||||
| 7) Explains and applies information security, ethical principles, and legal frameworks. | ||||||||||
| 8) Keeps up-to-date with technological developments in the field and implements continuous learning methods for personal development. | ||||||||||
| 9) Uses verbal and written communication skills and gives presentations on technical topics. | ||||||||||
| 10) Works collaboratively with diverse disciplines and produces solutions in multidisciplinary projects. | ||||||||||
| 11) Develops innovative ideas, assumes leadership roles, and applies entrepreneurial skills in various IT projects. | ||||||||||
Course - Learning Outcome Relationship
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | Defines the fundamental components of information systems and explains their operation. | 5 |
| 2) | Interprets and compares information regarding computer hardware, software, and network structures. | 4 |
| 3) | Applies and integrates technologies such as big data, artificial intelligence, and data analytics into projects. | 4 |
| 4) | Designs algorithms and implements software solutions for complex IT problems. | |
| 5) | Designs, installs, and operates database systems through queries. | 3 |
| 6) | Applies project management techniques and contributes to teamwork in software projects. | |
| 7) | Explains and applies information security, ethical principles, and legal frameworks. | |
| 8) | Keeps up-to-date with technological developments in the field and implements continuous learning methods for personal development. | |
| 9) | Uses verbal and written communication skills and gives presentations on technical topics. | |
| 10) | Works collaboratively with diverse disciplines and produces solutions in multidisciplinary projects. | |
| 11) | Develops innovative ideas, assumes leadership roles, and applies entrepreneurial skills in various IT projects. |
Learning Activity and Teaching Methods
| Expression | |
| Individual study and homework | |
| Lesson | |
| Lab | |
| Homework | |
| Case Study |
Assessment & Grading Methods and Criteria
| Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
| Homework | |
| Application | |
| Individual Project | |
| Presentation | |
| Case study presentation |
Assessment & Grading
| Semester Requirements | Number of Activities | Level of Contribution |
| Attendance | 42 | % 5 |
| Quizzes | 15 | % 10 |
| Presentation | 1 | % 10 |
| Midterms | 1 | % 25 |
| Final | 1 | % 50 |
| total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 50 | |
| PERCENTAGE OF FINAL WORK | % 50 | |
| total | % 100 | |
Workload and ECTS Credit Grading
| Activities | Number of Activities | Workload |
| Course Hours | 14 | 42 |
| Midterms | 1 | 3 |
| Final | 1 | 3 |
| Total Workload | 48 | |