Analysis Services for Data Professionals

Learn to create user-friendly analytic models with SQL Server Analysis Services and Azure Analysis Services

Unlock your potential with Analysis Services!

Course Summary

Are you ready to elevate your skills in working with Analysis Services?

Our comprehensive course is your gateway to becoming proficient at working with both SQL Server Analysis Services, and with Azure Analysis Services. Ask Yourself:

Analysis Services for Data Professionals

Learn to create user-friendly analytic models with SQL Server Analysis Services and Azure Analysis Services

Enroll now for $295 USD !

Unlock your potential with Analysis Services!

Course Summary

Are you ready to elevate your skills in working with Analysis Services?

Our comprehensive course is your gateway to becoming proficient at working with both SQL Server Analysis Services, and with Azure Analysis Services. Ask Yourself:

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.