Information Systems and Technologies | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
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 FERİDUN CEMAL ÖZÇAKIR | ||||||||
Course Lecturer(s): | |||||||||
Course Assistants: |
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. |
The students who have succeeded in this course;
|
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) |
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 |
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. |
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 |
Expression | |
Individual study and homework | |
Lesson | |
Lab | |
Homework | |
Case Study |
Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
Homework | |
Application | |
Individual Project | |
Presentation | |
Case study presentation |
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 |
Activities | Number of Activities | Workload |
Course Hours | 14 | 42 |
Midterms | 1 | 3 |
Final | 1 | 3 |
Total Workload | 48 |