SQL Server Training Classes

This complete course will help you determine if you have a sufficient backup strategy and restore plan OR will help you build one from scratch.

In this course we dive into real life stories, RTO and RPO lesson with examples, what might you need to restore from, types of backups, configuring backups with maintenance plans, restoring from backups, ransomware considerations, building restore script and other backup tools.

In this course you will first gain an understanding of the differences between each of these types of SQL JOIN types, and when they should be used.

Then we’ll explore some common uses for JOINs, such as replacing a not in clause with JOIN to get the same results with better performance. You will take home the right foundations to get at the data that you want.

In this course we cover the steps you need to monitor your SQL Server using the Database Health Monitor application.

Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn.

This is an introductory class that will help you get SQL Server and all the tools you need to access the databases installed and running on your computer.

By the end of this course you will be proficient in using the tools to access SQL Server, browsing data in databases, and writing some basic queries.