Courses

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.

SQL Server Locking, Blocking and Deadlocks for Developers and DBAs

Learn to find and fix locking issues, and to avoid them in the first place.

Enroll now for $195 USD !

Course Summary

Are you grappling with issues related to SQL Server or Azure SQL Database? Do you find yourself dealing with what you think are blocking problems, but aren’t quite sure what’s actually going wrong?

SQL Server Locking, Blocking and Deadlocks for Developers and DBAs

Learn to find and fix locking issues, and to avoid them in the first place.

Enroll now for $195 USD !

Course Summary

Are you grappling with issues related to SQL Server or Azure SQL Database? Do you find yourself dealing with what you think are blocking problems, but aren’t quite sure what’s actually going wrong?

Writing SQL Queries for MySQL™

Creating reports, analytics, or applications? And need to get data out of MySQL? Learn to write SQL queries like a pro !

Enroll now for $95 USD !

Course Summary

Do you need to learn how to write SQL queries for MySQL?

  • You know that the information that you need is stored in a MySQL database
  • You need to find some data to extract it
  • You need to create reports with reporting tools
  • You are using analytic tools like Power BI, Tableau, QlikView, Excel, or Access and need to get data from MySQL
  • You are building PHP or WordPress applications that depend upon MySQL databases
  • You want to learn to write queries properly, using commercial coding standards
  • You are new to writing queries, or you are self-taught and want to make sure you are doing it correctly

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.

Writing SQL Queries for MySQL™

Creating reports, analytics, or applications? And need to get data out of MySQL? Learn to write SQL queries like a pro !

Enroll now for $95 USD !

Course Summary

Do you need to learn how to write SQL queries for MySQL?

  • You know that the information that you need is stored in a MySQL database
  • You need to find some data to extract it
  • You need to create reports with reporting tools
  • You are using analytic tools like Power BI, Tableau, QlikView, Excel, or Access and need to get data from MySQL
  • You are building PHP or WordPress applications that depend upon MySQL databases
  • You want to learn to write queries properly, using commercial coding standards
  • You are new to writing queries, or you are self-taught and want to make sure you are doing it correctly

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.