Content Deep Dive
SQL Essentials: Part 2
Blog post from Fivetran
Post Details
Company
Date Published
Author
Michael O'Toole
Word Count
2,535
Language
English
Hacker News Points
-
Source URL
Summary
In Part 2 of SQL Essentials, we discuss advanced SQL functions such as CASE shortening, exclusivity and order, using LIKE better, summing booleans, use window functions to deduplicate, ignoring NULLS in a window function, marking past events, and knowing your dialects. These topics cover various techniques for handling structured data more efficiently and effectively.