This course covers group function fundamentals including the use of aggregate functions such as GROUP BY and HAVING. It also addresses creating superaggregates and nesting functions.
Objectives:
Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude the grouped rows by using the HAVING clause
Topics:
Using Group Functions
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
