DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING II
- Course
- ISYE344 - DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING II
- Department
- Information Systems Engineering - English - Master
- Course Type
- Scientific Preparation
- Status
- Required
- Language
- English
- Credit
- 0
- ECTS
- 0
- T+P+L
- 0 + 0 + 0
- Course Coordinator(s)
- -
- Prerequisite
- -
- Keywords
- -
Course Description
-
DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING II
Evaluation Tools (Active Term)
| Item | Type | Weight (%) |
|---|---|---|
| Midterm | Midterm | 35 |
| Final | Final | 40 |
| Project | Project | 15 |
| Lab | Assignment | 10 |
| Total | 100 | |
Course Syllabus
| Week | Topic |
|---|---|
| Week 1 | Introduction |
| Week 2 | Revision of DB I (ER Diagrams) |
| Week 3 | Revision of DB I (SQL) |
| Week 4 | SQL Developer |
| Week 5 | Retrieving data with Joins |
| Week 6 | Retrieving data with Sub-queries |
| Week 7 | Data definition Languages (DDL), Data Manupulation Language (DML) |
| Week 8 | Midterm Week |
| Week 9 | Controling user access, Managing schema Objects |
| Week 10 | Manupilating Large Data from many source |
| Week 11 | Stored Procedures and Exception handling |
| Week 12 | Stored Functions |
| Week 13 | Dynamic SQL |
| Week 14 | Triggers |
| Week 15 | Developing Database Applications |
Reference Books & Course Materials
- 01 Elmasri & Navathe "Fundementals of Database systems" 5th edition 2007
- 02 Oracle PL/SQL: Expert Techniques for Developers and Database Administrators
- 03 Database System Concepts
Learning Outcomes
- L01 To develop skills for database administration for database objects,
- L02 To give students an understanding of the fundamental concepts in stored procedures/functions/triggers/materialized views,
- L03 To give students a working knowledge of Oracle DBMS Server's PLSQL,
- L04 To enable students in the use of DBMS within an application.
Program Outcomes
No program outcomes have been defined.
Po-Lo Matrix
The PO-LO matrix has not been populated yet.