Learn how to use functions in Transact-SQL, and how to group aggregated results.
After completing this module, you will be able to:
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
Before starting this module, you should have experience of using Transact-SQL SELECT queries to retrieve data from tables in a database.