2021-2022 Catalog [ARCHIVED CATALOG]
|
DBMS 150 - Database Administration
PREREQUISITES: DBMS 110 - Introduction to Data Analytics
PREREQUISITES/COREQUISITE: SVAD 111 - Linux and Virtualization Technologies Fundamentals
PROGRAM: Data Analytics
CREDIT HOURS: 3
LECTURE HOURS: 2
LAB HOURS: 2
DATE OF LAST REVISION: Fall, 2020
Introduces program applications in a database environment with emphasis on installing, configuring, modifying, and maintaining the database by means of structured query language and Enterprise Manager. Students will discuss data structures; indexed and direct file organizations; models of data, including hierarchical, network and relational; storage philosophies, data administration and analysis; design; and implementation.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course the student will be expected to:
- Describe database architecture.
- Perform an installation and configuration of a database.
- Configure middle tier services.
- Configure and manage the database storage structures.
- Create and administer user accounts.
- Perform basic backup and recovery of a database.
- Create and implement a plan to manage users and schemas.
- Construct and implement a plan for the management of data and concurrency.
- Perform administration and monitoring of undo data.
- Analyze and monitor performance using administration tools to tune the database configuration.
- Use the database diagnostic monitor.
- Describe concepts relating to database security.
COURSE CONTENT: Topical areas of study include - Structured Query Language SQL
Database space requirements
Database management
Database Components and Architecture
Installation and Configuration
Network Environment Configuration
Database Creation and Configuration
Database Encryption
Database Storage and Schema Objects
File System Encryption
Moving Data
Communication Encryption
Database Instance
Transaction Commit and Undo
Data Concurrency
Backup and Recovery
Security and Auditing
Database, Table, and Record Locking
Database Compression
Distributed and Fragmented Databases
Security Roles and Permissions
Course Addendum - Syllabus (Click to expand)
|
