ENGINEERING MANAGEMENT (TURKISH, NONTHESIS)
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	Spring Fall	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
1)	Follows the scientific literature, analyzes it critically, and uses it effectively in solving engineering problems.
2)	Designs, plans, implements, and manages original projects related to the program field.
3)	Independently conducts studies related to the program field, assumes scientific responsibility, and evaluates the results with a critical perspective.
4)	Presents the results of their research and projects effectively in written, oral, and visual formats in accordance with academic standards.
5)	Conducts independent research on subjects requiring expertise in their field, develops original ideas, and transfers this knowledge into practice.
6)	Effectively uses advanced theoretical and practical knowledge specific to the program field.
7)	Acts in accordance with professional, scientific, and ethical values; takes responsibility by considering the social, environmental, and ethical impacts of engineering practices.