|
May 01, 2024
|
|
|
|
2022-2023 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 MIN: 3 LECTURE HOURS MIN: 2 LAB HOURS MIN: 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)
|
|