The aim of this course is to enable students to combine their SQL knowledge with procedural database programming techniques in order to develop comprehensive and maintainable database applications. Using Oracle PL/SQL as the primary platform, the course covers block structures, control statements, cursors, procedures, functions, packages, triggers, and collections. Common table expressions, recursive CTEs, hierarchical queries, JSON processing, and modern PL/SQL features are also examined. In addition to writing executable code, students are expected to read existing database programs, predict their outputs, identify errors, and evaluate them in terms of performance. By the end of the course, students should be able to develop modular, reliable, reusable, and performance-oriented database programs.
Course Content
This course contains; Introduction to Advanced SQL and Database Programming,PL/SQL Architecture and Basic Block Structure,Control Structures and Iterations,Records and Cursor Management,Exception Handling,Procedures and Functions,Packages, Triggers, and Modular Design,Midterm Examination and Review,PL/SQL Collections,CTEs and Recursive CTEs,Processing JSON Data in Databases,Conditional Compilation and Version Compatibility,Modern PL/SQL and Performance Optimization,Integrated Database Application and Final Review.
Course Learning Outcomes
Teaching Methods
Assessment Methods
Teaching Methods:
Assessment Methods:
Course Outline
Order
Subjects
Preliminary Work
1
Introduction to Advanced SQL and Database Programming
2
PL/SQL Architecture and Basic Block Structure
3
Control Structures and Iterations
4
Records and Cursor Management
5
Exception Handling
6
Procedures and Functions
7
Packages, Triggers, and Modular Design
8
Midterm Examination and Review
9
PL/SQL Collections
10
CTEs and Recursive CTEs
11
Processing JSON Data in Databases
12
Conditional Compilation and Version Compatibility
13
Modern PL/SQL and Performance Optimization
14
Integrated Database Application and Final Review
Resources
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications
No
Program Qualification
Contribution Level
1
2
3
4
5
Assessment Methods
Contribution Level
Absolute Evaluation
Rate of Midterm Exam to Success
40
Rate of Final Exam to Success
60
Total
100
ECTS / Workload Table
Activities
Number of
Duration(Hour)
Total Workload(Hour)
Course Hours
0
0
0
Guided Problem Solving
0
0
0
Resolution of Homework Problems and Submission as a Report
0
0
0
Term Project
0
0
0
Presentation of Project / Seminar
0
0
0
Quiz
0
0
0
Midterm Exam
0
0
0
General Exam
0
0
0
Performance Task, Maintenance Plan
0
0
0
Total Workload(Hour)
0
Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(0/30)
0
ECTS of the course: 30 hours of work is counted as 1 ECTS credit.
Detail Informations of the Course
Course Description
Course
Code
Semester
T+P (Hour)
Credit
ECTS
DATABASE MANAGEMENT SYSTEMS II
-
Spring Semester
2+2
3
5
Course Program
Prerequisites Courses
Recommended Elective Courses
Language of Course
English
Course Level
Short Cycle (Associate's Degree)
Course Type
Elective
Course Coordinator
Assist.Prof. Ali DEMİR
Name of Lecturer(s)
Assistant(s)
Aim
The aim of this course is to enable students to combine their SQL knowledge with procedural database programming techniques in order to develop comprehensive and maintainable database applications. Using Oracle PL/SQL as the primary platform, the course covers block structures, control statements, cursors, procedures, functions, packages, triggers, and collections. Common table expressions, recursive CTEs, hierarchical queries, JSON processing, and modern PL/SQL features are also examined. In addition to writing executable code, students are expected to read existing database programs, predict their outputs, identify errors, and evaluate them in terms of performance. By the end of the course, students should be able to develop modular, reliable, reusable, and performance-oriented database programs.
Course Content
This course contains; Introduction to Advanced SQL and Database Programming,PL/SQL Architecture and Basic Block Structure,Control Structures and Iterations,Records and Cursor Management,Exception Handling,Procedures and Functions,Packages, Triggers, and Modular Design,Midterm Examination and Review,PL/SQL Collections,CTEs and Recursive CTEs,Processing JSON Data in Databases,Conditional Compilation and Version Compatibility,Modern PL/SQL and Performance Optimization,Integrated Database Application and Final Review.
Course Learning Outcomes
Teaching Methods
Assessment Methods
Teaching Methods:
Assessment Methods:
Course Outline
Order
Subjects
Preliminary Work
1
Introduction to Advanced SQL and Database Programming