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.