May 27, 2020
IT 340 - Database Administration
This course focuses of the various tasks, tools, responsibilities, and best practices involved in database administration. Students will learn disaster recovery, performance analysis and tuning, data dictionary maintenance, data modeling and optimization, database and user management, installation, performance monitoring, creation of users and user privileges, backup and recovery, views, partitions, advanced queries, stored procedures, transaction processing, data integrity techniques, advanced modeling and design concepts, implementing a security system, and troubleshooting.
Prerequisites & Notes
IT 100 and IT 240
Synchronous term-based course with ten weekly assignments and a final project
Course Learning Objectives
Upon completion of this course, you should be able to do the following:
- Describe the storage, hardware and memory components of a DBMS architecture.
- Explain and demonstrate system, application and database performance tuning.
- Explain various backup types and how to apply various backups to reduce the risk of data loss.
- Demonstrate the steps required to restore a database from different backup types.
- Apply best practices to database reorganization and defragmentation.
- Identify database security basics and demonstrate the ability to issue Data Control Language (DCL) statements to ensure database security.
Add to Portfolio