Online SQL Server Courses
Using Database Health Monitor
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.
SQL Server Backup and Restore
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.
SQL Server JOIN Types
In this course you will first gain an understanding of the differences between each of these types of joins, 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.
Track Blocking in SQL Server with Email Alerts
Using our instruction and scripts included you will successfully configure email notifications when SQL Server blocking occurs. Address the blocking BEFORE it takes down your system.
Read MoreLearning Common Table Expressions in SQL Server
One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server.
Learn how recursive CTE’s perform better than other methods to create hierarchical results. See how CTE’s compare to SQL Server offset and fetch paging techniques.
Using TSQL Output Clause
The SQL Server output clause is a great way to get data back from an insert, update or delete statement, and it cause be used for auditing, or tracking of changes. It is also a great way to capture changes for a type of undo mechanism if needed. One over the more overlooked SQL Server features that can help you write more effective queries.
This course is part of the Querying SQL Server series.
Aggregating Data in your SQL Server
You will learn about basic aggregation as well as aggregation with windowing using the over clause. You will gain a good understanding of how the group by works in a standard query and how partitioning works in the windowing functions. Learn how null impacts the aggregate functions, and how to better handle null cases. Learn how the over windowing functions work and how to group by different columns in the same query.
This course is part of the Querying SQL Server series.
Preparing for SQL Server Corruption
A detailed course on how to prepare your SQL Server to reduce the impact of corruption and how to be ready to react in the event that your SQL Server is hit with corruption.
You will learn: Causes of Corruption,
Corruption Stories, Detecting Corruption, Reducing Impact,
Reducing risk of corruption, What to do if you have corruption, What if you need help, Ransomware versus Corruption, Corruption versus Drive Failure, and more.
Getting Started with SQL Server
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.