Microsoft SQL Server and Database Management course

Course Code: hsts-c39

What is included in this course

The course objectives are:

Authenticating and authorizing users
Assigning server and database roles
Authorizing users to access resources
Protecting data with encryption and auditing
Recovery models and backup strategies
Backing up SQL Server databases
Restoring SQL Server databases
Automating database management
Configuring security for the SQL Server agent
Managing alerts and notifications
Managing SQL Server using PowerShell
Tracing access to SQL Server
Monitoring a SQL Server infrastructure
Troubleshooting a SQL Server infrastructure
Importing and exporting data

Course Description

This instructor-led course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure.

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

Course Prerequisites

Familiarity with database concepts, Windows desktop navigation and Transact-SQL. Attendance at our SQL Coding and DB Management course is highly recommended although not required.

Self-paced training

This course is available in a self-paced video format starting at $60. Click here to learn more and register. For complete self-paced system admin training, visit our System Admin- Complete Training Bundle page.

Corporate and Enterprise Training

Our live courses are also offered via our enterprise training program which comes with:

In-person training at your location
Access to recorded sessions of live classes
Flexible training schedules that match your employees’ availability
Course curriculum customization based on your training requirements and business goals
Special rates for small or large groups

Feel free to contact us by email or phone to discuss your training needs and get a quote.

Overall Info About our Live Classes

Highlights

30 hours of hands-on training led by experienced instructors
Digital courseware and online course tracking
Final course project delivery
Certificate of Completion for each course
Session-based assignment

Enrollment Fee

In-person in DC or live online for $2990 per course

Course Session Dates

Our courses are offered all year around. Upon registration we enroll you to the earliest available class but you can reschedule it free of charge.

Locations

Virtual live instructor classes via Zoom
In-person classes in Washington DC and Virginia:
Below are our DC classroom locations:

Dupont Circle

1666 Connecticut Ave NW Washington D.C. 20009

Logan Circle

1624 14th St NW Washington D.C. 20009

Chinatown

601 I St NW Washington D.C. 20001

Columbia Heights

3343 14th St NW Washington D.C. 20010

Below are our Virginia classroom locations:

Falls Church

Comining soon...
Private custom training on site or at your location
Project based training cn site or at your location

Time

Online Monday-Friday: 11 am-5:30 pm EST
DC Monday-Friday: 9 am-3:30 pm EST
DC/Online Saturdays: 11 am-5:30 pm EST
DC/Online Sundays: 1 pm-7:30 pm EST
Private custom & project based training: your preference

Software Versions

Our classes are taught on the most current version of software whenever possible. To request a specific version, please Contact Us or call us at 240-200-6131

Course Outline

Topics Covered in this Course

1- Authenticating and Authorizing Users

Authenticating Connections to SQL Server
Authorizing Logins to Access Databases
Authorization Across Servers
Partially Contained Databases

2- Assigning Server and Database Roles

Working with Server Roles
Working with Fixed Database Roles
Creating User-Defined Database Roles

3- Authorizing Users to Access Resources

Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level

4- Protecting Data with Encryption and Auditing

Options for Auditing Data Access in SQL Server
Implementing SQL Server Audit
Managing SQL Server Audit
Protecting Data with Encryption

5- SQL Server Recovery Models

Backup Strategies
Understanding SQL Server Transaction Login
Planning a SQL Server Backup Strategy

6- Backup of SQL Server Databases

Backing up Databases and Transaction Logs
Managing Database Backups
Working with Backup Options

7- Restoring SQL Server Databases

Understanding the Restore Process
Restoring Databases
Working with Point-in-time Recovery
Restoring System Databases and Individual Files

8- Tracing Access to SQL Server

Capturing Activity Using SQL Server profiler
Improving Performance with the Database Engine Tuning Advisor
Working with Tracing Options
Distributed Replay

9- Monitoring SQL Server

Monitoring Activity
Capturing and Managing Performance Data
Analyzing Collected Performance Data
SQL Server Utility

10- Troubleshooting SQL Server

SQL Server Troubleshooting Methodology
Resolving Service Related Issues
Resolving Login and Connectivity Issues
Troubleshooting Common Issues

11- Importing and Exporting Data

Transferring Data to/from SQL Server
Importing and Exporting Table Data
Using BCP and BULK INSERT to Import Data
Deploying and Upgrading Data-Tier Applications

Self-paced registration
Registration: self-paced from $60 or live for $2990 Pick your class type Discount or coupon code: Total: $