CIS424
Preview: CIS424 : Database Administration I
Course Guide
Prerequisites
Course Description
Instructional Materials
Course Learning Outcomes
Weekly Course Schedule
Week 1 - To Do List
Discuss: Introduce yourself to your peers and professor.
Learn: Read Administering
a
SQL
Database
Infrastructure , Chapter 1, Skill 1.1.
Learn: View CBT Nuggets videos.
CIS 111 (Introduction to Relational Database Management Systems) AND CIS 276 (SQL Programming)
This is a lab-based course that prepares students with the skills to plan, install, develop and administer databases in the Microsoft SQL Server
(MSSQL) database environment. Topics also include procedures that enable installing and configuring a database server, security, optimizing database
performance and troubleshooting techniques.
Required Resources
1. Victor Isakov. 2018. Exam
Ref
70-764
Administering
a
SQL
Database
Infrastructure. Pearson Education.
2. CBT Nuggets. No date. Microsoft MCSA SQL Server 2016 (70-764): Administering a SQL Database Infrastructure.
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.
Manage server security, including encryption, data access, permissions, and audits.
1
Conduct backup and restoration operations while preserving the integrity of a database.
2
Assess the health of server instances using monitoring tools and techniques.
3
Configure options for high availability and disaster recovery.
4
NOTE: The links in this document do not function. Please refer to your course to view/download linked content.
Week 1 - To Do List
Discuss: Participate in the discussion, Tools in SQL Database Infrastructure for Encryption.
Assignment: Complete CBT Nuggets Virtual Lab 10.
Quiz: Complete the Skill 1.1 Quiz.
Week 2 - To Do List
Learn: Read Administering
a
SQL
Database
Infrastructure, Chapter 1,
Skill 1.2.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, Row Level Security.
Assignment: Complete CBT Nuggets Virtual Lab 18.
Quiz: Complete the Skill 1.2 Quiz.
Week 3 - To Do List
Learn: Read Administering
a
SQL
Database
Infrastructure, Chapter 1, Skill 1.3.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, SQL Server Auditing Capabilities.
Assignment: Complete CBT Nuggets Virtual Lab 25.
Quiz: Complete the Skill 1.3 Quiz.
Week 4 - To Do List
Learn: Read Administering
a
SQL
Database
Infrastructure, Chapter 2, Skill 2.1 .
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, Backing up a Database in a SQL Environment.
Assignment: Complete CBT Nuggets Virtual Lab 34.
Quiz: Complete the Skill 2.1 Quiz.
Week 5 - To Do ListWeek 5 - To Do List
Learn: Read Administering
a
SQL
Database
Infrastructure,
Chapter 2, Skills 2.2 and 2.3.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, Database Recovery Model.
Assignment: Complete CBT Nuggets Virtual Labs 42 and 47.
Quiz: Complete the Skill 2.2 and 2.3 Quiz.
Week 6 - To Do List
Learn: Read Administering
a
SQL
Database
Infrastructure , Chapter 3, Skills 3.1 and 3.2.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, SQL Server Maintenance Plan.
Assignment: Complete CBT Nuggets Virtual Labs 53 and 59.
Quiz: Complete the Skill 3.1 and 3.2 Quiz.
Week 7 - To Do List
Learn: Read Administering
a
SQL
Database
Infrastructure , Chapter 3, Skills 3.3 and 3.4.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, Monitoring Tools.
Assignment: Complete CBT Nuggets Virtual Labs 65 and 70.
Quiz: Complete the Skill 3.3 and 3.4 Quiz.
Week 8 - To Do List
Learn: Read Administering
a
SQL
Database
Infrastructure , Chapter 3, Skill 3.5.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, Query Store.
Week 8 - To Do List
Assignment: Complete CBT Nuggets Virtual Lab 80.
Quiz: Complete the Skill 3.5 Quiz.
Week 9 - To Do List
Learn: Read Administering
a
SQL
Database
Infrastructure, Chapter 4, Skills 4.1, 4.2, and 4.3.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, High Availability and Disaster Recovery.
Lab: Complete CBT Nuggets Virtual Lab 84.
Quiz: Complete the Skill 4.1, 4.2, and 4.3 Quiz.
Week 10 - To Do List
Learn: Read Administering
a
SQL
Database
Infrastructure, Chapter 4, Skill 4.4 and Skill 4.5.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, Availability Groups.
Lab: Complete CBT Nuggets Virtual Labs 91 and 95.
Quiz: Complete the Skill 4.4 and 4.5 Quiz.
Week 11 - To Do List
Discuss: Participate in the discussion, Reflection.
Grading Scale
Participation Total Points % of Grade
Discussion Participation 250 25%
Assignment Total Points % of Grade
w01a1 - CBT Nuggets Virtual Lab 10 25 2.5%
w01q1 - Skill 1.1 Quiz 40 4%
w02a1 - CBT Nuggets Virtual Lab 18 25 2.5%
Participation Total Points % of Grade
w02q1 - Skill 1.2 Quiz 40 4%
w03a1 - CBT Nuggets Virtual Lab 25 25 2.5%
w03q1 - Skill 1.3 Quiz 40 4%
w04a1 - CBT Nuggets Virtual Lab 34 25 2.5%
w04q1 - Skill 2.1 Quiz 40 4%
w05a1 - CBT Nuggets Virtual Labs 42 and 47 50 5%
w05q1 - Skill 2.2 and 2.3 Quiz 40 4%
w06a1 - CBT Nuggets Virtual Labs 53 and 59 50 5%
w06q1 - Skill 3.1 and 3.2 Quiz 40 4%
w07a1 - CBT Nuggets Virtual Labs 65 and 70 50 5%
w07q1 - Skill 3.3 and 3.4 Quiz 40 4%
w08a1 - CBT Nuggets Virtual Lab 80 25 2.5%
w08q1 - Skill 3.5 Quiz 40 4%
w09a1 - CBT Nuggets Virtual Lab 84 25 2.5%
w09q1 - Skill 4.1, 4.2, and 4.3 Quiz 40 4%
w10a1 - CBT Nuggets Virtual Lab 91 and 95 50 5%
w10q1 - Skill 4.4 and 4.5 Quiz 40 4%
Totals 1000 100%
Final Course Grade
Points Percentage Grade
900 - 1000 90% - 100% A
800 - 899 80% - 89% B
700 - 799 70% - 79% C
600 - 699 60% - 69% D
0 - 599 59% and below F
Unique Course Features
Grading Scale Notation
Please consult the University Catalog and your academic advisor to determine the final grade needed in this class to satisfy your specific degree
conferral requirements.
Please consult the University Catalog and your academic advisor to determine the final grade needed in this class to satisfy your specific degree
conferral requirements.
Retired Certification Exam
Microsoft announced that due to its intention to move towards role-based certifications, exams associated with Microsoft Certified Solutions Associate
(MCSA), Microsoft Certified Solutions Developer (MCSD), and Microsoft Certified Solutions Expert (MCSE) certifications will be retired. The exams
associated with these certifications are scheduled to retire on January 31, 2021.
The content in this course aligns with the Microsoft certification exam 70-764, which is a retired exam. Students should disregard any and all references
to the Microsoft certification in course materials. However, as the content itself is still relevant and valuable in the industry, students will be expected to
Assignments
demonstrate competency through the completion of all course activities and assignments, including labs, quizzes, and discussions.
w01a1 - CBT Nuggets Virtual Lab 10
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Configure Encryption Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
10. Configure Encryption: Lab.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Labs assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w02a1 - CBT Nuggets Virtual Lab 18
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Configure Data Access and Permissions Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
18. Configure Data Access and Permissions: Lab.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Labs assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w03a1 - CBT Nuggets Virtual Lab 25
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Configure Auditing Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
25. Configure Auditing: Lab.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Labs assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w04a1 - CBT Nuggets Virtual Lab 34
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Develop a Backup Strategy Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
34. Develop a Backup Strategy: Lab.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Labs assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Need Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w05a1 - CBT Nuggets Virtual Labs 42 and 47
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Restore Databases and Manage Database Integrity Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
42. Restore Databases: Lab.
47. Manage Database Integrity: Lab.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Lab(s) assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w06a1 - CBT Nuggets Virtual Labs 53 and 59
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Monitor Database Activity and Monitor Queries Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
53. Monitor Database Activity: Lab.
59: Monitor Queries: Lab.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Labs assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w07a1 - CBT Nuggets Virtual Labs 65 and 70
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Manage Indexes and Manage Statistics Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
65. Manage Indexes: Lab.
70: Manage Statistics: Lab.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Labs assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Com
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w08a1 - CBT Nuggets Virtual Lab 80
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Monitor SQL Server Instances Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
80. Monitor SQL Server Instances: Lab.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Labs assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w09a1 - CBT Nuggets Virtual Lab 84
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Implement Log Shipping Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
84: Implement log Shipping: Lab.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Labs assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w10a1 - CBT Nuggets Virtual Lab 91 and 95
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Implement Always On Availability Groups and Implement Failover Cluster Instances Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following lab:
91. Implement Always On Availability Groups: Lab.
95. Implement Failover Cluster Instances: Lab.
How to Submit Your Lab Reports
© 2020 Strategic Education, Inc.
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets Virtual Labs assigned this week.
Take screenshots of your results as prescribed by the Lab Report guide.
Collect your screenshots for the week’s labs into a single document.
Don’t forget to highlight the specific information.
Submit your document to this assignment.
(Note: Failure to submit the result into the assignment submission area within the Strayer Blackboard courseroom will result in zero points for the
assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion and may result in partial or
incomplete credit for the assignment.)
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
