Writing SQL Queries for DuckDB

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

• You know that the information that you need is stored in a DuckDB 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, Looker, or Access and need to get data from DuckDB
• You are creating applications using DuckDB
• 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 DuckDB

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

• You know that the information that you need is stored in a DuckDB 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, Looker, or Access and need to get data from DuckDB
• You are creating applications using DuckDB
• 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.

Implementing Zero-ETL with Microsoft Fabric Mirroring

Design, Configure, Monitor, and Use Mirrored Data for Analytics in Microsoft Fabric !

Enroll now for $195 USD !

Course Summary

Do you want to start working with mirroring in Microsoft Fabric?

This course focuses on the architecture, design decisions, and practical implementation patterns involved in using database and metadata mirroring in Fabric. This course is about understanding how mirroring works in Fabric, when to use it, how to set it up, and how to work with mirrored data effectively.

Implementing Zero-ETL with Microsoft Fabric Mirroring

Design, Configure, Monitor, and Use Mirrored Data for Analytics in Microsoft Fabric !

Enroll now for $195 USD !

Course Summary

Do you want to start working with mirroring in Microsoft Fabric?

This course focuses on the architecture, design decisions, and practical implementation patterns involved in using database and metadata mirroring in Fabric. This course is about understanding how mirroring works in Fabric, when to use it, how to set it up, and how to work with mirrored data effectively.