Testimonials

NIST Cyber Security Bootcamp — I've gained knowledge on the interconnected-ness of the NIST CSF, the informative references, a reference for a proven assessment process, what a WISP is. Having the recordings available is very valuable.

MSPL-900T00: Microsoft Power Platform Fundamentals — Instructor did an awesome job tying the material we were learning to real world scenerios and giving examples of how he has used in the the real world.

CompTIA A+: A Comprehensive Approach — You could tell that the instructor really knew the material and wasn’t just reading from a book. I plan to study and pass both parts of the exam and I will literally use this information daily on my job as IT technician.

Microsoft Excel 2019: Part 1 — The shortcuts that I learned; they will save me so much time in the future. I plan to apply this content to future spreadsheets I will create and/or modify.

MSAZ-104T00: Microsoft Azure Administrator — Instructor was very easy to understand, extremely knowledgeable, stays current (Azure seems to change frequently), and a joy to learn from.

BA08 Agile for Business Analysts — It was a great course using a lot of real world examples of using Agile framework and solving issues in developing a product.

MS-500T00: Microsoft 365 Security Administration — Overall, the instruction was great. Instructor was very familiar with the content and provided some very good realistic scenarios.

CompTIA CySA+ Cybersecurity Analyst — Great job providing real world examples.

MS55268: Microsoft Power Automate for End Users — Relevant content and labs. Useful. Have been using Power Automate for about a year now, this gave nice clarification and extra info.

Photoshop — She was very accommodating to the different skill levels in the classroom and sought out how we would use the training/software for work and personal use.

MSSC-900T00: Microsoft Security, Compliance, and Identity Fundamentals — Instructor was excellent. Very knowledgeable and had good real life examples to support the material.

CompTIA® Project+® — With no background knowledge on project management, the entire class was beneficial. I’ve learned better ways to organize and execute projects.

ITIL® Foundation Training — Wonderful instructor, positive attitude and presentation kept me engaged.

Microsoft Office 365 Online (with Teams for the Desktop) — I knew nothing about 365. That has changed. Thank you!

Cisco Unified Communication Manager and Unity Connection — He was knowledgeable and presented the material, which is highly technical, in an understandable manner.

MSAZ-900T01: Microsoft Azure Fundamentals — Good presenter and well informed on the topics covered in class. She was able to answer every question asked without any hesitation.

Certified Ethical Hacking and Countermeasures — Great learning experience. Enjoyed the hands-on lab with different connected virtualized computers.

NIST Cyber Security Bootcamp — This helped me identify what I need to do in my new position as a Cyber Security Manager.

MS-20764 - Administering a SQL Database Infrastructure

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student

Excellent presentation skills, subject matter knowledge, and command of the environment. Student

Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

This Course Uses Only Digital Curriculum »

Click here to print this page »

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:
· Basic knowledge of the Microsoft Windows operating system and its core functionality.
· Working knowledge of Transact-SQL.
· Working knowledge of relational databases.
· Some experience with database design.

Detailed Class Syllabus

Module 1: Authenticating and Authorizing Users

Authenticating connections to SQL Server
Authorizing logins to access databases
Authorization across servers
Partially contained databases

Module 2: Assigning Server and Database Roles

Working with server roles
Working with Fixed database roles
Creating user-defined database roles

Module 3: Authorizing Users to Access Resources

Authorizing user access to objects
Authorizing users to execute code
Configuring permissions at the schema level

Module 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

Module 5: SQL Server Recovery Models

Backup strategies
Understanding SQL Server transaction login
Planning a SQL Server backup strategy

Module 6: Backup of SQL Server Databases

Backing up databases and transaction logs
Managing database backups
Working with backup options

Module 7: Restoring SQL Server Databases

Understanding the restore process
Restoring databases
Working with point-in-time recovery
Restoring system databases and individual files

Module 8: Automating SQL Server Management

Automating SQL Server management
Working with SQL Server agent
Managing SQL Server agent jobs
Multi-server management

Module 9: Configuring Security for SQL Server Agent

Understanding SQL Server Agent Security
Configuring credentials
Configuring proxy accounts

Module 10: Monitoring SQL Server with Alerts and Notifications

Configuration of database mail
Monitoring SQL Server errors
Configuring operators, alerts, and notifications
Alerts in Azure SQL database

Module 11: Introduction to Managing SQL Server by using PowerShell

Configure SQL Server using PowerShell
Administer SQL Server using PowerShell
Maintain the SQL Server environment using PowerShell
Managing Azure SQL Server databases using PowerShell

Module 12: 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
Monitoring locks

Module 13: Monitoring SQL Server

Monitoring activity
Capturing and managing performance data
Analyzing collected performance data
SQL Server utility

Module 14: Troubleshooting SQL Server

SQL Server troubleshooting methodology
Resolving service related issues
Resolving login and connectivity issues
Troubleshooting common issues

Module 15: 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