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 3 0 3 8
The course opens with the approval of the Department at the beginning of each semester

Basic information

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.

Learning Outputs

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: 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
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

ECTS / Workload Table

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

Contribution of Learning Outcomes to Programme Outcomes

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) Uses basic Software Engineering knowledge and competencies.
2) Applies the software development ability that is necessary for software engineering applications.
3) Uses data structures and applies information about algorithm development.
4) Develops system programs on operating systems.
5) Develops system programs on operating systems.
6) Creates the structure of computer networks and network security.
7) Uses business intelligence, data mining and data analysis tools, applies techniques about them.
8) Develops database applications and WEB based programs.
9) Defines, analyzes, designs and manages information technologies projects.
10) Uses and develops technology-based environments and tools in education.
11) Detects, identifies and solves information technology needs of the business environment.
12) Uses the capabilities of information technologies within the rules of professional responsibility and ethics.