| |
| Course: | INFO365 - Database Administration I |
|
|
| On Campus Offering: | Winter (day) |
|
| Online Offering: | Summer |
| | Faculty: | Grillo, Peter
Hu, Xiaohua Tony
Song, Il-Yeol
|
|
| Extended Course Description: | Catalog Course Description:
Database Administration is a continuation of Database Management Systems, and includes the following: advanced ERD techniques, database management system internals and advanced elements of the SQL language, as well as stored procedures and triggers, specifically as demonstrated in the Oracle implementation.
Pre-requisites and Co-requisites:
INFO 210 Database Management Systems
CS 390 Data Structures OR CS 260 Data Structures
Curriculum Role:
This course presents basic technology for database administration.
Course Rationale:
This course establishes and provides the necessary techniques and theory for students wanting to become a database management system administrator.
Course Outcomes:
Upon successful completion of this course, a student will be able to:
• Perform advanced ERD analysis
• Explain how a real RDBMS works
• Create database triggers, procedure and functions
Course Content:
Principal topics and the approximate number of weeks devoted to each are:
• Functional dependencies and advanced normalization (1)
• Advanced SQL (1)
• Database internals (1)
• PL/SQL (1)
• Database triggers (2)
• Stored procedures (2)
• User defined functions (2)
Presentation:
Note: Presentation method may vary somewhat from section to section.
Teaching methods include lecture, homework and group projects.
Assessment:
Note: Assessment method may vary somewhat from section to section.
Grade is based on examinations, class participation, homework and group projects.
|
|
| Previous | Course List | Course Offerings | Next |
|
|
