INFORMATION TECHNOLOGIES (TURKISH, NON-THESIS) | |||||
Master | TR-NQF-HE: Level 7 | QF-EHEA: Second Cycle | EQF-LLL: Level 7 |
Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
YZM5560 | Database Programming with PL/SQL | Spring | 3 | 0 | 3 | 12 |
This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester. |
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. |
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 / 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. |
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 |
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 |
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. | 3 |
2) | Applies the software development ability that is necessary for software engineering applications. | 3 |
3) | Uses data structures and applies information about algorithm development. | 2 |
4) | Develops system programs on operating systems. | 2 |
5) | Defines computer organization, design and architectures. | 2 |
6) | Creates the structure of computer networks and network security. | 2 |
7) | Uses business intelligence, data mining and data analysis tools, applies techniques about them. | 3 |
8) | Develops database applications and WEB based programs. | 4 |
9) | Defines, analyzes, designs and manages information technologies projects. | 3 |
10) | Defines, analyzes, designs and manages information technologies projects. | 3 |
11) | Detects, identifies and solves information technology needs of the business environment. | 3 |
12) | Uses the capabilities of information technologies within the rules of professional responsibility and ethics. | 4 |