Write SQL queries to extract and transform data: Grouping, ordering, sorting, collapsing, joins and aggregating;
Use string, math and date functions to manipulate data contained within tables;
Use server specific functions to navigate database information tables;
Define different data types;
Basic efficiency: understand query performance and how to increase efficiency;
Use large-query best practices to write maintainable, easy-to-read queries.