MATHEMATICS (TURKISH, PHD) | |||||
PhD | TR-NQF-HE: Level 8 | QF-EHEA: Third Cycle | EQF-LLL: Level 8 |
Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
YZM5560 | Database Programming with PL/SQL | Fall | 3 | 0 | 3 | 12 |
The course opens with the approval of the Department at the beginning of each semester |
Language of instruction: | Tr |
Type of course: | Departmental Elective |
Course Level: | |
Mode of Delivery: | Face to face |
Course Coordinator : | Prof. Dr. MEHMET ALPER TUNGA |
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: | 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 |
Attendance | % 0 | |
Laboratory | % 0 | |
Application | % 0 | |
Field Work | % 0 | |
Special Course Internship (Work Placement) | % 0 | |
Quizzes | % 0 | |
Homework Assignments | % 0 | |
Presentation | % 0 | |
Project | 1 | % 30 |
Seminar | % 0 | |
Midterms | 1 | % 30 |
Preliminary Jury | % 0 | |
Final | 1 | % 40 |
Paper Submission | % 0 | |
Jury | % 0 | |
Bütünleme | % 0 | |
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 |
Laboratory | 0 | 0 | 0 |
Application | 14 | 3 | 42 |
Special Course Internship (Work Placement) | 0 | 0 | 0 |
Field Work | 0 | 0 | 0 |
Study Hours Out of Class | 14 | 3 | 42 |
Presentations / Seminar | 0 | 0 | 0 |
Project | 0 | 0 | 0 |
Homework Assignments | 0 | 0 | 0 |
Quizzes | 0 | 0 | 0 |
Preliminary Jury | 0 | 0 | 0 |
Midterms | 1 | 22 | 22 |
Paper Submission | 0 | 0 | 0 |
Jury | 0 | 0 | 0 |
Final | 1 | 41 | 41 |
Total Workload | 189 |
No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
Program Outcomes | Level of Contribution |