YOU WILL LEARN TO
Learn the key difference between queries using GROUP BY and those which incorporate window functions to summarize values.
Traditional SQL limits you to summarizing to a single GROUP BY. I'll show you how to add multiple summaries while avoiding complex SQL.
I'll show how you can use modern SQL techniques to identify duplicate values.
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."
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.
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.