Azure SQL Video
10 page views
1297 video views
2024, April 24, Wednesday

Transform Categorical Variables into Event Log 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)
🔹