Save On Training Technical Help
 
866.762.3990
Certification
Server Technologies
Microsoft Server

MS SQL Server

SQL Server 2000
2030
2071
2072
2073
2074
2092
2093
2591
SQL Server 2005
2779
2780
2781
2782
2783
2784
2786
MS SQL Server Support

MS Sharepoint

Microsoft Exchange

Network Technologies
Accounting Software
Multimedia Software
Office Software
Save On Support
Accounting Software
Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services
Course 2030-Two days-Instructor-led
Introduction


Duration: 2 Days.

Prerequisites:
Before attending this course, students must have:

  • MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge
  • Exposure to Visual Studio .NET
  • Exposure to creating reports in Microsoft Access or third party reporting products
  • Experience navigating the Microsoft Windows Server environment
  • Experience with Microsoft Windows services
  • Starting and stopping services
  • Creating service accounts and permissions

Course Description:
This course provides students with the knowledge and skills to author, deploy, and manage reports using Microsoft Reporting Services. Students should leave the course with a good understanding of how to apply reporting services to problems within a business context

Objectives:
  • Understand the architecture of Microsoft Reporting Services and Office integration
  • Author reports using the Report Designer
  • Deploy and publish reports
  • Manage the lifecycle of a report including report scheduling and backup and restore
  • Understand how to apply Reporting Services to a business problem
Live chat by SightMax
Additional Training Courses at SOT


Sharepoint 2007 Logo

Server 2003 Logo

Exchange Server


Why SOT?
Quality
Price
Service

Course Outline

Lesson 1: Introduction to Microsoft SQL Server Reporting Services

  • Overview of Microsoft SQL Server Reporting Services
  • Tour of Reporting Services
  • Overview of Reporting Services Architecture

Lesson 2: Authoring Basic Reports

  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values

Lesson 3: Enhancing Basic Reports

  • Interactive Navigation
  • Displaying Data

Lesson 4: Manipulating Data Sets

  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists

Lesson 5: Managing Content

  • Publishing Content
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History
  • Creating Report Subscriptions

Lesson 6: Administering Reporting Services

  • Server Administration
  • Performance and Reliability Monitoring
  • Database Administration
  • Security Administration

Lesson 7: Programming Reporting Services

  • Querying Server Information
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code

Home | About Us | Privacy Policy | Resources | Contact | Resource Sites
| (866) 762-3990 |
Copyright © 2009 saveontraining.com™