Advanced T-SQL for Developers and DBAs

Take your T-SQL skills to the next level

Enroll now for $295 USD !

Course Summary

• Have you been working with T-SQL for a while but not sure you’re using it well?
• Do you think there are probably simpler ways to write your T-SQL queries?
• Do your queries look awkward and not have the elegance that other people’s queries seem to have?
• Do you know the basics but think it’s time to extend your knowledge?
• Do 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.

Advanced T-SQL for Developers and DBAs

Take your T-SQL skills to the next level

Enroll now for $295 USD !

Course Summary

• Have you been working with T-SQL for a while but not sure you’re using it well?
• Do you think there are probably simpler ways to write your T-SQL queries?
• Do your queries look awkward and not have the elegance that other people’s queries seem to have?
• Do you know the basics but think it’s time to extend your knowledge?
• Do 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.

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.

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.

Designing Semantics with Microsoft Fabric IQ

Design meaning once, and reuse it everywhere, by using semantic models in Fabric IQ !

Enroll now for $195 USD !

Course Summary

Do you want to get working with semantic models in Microsoft Fabric IQ ?

As Fabric IQ is in preview, the focus of this course is on semantic design decisions that remain valid, even as the tools, interfaces, and features evolve. It does not aim to walk through every UI option or provide beginner-level Fabric training.

Designing Semantics with Microsoft Fabric IQ

Design meaning once, and reuse it everywhere, by using semantic models in Fabric IQ !

Enroll now for $195 USD !

Course Summary

Do you want to get working with semantic models in Microsoft Fabric IQ ?

As Fabric IQ is in preview, the focus of this course is on semantic design decisions that remain valid, even as the tools, interfaces, and features evolve. It does not aim to walk through every UI option or provide beginner-level Fabric training.