SQL Server: Writing SQL Queries for Report Authors
| Course Code: | SQSDML |
| Currency: | SQL Server 2005, 2008 and 2008 R2 |
| Level: | Beginner |
| Duration: | 2 days |
| Audience: | Report authors, report developers, data and business analysts. |
| Prerequisites: | Windows operating system literacy. |
| Summary: | Report authors need to be able to extract data from a variety of
data sources including relational databases. Although using the
Query Designer can facilitate building datasets, gaining an
understanding of SQL constructs will enable report authors to
code queries that retrieve the required data as efficiently as
possible. This hands-on workshop uses mainly examples to elaborate on the following SQL features:
|
| Objectives: | Upon completion of this course, delegates should be able build queries from scratch as well as using the Query Designer to satisfy various end-user Reporting Services requirements. |
| Format: | Hands-on 70%, lecture 30% |
 Detailed Outline |
|
Course Outlines
Detailed course outlines are available in PDF format.
Download Adobe's Acrobat Reader free from:
www.adobe.com
