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: | Spring | ||||||||
| 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 FERİDUN CEMAL ÖZÇAKIR | ||||||||
| 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) Having knowledge and skills in software development for different environments, systems management, network security, data and database management systems. | ||||
| 2) Keeping up-to-date with current issues about new information systems that are the result of rapid change of information technologies. | ||||
| 3) Be aware of the importance of Information Systems' stratagic position in the firm and its role in the creation of new business strategies. | ||||
| 4) To be able to explain the ideas and suggestions that is related to the field of Information Systems as in writing and orally. | ||||
| 5) ability to carry out an independent study on the subjects requiring expertise in the field of Information Systems. | ||||
Course - Learning Outcome Relationship
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | Having knowledge and skills in software development for different environments, systems management, network security, data and database management systems. | 5 |
| 2) | Keeping up-to-date with current issues about new information systems that are the result of rapid change of information technologies. | 4 |
| 3) | Be aware of the importance of Information Systems' stratagic position in the firm and its role in the creation of new business strategies. | 4 |
| 4) | To be able to explain the ideas and suggestions that is related to the field of Information Systems as in writing and orally. | |
| 5) | ability to carry out an independent study on the subjects requiring expertise in the field of Information Systems. | 3 |
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 | |