Course Catalog > Microsoft Windows Technology > Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
MS-6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
MS-6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
This three-day MS-6236 Implementing and Maintaining
Microsoft SQL Server 2008 Reporting Services instructor-led course teaches students how to implement
a Reporting Services solution in an organization. The course discusses
how to use the Reporting Services development tools to create reports,
and how to use the Reporting Services management and administrative tools
to manage a Reporting Services solution.
Intended Audience
- IT Professionals, IT generalists, and help desk professionals who want to learn about SQL Server 2008 are the audience for this course.
- This Certification provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2008 database.
- This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services
The CTCLC Difference
Current Technologies Computer Learning Center uses our own Microsoft Certified Trainers that will help guide you to a sucessful completion of your Microsoft training and certification. Our Instructors are simply the best instructors you will find and have been certified and teaching Windows since Windows NT. Let our great instructors help you get started in understanding and using your Microsoft Technologies. CTCLC has convenient day or night schedules to fit your needs. We can also do onsite classes with our top notch portable labs.
Our instructors are the very best and give 110% to their Students. We care about every student that we train and we have a Free Resit Policy for all of our courses for the same revision. You will not find a better training experience anywhere. Come Experience the Current Technologies Computer Learning Center Way of training. We take great care of all of our students.
Current Technologies Computer Learning Center is Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Learning Alliance Member, EC-Council Accredited Training Center, and many others. We offer the highest quality, authorized training that you will find anywhere.
Prerequisites
Before attending this course, students must have:
- Conceptual understanding of OLAP solutions.
- Experience navigating the Microsoft Windows Server environment.
- Experience with Windows services (starting and stopping).
- Experience creating service accounts and permissions.
- Experience with Microsoft SQL Server, including:
- SQL Server Agent.
- SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
- SQL Server System tables.
- SQL Server accounts (users and permissions).
At Course Completion
After completing this course, students will be able to:
- Describe SQL Server Reporting Services and its components
- Create a Reporting Services report
- Enhance a Reporting Services report
- Create and manipulate data sets
- Use report models to implement reporting for business users
- Configure report publishing and execution settings
- Implement subscriptions for reports
- Administer Reporting Services
- Implement custom Reporting Services applications
Course Duration
- 3 Days
Redeem Your Microsoft Software Assurance Training Vouchers
 |
As a Microsoft Gold Learning Solutions Partner, Current Technologies CLC proudly accepts Microsoft Software Assurance Training Vouchers (SATV). You can attend Microsoft training at Current Technologies CLC for free, by redeeming your Microsoft vouchers. Call (219) 764-3800 for more information. |
CTCLC Special Discounts
Implementing and Maintaining Microsoft SQL Server2008 Analysis Services (3 days) $1,495.00
MS-6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (3 days) $1,495.00
MS-6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (3 days) $1,495.00
List Price
$4,990.00
Special package price (all 3 Classes)
$4,200.00
Special package Student price (2 or More from Same Company)
$3,895.00
For more Information on Microsoft SQL Server 2008 or to Register:
EMail: Sales@ctclc.com
Phone: (219) 764-3800
MS-6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
- Introduction to Microsoft SQL Server Reporting Services
- Authoring Basic Reports
- Enhancing Basic Reports
- Manipulating Data Sets
- Using Report Models
- Publishing and Executing Reports
- Using Subscriptions to Distribute Reports
- Administering Reporting Services
- Programming Reporting Services
Module 1: Introduction to Microsoft SQL Server Reporting Services
- Overview of SQL Server Reporting Services
- Installing Reporting Services
- Reporting Services Tools
- Lab: Introduction to Micros6435descoft SQL Server Reporting Services
- Describe the features of SQL Server Reporting Services.
- Install Reporting Services.
- Describe the Reporting Services tools.
Module 2: Authoring Basic Reports
- Creating a Basic Table Report
- Formatting Report Pages
- Calculating Values
- Lab: Authoring Basic Reports
- Create a basic table report.
- Format report pages.
- Calculate values for a report.
Module 3: Enhancing Basic Reports
- Interactive Navigation
- Displaying Data
- Lab: Enhancing Basic Reports
- Create reports with interactive navigation.
- Display data in various formats.
Module 4: Manipulating Data Sets
- Defining Report Data
- Using Parameters and Filters
- Using Parameter Lists
- Lab: Manipulating Data Sets
- Define report data.
- Use parameters and filters.
- Use parameter lists.
Module 5: Using Report Models
- Creating Report Models
- Using Report Builder
- Lab: Using Report Models
- Create Report Models.
- Use Report Builder.
Module 6: Publishing and Executing Reports
- Publishing Reports
- Executing Reports
- Creating Cached Instances
- Creating Snapshots and Report History
- Lab: Publishing and Executing Reports
- Publish reports.
- Execute reports.
- Create cached instances.
- Create snapshots and report history.
Module 7: Using Subscriptions to Distribute Reports
- Introduction to Report Subscriptions
- Creating Report Subscriptions
- Managing Report Subscriptions
- Lab: Using Subscriptions to Distribute Reports
- Describe report subscriptions.
- Create report subscriptions.
- Manage report subscriptions.
Module 8: Administering Reporting Services
- Reporting Server Administration
- Performance and Reliability Monitoring
- Administering Report Server Databases
- Security Administration
- Upgrading to Reporting Services 2008
- Lab: Administering Reporting Services
- Administer the reporting server.
- Monitor performance and reliability.
- Administer the Report Server databases.
- Administer security.
- Upgrade to Reporting Services 2008.
Module 9: Programming Reporting Services
- Querying for Server Information Using a Web Service
- Automating Report Management
- Rendering Reports
- Creating Custom Code
- Lab: Programming Reporting Services
- Query server information using a Web service.
- Automate report management.
- Render reports.
- Create custom code.
CTCLC SQL Server Certification Path
| SQL Server Certification Paths | ||||
Based on Microsoft Technology  |
 |
 |
 |
|
Version 2008 |
||||
 |
MCTS: SQL Server 2008 Installation & Maintenance | |
MCITP: Database Administrator 2008 | |
|
MCTS: SQL Server 2008 Database Development | |
MCITP: Database Developer 2008 | |
|
MCTS: SQL Server 2008 Business Intelligence Development and Maintenance | |
MCITP: Business Intelligence Developer 2008 |
|
Version 2005 |
||||
 |
MCTS: SQL Server 2005 |
|
MCITP: Database Administrator 2005 |
|
|
MCITP: Database Developer 2005 |
|||
Registration Information
For more Information on Microsoft SQL Server 2008 or to Register:
EMail: Sales@ctclc.com
Phone: (219) 764-3800