CIS 230 - Database Security Foundations

5 Credits

Advanced course in database concepts and applications of database security with emphasis on installation, data encryption, and database maintenance. Provides students with the knowledge and skills necessary to install, configure, and administer services. Focuses on performing tasks that are required to centrally manage computers, resources, and databases.

Pre-requisite(s) CIS 160 min 2.0 and CIS 215 min 2.0
FeesAcademic Technology Fee

Quarters Typically Offered
Designed to Serve Serving the Network Security Engineer AAS and industry professionals
Active Date 20240401T16:34:07

Grading Basis Decimal Grade
Class Limit 24
Contact Hours: Lecture 55
Total Contact Hours 55
Degree Distributions:
ProfTech Course Yes
Restricted Elective Yes
Course Outline

Database terminology
Database security and encryption
Permissions and authentication
Introduction to SQL
Installing and Administering an SQL database
- Install on various platforms
- Set up accounts
Database Optimization
Data Encryption
- Available encryption methods dependent upon platform
- Hash values
- Encrypt or hash choices
Database optimization
Database Security
- Who has access to what?
- Who can update what?
- Publicly accessible portions
- Database Administrator Responsibilities
- Network Administrator Responsibilities
Database Maintenance
- Backup Methods
- Restoring a database
Advanced Database Administration

Student Learning Outcomes
Explain database functionality using appropriate terminology.

Design and implement a database security plan.

Use encryption methods for data protection.

Implement database installation.

Know the range of database administrative tasks DB admins would undertake on a day to day basis.

Create a disaster recovery, backup, and maintenance plan for a database system.

Control database access with directory services.