Data Architecture Management
DAMG 7275: Advanced Database Management Systems
Lecture - 4 credits
- Introduces the skill set required to become a serious database applications developer.
- Offers an overview of the Oracle9i object-relational database system for those who have mastered the fundamental principles of database design and are competent with basic SQL.
- Gives students the opportunity to develop a strong understanding of the PL/SQL programming language, which is used to create triggers, user-generated functions, stored procedures, and packages for programming Oracle objects.
- Emphasizes advanced SQL features and Oracle-specific SQL enhancements.
- Covers optimization and tuning issues.
- Covers corresponding material for Transact-SQL (used for Microsoft SQL Server and Sybase database systems) as time and resources permit.
Introduces the skill set required to become a serious database applications developer. Show more.