YZM5560 Database Programming with PL/SQLBahçeşehir UniversityDegree Programs INFORMATION TECHNOLOGIES (TURKISH, THESIS)General Information For StudentsDiploma SupplementErasmus Policy StatementNational QualificationsBologna Commission
INFORMATION TECHNOLOGIES (TURKISH, THESIS)
Master TR-NQF-HE: Level 7 QF-EHEA: Second Cycle EQF-LLL: Level 7

Course Introduction and Application Information

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.

Basic information

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.

Learning Outcomes

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

Course Content

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.

Weekly Detailed Course Contents

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

Sources

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.

Evaluation System

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

ECTS / Workload Table

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

Contribution of Learning Outcomes to Programme Outcomes

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution