Azure SQL Video
10 page views
1423 video views
2025, February 09, Sunday

#119 Turn Categorical Variables to Event Logging in Azure SQL Server

In this video we present how to convert categorical variables to numeric variables to develop event log data analysis using Azure SQL Database.

We will know the techniques:
🔹Retrieve table records (SELECT, FROM)
🔹Categorical variables (CONCEPT, KHAN ACADEMY);
🔹 Use of Common Table Expression (CTE);
🔹Get maximum value per categorical conditional (MAX, CASE);
🔹Obtain record count by categorical conditional (MAX, CASE);
🔹Combine two tables (RIGHT JOIN);
🔹Format the Date data type (CONVERT, VARCHAR, DATE STYLE);
🔹Calculate number of days between dates (DATEDIFF, DAY)Calculate and convert integer values to decimals (CONVERT, NUMERIC, PRECISION, DECIMAL)
🔹