3 Etl Cheat Sheets

Summarizing the key SQL statements Missing data: WHERE IS NOT NULL WHERE IS NULL COUNT(*) GROUP BY ORDER BY String Functions: SUBSTRING(), LTRIM(), RTRIM(), LEFT(), RIGHT(), CHARINDEX(), LEN(), ISNUMERIC(), ISDATE() Set Operations EXCEPT­/MINUS INTERSECT UNION Dropping Duplicates row_number() OVER ( PARTITION BY WHERE > 1 Replace Through Regular Expressions CASE with LIKE

30 Sep 22

sql, database, data, etl