Home > Technical General > SQL for the Windows Environment Online Class > SQL for the Windows Environment: Groups and Queries Online Class

SQL for the Windows Environment: Groups and Queries Online Class

SQL for the Windows Environment Online Class
Order Information
Item # sqlwin
Price$85.00
Series Price$64.99 - You Save 24%
Qty



This course explains how to use the GROUP BY and ORDER BY clauses to sort and group data. It also explains how to use subqueries and combined queries to add more options to retrievals using the SQL SELECT statement.



Create data groups using the GROUP BY clause

Sort and filter grouped data

Understand and filter subqueries

Use subqueries as calculated fields

Create combined queries using UNION


Topics:
Understanding data grouping

Creating groups

Filtering groups

Grouping and sorting

Understanding and filtering subqueries

Using subqueries as calculated fields

Creating combined queries

Advanced UNION features


Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Total Time: 2.0 hour(s)

Subscription Time (total time to complete): 12 Months

You May Also Like

SQL for the Windows Environment: Groups and Queries Online Class