Courses

SQL Server Encryption for Developers and DBAs

Every day, companies are in the news for exposing private data. Don’t be the next statistic ! Encryption can help.

Enroll now for $295 USD !

Course Summary

Are you worried about protecting private or sensitive data?

  • Or more importantly, will you get blamed if it all goes wrong?
  • Do you understand how SQL Server encryption can help?
  • Don’t know your cell-level encryption from your Always Encrypted with Secure Enclaves?
  • Don’t know why adding a digital signature to a stored proc might be helpful?
  • Need a refresher on keys, certificates, hashes, digital signatures, and encryption?

If that’s you, this course is for you! And as well as detailed instruction, the course also offers hands-on labs with downloadable resources, quizzes to check your learning, and a certificate on completion.

SQL Server Encryption for Developers and DBAs

Every day, companies are in the news for exposing private data. Don’t be the next statistic ! Encryption can help.

Enroll now for $295 USD !

Course Summary

Are you worried about protecting private or sensitive data?

  • Or more importantly, will you get blamed if it all goes wrong?
  • Do you understand how SQL Server encryption can help?
  • Don’t know your cell-level encryption from your Always Encrypted with Secure Enclaves?
  • Don’t know why adding a digital signature to a stored proc might be helpful?
  • Need a refresher on keys, certificates, hashes, digital signatures, and encryption?

If that’s you, this course is for you! And as well as detailed instruction, the course also offers hands-on labs with downloadable resources, quizzes to check your learning, and a certificate on completion.

SQL Server Execution Plans for Developers and DBAs

Learn to make sense of what SQL Server is doing when it’s running your queries

Enroll now for $195 USD !

Course Summary

One of the most important skills I provide when working at customer sites, is the ability to fix performance problems. And a key aspect of that is the ability to make sense of execution plans for the queries that are causing issues.

SQL Server Execution Plans for Developers and DBAs

Learn to make sense of what SQL Server is doing when it’s running your queries

Enroll now for $195 USD !

Course Summary

One of the most important skills I provide when working at customer sites, is the ability to fix performance problems. And a key aspect of that is the ability to make sense of execution plans for the queries that are causing issues.

SQL Server High Availability for Developers and DBAs

Master the skills to keep SQL Server available for users

Enroll now for $295 USD !

Course Summary

Are you ready to work with SQL Server high availability options?

Our comprehensive course is your gateway to mastering the skills needed to keep SQL Server available for users.

Ask Yourself:

  • Do you want to eliminate downtime and keep your SQL Server running 24/7?
  • Would you like to confidently design and implement failover solutions that work when it counts?
  • Do you want to understand how Always On, clustering, and log shipping actually work — and when to use each?
  • Would you like to troubleshoot high availability issues without relying solely on infrastructure teams?
  • Do you want to protect your organization from data loss during system failures or disasters?
  • Would you like to be the person that everyone turns to when uptime is on the line?

If any of these sound like you, then this course is designed to give you practical, real-world skills — fast.

SQL Server High Availability for Developers and DBAs

Master the skills to keep SQL Server available for users

Enroll now for $295 USD !

Course Summary

Are you ready to work with SQL Server high availability options?

Our comprehensive course is your gateway to mastering the skills needed to keep SQL Server available for users.

Ask Yourself:

  • Do you want to eliminate downtime and keep your SQL Server running 24/7?
  • Would you like to confidently design and implement failover solutions that work when it counts?
  • Do you want to understand how Always On, clustering, and log shipping actually work — and when to use each?
  • Would you like to troubleshoot high availability issues without relying solely on infrastructure teams?
  • Do you want to protect your organization from data loss during system failures or disasters?
  • Would you like to be the person that everyone turns to when uptime is on the line?

If any of these sound like you, then this course is designed to give you practical, real-world skills — fast.

SQL Server Indexing for Developers and DBAs

SQL Server indexes not working as expected? Learn how they really work and how to design effective ones.

Enroll now for $195 USD !

Course Summary

Need to know any of the following? Need to fix the situation fast?

  • How SQL Server indexes work
  • How to design SQL Server indexes
  • Why SQL Server seems to be ignoring the indexes that you designed
  • How data type choices affect indexes
  • If filtered indexes would work better in your application
  • How to check whether or not SQL Server “likes” your index
  • How to avoid having too many indexes
  • Which indexes you can remove

If so, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.

SQL Server Indexing for Developers and DBAs

SQL Server indexes not working as expected? Learn how they really work and how to design effective ones.

Enroll now for $195 USD !

Course Summary

Need to know any of the following? Need to fix the situation fast?

  • How SQL Server indexes work
  • How to design SQL Server indexes
  • Why SQL Server seems to be ignoring the indexes that you designed
  • How data type choices affect indexes
  • If filtered indexes would work better in your application
  • How to check whether or not SQL Server “likes” your index
  • How to avoid having too many indexes
  • Which indexes you can remove

If so, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.

SQL Server Integration Services for Developers and DBAs

Move, transform, and clean data. Combine information from multiple systems. Need to populate data warehouses? No problems.

Enroll now for $295 USD !

Course Summary

Learn to use SQL Server Integration Services effectively

  • Do you need to move data between systems?
  • Do you need to transform or clean the data?
  • Do you need to integrate data from different systems?
  • Are you assembling a data warehouse and need to populate it efficiently?
  • Would you like to learn to build Integration Services packages properly, using professional standards?
  • Have you built packages in the past but you aren’t sure if you are doing it properly?
  • You want to learn from an expert

If any of these apply to you, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.

SQL Server Integration Services for Developers and DBAs

Move, transform, and clean data. Combine information from multiple systems. Need to populate data warehouses? No problems.

Enroll now for $295 USD !

Course Summary

Learn to use SQL Server Integration Services effectively

  • Do you need to move data between systems?
  • Do you need to transform or clean the data?
  • Do you need to integrate data from different systems?
  • Are you assembling a data warehouse and need to populate it efficiently?
  • Would you like to learn to build Integration Services packages properly, using professional standards?
  • Have you built packages in the past but you aren’t sure if you are doing it properly?
  • You want to learn from an expert

If any of these apply to you, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.