Published on HiTech Institute (http://www.htinstitute.com)

Home > Grouping and Summarizing Data in Microsoft SQL Server 2008 (E-Learning)

Grouping and Summarizing Data in Microsoft SQL Server 2008 (E-Learning)

Vendor: 
Microsoft [1]
Subject: 
Database [2]
Overview: 

Length:2.00 hours - Excluding labs and assessments
Published:Sep 01, 2009
Language:English
Audiences:IT Professional
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents: 

In this 2 hour course the students group and summarize data to generate reports by using aggregate functions, the Group By clause, Grouping Sets, the ranking and Pivot clause.

Topics covered in the courses within the course Include:
Introduction to aggregate functions.
Using the GROUP BY clause.
Using the GROUPING SETS clauses
Using the TOP N and RANKING clause.
Creating cross-tabulation reports by using the PIVOT and UNPIVOT clauses.
This course also helps prepare you for exam: 70-432: Microsoft SQL Server 2008, Implementation and Maintenance and 70-433: Microsoft SQL Server 2008, Database Development.

This course has the same content as the previous version in an updated viewer with a new look and feel.

Objective: 

Summarize data by using aggregate functions.
Summarize grouped data by using the GROUP BY clause.
Summarize grouped data by using the GROUPING SETS clauses Rank your data using the TOP N and RANKING clause.
Create cross-tabulation reports by using the PIVOT and UNPIVOT clauses..

Prerequisites: 

None

Business Analysis (BA)

Business Analysis (IIBA) Courses
About IIBA
CBAP Certification
CCBA Certification
Business Analysis Certification Benefits
Business Analysis Training at HiTech Institute

-->

Source URL: http://www.htinstitute.com/courses/grouping-and-summarizing-data-in-microsoft-sql-server-2008-e-learning

Links:
[1] http://www.htinstitute.com/vendors/microsoft
[2] http://www.htinstitute.com/htnteam/database