NEW MASTERCLASS
How to do More with SQL
(And Keep your Query Simple)
In This Masterclass
YOU WILL LEARN TO
1
To Know The Difference Between Aggregate and Windows Functions
Learn the key difference between queries using GROUP BY and those which incorporate window functions to summarize values.
2
Learn How to Incorporate Multiple Summaries into a Single Result
Traditional SQL limits you to summarizing to a single GROUP BY. I'll show you how to add multiple summaries while avoiding complex SQL.
3
Identify Duplicate Values
I'll show how you can use modern SQL techniques to identify duplicate values.
4
Bend the Rules
Some of the techniques I'll show you work well enough displaying and sorting data, but not so good to filter data. But all is not lost, never with SQL! I'll show how to work around these "limitations."
"All I can say is thank you, Kris. You have just elaborated and explained this concept in a way so easy to understand that I will use this explanation for my Jr. DBA at work and my students at Valencia College."
JUAN GALAARZA
DBA Instructor
Can you imagine writing queries without SQL getting in your way?
Whether you feel you've got the basics down and want to learn more SQL, or you've hit a wall learning SQL, I've got your back.
I have a knack for breaking down complicated concepts into easy-to-understand bits. I'd love to show you what I mean.
Join me to finally learn what it takes to Level-up your SQL.
A Note From The Instructor...
I personally cannot wait to have you join my master class. I’m so excited to share with you my approach to learning SQL. I'm holding this webinar for you because I really want to see you succeed in learning SQL.
I started using SQL in 1989. Today is it more popular than ever.
SQL has helped me advance my career. Over the years I’ve taken on several roles, from Software Developer to IT Manager. Throughout my journey one thing is constant – SQL is the tool of choice to query databases.
Whether you’re a working business analyst or software developer, this master class is for you. I’m really looking forward to helping level up your SQL.
