Database Administration

This course focuses on how to fine tune a selected relational database (RDB), such as SQL SERVER/ORACLE. Topics include RDB architectural components; RDB administration tools; RDB instances; creating an RDB database; constructing Data Dictionary views; maintaining the control file; maintaining the Redo Log File; managing table spaces and data files; understanding relationships and impacts on the storage structure; managing tables, indexes and segments; maintaining data integrity; managing users, profiles, privileges, and roles; understanding and using database auditing options; using National Language Support.