Writing SQL Queries for Db2

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

Course Summary

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

You know that the information that you need is stored in a Db2 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 Db2
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 Db2

Creating reports, analytics, or applications? And need to get data out of Db2? 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 Db2?

You know that the information that you need is stored in a Db2 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 Db2
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.

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.