SQL: A Quick Review

• Joins and Unions
• Aggregate Functions (GROUP BY)
• Window Functions
• What’s so great about them anyways? (See next slide)
• Indexes & Query Plans Must-know general knowledge, but we will not test this

Window Functions

• What limitations have you faced in your analytics when using GROUP BY in the past?
• How can you do rankings per each category efficiently?
• How can you get the entire row of the best-selling product? (imagine you want to see additional attributes of this product)