CIS428
Preview: CIS428 Database Administration II :
Course Guide
Prerequisites
Course Description
Instructional Materials
CIS424 (Database Administration I)
This is a lab-based course that prepares students with the skills to design, plan and optimize the
Microsoft SQL Server (MSSQL) database infrastructure. Topics include managing and maintaining
databases or multidimensional databases, user accounts, database availability, recovery, and
reporting as well as the design and implementation of security and server automation.
Required Resources
Joseph D'Antoni. 2018. Exam Ref 70-765 Provisioning SQL Databases. CIS428 Pearson
Education textbook available at https://www.strayerbookstore.com
Garth Schulte. August 2018. Microsoft MCSA SQL Server 2016 (70-765): Provisioning SQL
Databases. CIS428 CBT Nuggets virtual lab available at https://www.strayerbookstore.com
Note: A student code is required and must be purchased through the Strayer Bookstore. The
Strayer Bookstore will distribute this code to each registered student's email address. Students
should check their junk mail folder as well as their inbox folder for the email.
Strayer University Library. May 2020. Degrees in Information Technology Library
Guide. https://strayer.libguides.com/it
Ⓒ2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
NOTE: The links in this document do not function. Please refer to your course to
view/download linked content.
Course Learning Outcomes
Weekly Course Schedule
Week 1 - To Do List
Learn: Read Exam
Ref
70-765
Provisioning
SQL
Databases,
Skill 1.1.
Learn: View CBT Nuggets videos.
Discuss: Introduce yourself and complete the discussion, Service Tiers.
Quiz: Complete the Skill 1.1 Quiz.
Week 2 - To Do List
Learn: Read Exam
Ref
70-765
