SQL Server 2012 Reporting Services Development and Administration BISS-001

Course Code BISS-001
Course Name SQL Server 2012 Reporting Services Development and Administration
Description The SQL Server 2012 Reporting Services Development and Administration course will teach you how to create data-rich reports using Microsoft's server-based reporting solution. It will also serve as preparation for exam 70-466 (Implementing Data Models and Reports with Microsoft SQL Server 2012).

Consisting of lectures, demonstrations and group exercises, this offering will delve into topics such as data access and report design, managing report execution and subscriptions, implementing custom report items, extending data access and customizing security.

Due to its focus, the course will be suitable if you are or have a desire to be a business intelligence developer, architect or analyst, data analyst, software developer, database administrator or a professional who develops and deploys reports using MS SQL Server Reporting Services.

Upon successful completion of SQL Server 2012 Reporting Services Development and Administration, you will be able to:

• Install, configure and customize SQL Server 2008 Reporting Services;
• Create SELECT queries to extract data;
• Generate reports from the Report Wizard and from scratch;
• Add charts, images and gauges;
• Build reusable report templates;
• Use the new Tablix data format to create reports with any structure;
• Export reports to Word, Excel, PDF, HTML, XML and other formats;
• Enable end-user access to reports via the Report Server and its Report Manager web interface;
• Describe SQL Server Reporting Services and its components;
• Create and 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.
Notes This course is offered in-class.

For in-class please email infotech.PT@centennialcollege.ca or call 416-289-5000 x2267
Contact Telephone 416-289-5207
Contact E-mail ce@centennialcollege.ca
Associated Certificates
Register Online https://secure.centennialcollege.ca/webreg
Section Cost Semester Start Date End Date Meeting Times Campus
801 $459.00 Fall 2018 2018-09-22 2018-10-20
Times Days
09:00 AM to 12:00 PM S
12:30 PM to 03:30 PM S
Progress Campus
Legend for Days
M - Monday T - Tuesday W - Wednesday R - Thursday F - Friday S - Saturday U - Sunday
TBA - To Be Announced