DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING II
- Course
- CMPE344 - DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING II
- Department
- Computer 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)
No evaluation items have been defined.
Course outcomes
- 01 To develop skills for database administration for database objects
- 02 To give students an ability to clarify and apply the fundamental concepts in stored procedures/functions/triggers/materialized views
- 03 To give students a working knowledge and ability to apply Oracle DBMS Server's PLSQL
- 04 To enable students develop an application with DBMS
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.