computer class

CRITICAL PATH [ SQL Server Administration, ITE5322, Fall2022]

The Critical Path is the calendar, timeline or weekly course schedule. It is an important

document that lays out weekly objectives that you, the student, are responsible for to ensure

academic success. You are strongly advised to print out a copy of the Critical Path and to refer

to it regularly

Modules Topics and Readings

Class

Activity Weight

1

Sep 7

Introduction to course

 Getting Started

 Identify SQL Server editions and

requirements

 Implement SQL Server 2019 in virtual

app.

Lab activity 1 1%

2

Sep 14

Becoming familiar with the SQL

Server 2019 environment  Installation of SQL Server Management

Studio 2019 ( in vapp)

 Build a SQL Server database by adding

physical files using T-SQL scripts

 Lab activity 2

Assignment 1 2%

3%

3

Sep 21

Configure data access and

permissions by creating and

maintaining users.

 Create and maintain users and custom

roles

 Manage database object permission

 Lab activity 3 Assignment 2

2%

3%

4

Sep 28

Manage backup and restore

database

 Develop and design a backup strategy to

create the database backups

 Manage transaction log backups

 Lab activity 4

 Assignment 3

2%

3%

5

Oct 5

Manage backup and restore

database

 Configure backup automation

 Configure encryption for connections

 Lab activity 5

Assignment 4

Quiz-01

2%

4%

7%

Modules Topics and Readings Class Activity Weight

6

Oct 12

Configure data access and

auditing  Configure an audit on SQL Server

 Query the SQL Server audit log

 Managing a SQL Server audit

 Lab activity 6

2%

Oct 19  Midterm 15%

7

Oct 26 Reading Week (no class)

Nov 2

Manage and Monitor SQL Server

Queries  Using Traces and Profiler

 Troubleshoot Server Query Performance

using Database Tuning Advisor

 Identify and Troubleshoot Deadlocks

 Improve Query performance using

Indexes

 Lab activity 7

Assignment 4 2%

3%

9

Nov 9

Manage and Monitor SQL Server

instances  Using Performance monitor, Activity

Monitor and Data Collector

 Introduction to Query Store

 Troubleshoot Server performance using

these tools

 Lab activity 8

Assignment 5 3%

3%

10

Nov 16

Manage and Monitor SQL Server

instances and queries  Manage statistics

 Identify the cause of performance

degradation using DMVs and Extended

Events

 Lab activity 9

Assignment 6 3%

4%

11

Nov 23

 Manage notifications on SQL Server

Performance Issues

 Manage Alerts

 Lab activity 10

 Assignment 7

Quiz-02

3%

3%

8%

Modules Topics and Readings Class Activity Weight

 Manage Operators and DB-Mail

12

Nov 30

Manage high availability and

disaster recovery  Implement log shipping

 Implement Replication and Mirroring

 Lab activity 11

Assignment 8 3%

4%

13

Dec 7

Manage high availability and

disaster recovery  Implement and monitor availability group

 Architect failover clustering

 Manage shared disks

Lab activity 12

Assignment 9 3%

3%

14

Dec 14  Final exam

15%

Summary

Total for Lab Activity 25%

Total for all Quizzes 15%

Total for all Assignments 30%

Tests 30%

TOTAL 100%