Azure Data Explorer - Turn SQL to KQL In Seconds!!! скачать в хорошем качестве

Azure Data Explorer - Turn SQL to KQL In Seconds!!!

‪@SQLBalls‬ walks you through how to turn your T-SQL Statements into KQL in seconds using the EXPLAIN command. We use the Retrosheets.org baseball dataset to determin the number of Triple Plays that have occcured from 1922 to 2016. Why just 2016? That's the last time the Cub won the World Series! Links: RetroSheet.org https://www.retrosheet.org/ Query data using T-SQL https://learn.microsoft.com/en-us/azu... Chapters 00:00 Introduction 00:15 About the Channel 00:41 Content to cover 02:12 TO THE DEMO 03:18 Explain & Select Count(*) 04:32 Home Team & Away Team info 05:06 Create a Table Based off a Query 06:09 Union Command 07:23 Sum() & Group By 07:51 What Is a Triple Play 08:11 Creating Final Table 08:47 Self Join Cast to Decimal & Create a Percentage 09:34 Wrap it Up