Jun 07, 2020  
2017-2018 Catalog 
2017-2018 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CIS 230 - Database Security

5 Credits
Advanced course in database concepts and applications of database processing with emphasis on advanced database security, installation, data encryption, and database maintenance.

Pre-requisite(s) CIS 166 min 2.0 and CIS 217 min 2.0
Fees CF

Designed to Serve Serving in the Network Specialist AAS and industry professionals
Active Date 2014-09-02

Grading System Decimal Grade
Class Limit 24
Contact Hours: Lecture 55 Lab 0 Worksite 0 Clinical 0 Other 0
Total Contact Hours 55
Degree Distributions:
Course Outline
1. Database Terminology 2. Database security and encryption 3. Permissions and authentication 4. Introduction to SQL 5. Installing and Administering an SQL database A. Install on various platforms B. Set up accounts 6. Database Optimization 7. Data Encryption A. Available encryption methods dependent upon platform B. Hash values C. Encrypt or hash choices 8. Database optimization 9. Database Security A. Who has access to what? B. Who can update what? C. Publicly accessible portions D. Database Administrator Responsibilities E. Network Administrator Responsibilities 10. Database Maintenance A. Backup Methods B. Restoring a database 11. Advanced Database Administration

Student Learning Outcomes
Demonstrate an overall understanding of Database Terminology

Design and implement a database security plan

Describe and use encryption methods.

Implement Database installation, and problem solve issues

Demonstrate Database Admin. responsibilities.

Create a disaster recovery plan for a database system

Create a standard database backup and maintenance plan, and understand process invloved with back up and restoration.

Add to Portfolio (opens a new window)