Adding data leveraging cross joins

A woman working on a computer.

Learn how to quickly assign full schedules to all employees using SQL cross joins. In this Data Survival Skills session, Robin demonstrates how to create two tables—one for employees and one for schedules—and use a cross join to generate every possible combination. She shows how to execute the scripts in SQL Server, verify the results,…

Read More

Using Case statements for conditional logic in SQL queries

A woman working on a computer.

Learn how to uncover booking trends with SQL and Excel. Every business wants to know when customers commit—are they booking last-minute or months in advance? In this Data Survival Skills session, Robin shows how to use SQL case statements to group bookings into bands like 0–45 days, 46–90 days, and 180+ days. By transforming raw…

Read More