9090 подписчиков
21 видео
From Excel to SQL - Introduction and setting the context
From Excel to SQL - Getting Data (SELECT and FROM)
From Excel to SQL - Filtering Data (WHERE)
From Excel to SQL - Sorting Data (ORDER BY)
From Excel to SQL - Comments (-- and /**/)
From Excel to SQL - Top Rows, Distinct Rows (TOP and DISTINCT)
From Excel to SQL - Data Types (CHAR, INT, DATE)
From Excel to SQL - Operators (+, -, *, /)
From Excel to SQL - Conditionals (IIF and CASE)
From Excel to SQL - Date Formatting (FORMAT)
From Excel to SQL - Aggregations (GROUP BY)
From Excel to SQL - Pivot Tables (ROLLUP)
SQL SEMI and ANTI Joins
