CIS 230 - Database Security w/Windows Server

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 advanced directory services on a Microsoft Windows Server. Focuses on performing tasks that are required to centrally manage users’ computers, resources and DBMS.

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

Quarters Typically Offered
Summer Day

Spring Day

Designed to Serve Serving the Network Security Engineer AAS and industry professionals
Active Date 20190619T15:16:19

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
Demonstrate database functionality and terminology

Design and implement a database security plan

Describe and use encryption methods

Implement Database installation and problem solve issues

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

Create a disaster recovery plan for a database system

Create a standard database backup and maintenance plan and understand the processes involved with back up and restoration

Implement Active Directory on Windows Server

Use Active Directory to control access to DBMS