CST 259 - Database Administration

Credits: 3

Gives a firm foundation in basic administration of a database. Installs and maintains a database software, gains a conceptual understanding of database architecture and how its components work and interact with one another. Creates an operational database and properly manages the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

Prerequisite(s): CST 159 with a minimum grade of “C”
Corequisite(s): None
Lecture Hours: 30 Lab Hours: 15
Meets MTA Requirement: None
Pass/NoCredit: Yes

Outcomes and Objectives

Prepare a database environment.
1. Determine system requirements for a database environment.
2. Set environment variables.
3. Set advanced installation options.
4. Configure database options.
Manage database storage structures.
1. Describe how Table data is stored.
2. Describe a database Block.
3. Manage Tablespaces.
Administer user security.
1. Create database user Accounts.
2. Use predefined administration Accounts.
3. Describe the benefits of Roles.
4. Create/assign Roles.
5. Implement password security features.
6. Assign quotas to users.
Manage Schema objects.
1. Describe a Schema.
2. Access Schema objects.
3. Specify data types in Tables.
4. Create and modify Tables.
5. Understand data integrity.
6. Describe/create Indexes.
7. Describe/create Views.
8. Describe/create Sequences.
Perform database backups.
1. Understand backup solutions.
2. Plan/perform user-managed backup.
3. Configure backup settings.
Use property classes to share object properties.
1. Store reusable objects in object groups.
2. Create object libraries to store reuseable objects.
3. Use PL/SQL libraries in forms to share PL/SQL program units.