Course Catalog > Microsoft Windows Technology> Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
MS-6235 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
MS-6235 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services


This three-day MS-6235 Implementing and Maintaining
Microsoft SQL Server 2008 Reporting Services instructor-led course teaches students how to implement
an Integration Services solution in an organization. The course discusses
how to develop, deploy, and manage Integration Services packages..
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. It is intended for IT Professionals wanting to become skilled on SQL Server 2008 product features and technologies for maintaining a database.
- It also provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 Business Intelligence. It is intended for IT Professionals who want to become skilled on SQL Server 2008 product features and technologies.
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 Integration Services and its tools
- Create an Integration Services package
- Implement control flow in an Integration Services package
- Implement data flow in an Integration Services package
- Implement logging in an Integration Services package
- Debug and implement error handling in an Integration Services package
- Implement checkpoints and transactions in an Integration Services package
- Deploy an Integration Services package
- Manage and secure an Integration Services package
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 $1,495.00
MS-6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services $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
Course Outline
MS-6235 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
- Introduction to SQL Server 2008 Integration Services
- Developing Integration Services Solutions
- Implementing Control Flow
- Implementing Data Flow
- Implementing Logging
- Debugging and Error Handling
- Implementing Checkpoints and Transactions
- Configuring and Deploying Packages
- Managing and Securing Packages
Module 1: Introduction to SQL Server 2008 Integration Services
- Overview of SQL Server Integration Services
- Using Integration Services Tools
- Lab : Introduction to SQL Server Integration Services
- Describe Integration Services solutions.
- Use Integration Services tools.
Module 2: Developing Integration Services Solutions
- Creating an Integration Services Solution
- Using Variables
- Building and Running a Solution
- Lab : Developing Integration Services Solutions
- Create a SQL Server Integration Services solution.
- Use variables.
- Build and run a solution.
Module 3: Implementing Control Flow
- Control Flow Tasks
- Control Flow Precedent Constraints
- Control Flow Containers
- Lab : Implementing Control Flow
- Configure control flow tasks.
- Configure control flow precedence constraints.
- Configure control flow containers.
Module 4: Implementing Data Flow
- Data Flow Sources and Destinations
- Basic Data Flow Transformations
- Advanced Data Flow Transformations
- Data Flow Paths
- Lab : Implementing Data Flow
- Implement data flow sources and destinations.
- Implement basic data flow transformations.
- Implement advanced data flow transformations.
- Implement data flow paths.
Module 5: Implementing Logging
- Overview of Integration Services Logging
- Using Logging
- Lab : Implementing Logging
- Describe Integration Services logging.
- Implement Integration Services logging.
Module 6: Debugging and Error Handling
- Debugging a Package
- Implementing Error Handling
- Lab : Debugging and Error Handling
- Debug an SSIS package.
- Implement error handling.
Module 7: Implementing Checkpoints and Transactions
- Implementing Checkpoints
- Implementing Transactions
- Lab : Implementing Checkpoints and Transactions
- Implement checkpoints.
- Implement transactions.
Module 8: Configuring and Deploying Packages
- Package Configurations
- Preparing and Deploying Packages
- Lab : Configuring and Deploying Packages
- Implement package configurations.
- Deploy packages.
Module 9: Managing and Securing Packages
- Managing Packages
- Securing Packages
- Lab : Managing and Securing Packages
- Manage packages.
- Secure packages.
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






