Oct 23, 2019
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
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
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]