ENGINEERING MANAGEMENT (TURKISH, NONTHESIS) | |||||
Master | TR-NQF-HE: Level 7 | QF-EHEA: Second Cycle | EQF-LLL: Level 7 |
Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
YZM5560 | Database Programming with PL/SQL | Fall Spring |
3 | 0 | 3 | 12 |
This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester. |
Language of instruction: | Turkish |
Type of course: | Departmental Elective |
Course Level: | |
Mode of Delivery: | Face to face |
Course Coordinator : | Prof. Dr. MEHMET ALPER TUNGA |
Recommended Optional Program Components: | None. |
Course Objectives: | The objectives of this course are understanding the structure of PL/SQL, using the special structures of PL/SQL, constructing complex queries with the procedural structures of PL/SQL. |
The students who have succeeded in this course; 1. Identify the basic properties of PL/SQL 2. Construct basic PL/SQL control structures 3. Develop PL/SQL applications with SQL features 4. Define PL/SQL data storage structures 5. Define procedures, functions and packages 6. Construct triggers and exceptions |
The content of this course is composed of introduction to PL/SQL, PL/SQL control structures, SQL in PL/SQL, cursor, exception, records, tables, varrays, procedures, functions, packages, triggers. |
Week | Subject | Related Preparation |
1) | Introduction to PL/SQL | |
2) | PL/SQL control structures | |
3) | PL/SQL control structures | |
4) | SQL in PL/SQL | |
5) | Cursor | |
6) | Cursor | |
7) | Exception | |
8) | Records, Tables, arrays | |
9) | Records, Tables, arrays | |
10) | Procedures | |
11) | Procedures | |
12) | Functions | |
13) | Packages | |
14) | Triggers |
Course Notes / Textbooks: | Nilesh Shah, Database Systems using Oracle: A Simplified Guide to SQL and PL/SQL, 2ed, Pearson Prentice Hall, 2005, ISBN 0-13-191180-5 |
References: | Yok - None. |
Semester Requirements | Number of Activities | Level of Contribution |
Project | 1 | % 30 |
Midterms | 1 | % 30 |
Final | 1 | % 40 |
Total | % 100 | |
PERCENTAGE OF SEMESTER WORK | % 30 | |
PERCENTAGE OF FINAL WORK | % 70 | |
Total | % 100 |
Activities | Number of Activities | Duration (Hours) | Workload |
Course Hours | 14 | 3 | 42 |
Application | 14 | 3 | 42 |
Study Hours Out of Class | 14 | 3 | 42 |
Midterms | 1 | 22 | 22 |
Final | 1 | 41 | 41 |
Total Workload | 189 |
No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
Program Outcomes | Level of Contribution |