Microsoft SQL Server 2008 Reporting Services Business Intelligence Skills for MCTS 70-448 and MCITP 70-452 Video Mentor

D. J. Henry (Autor)

Media-Kombination

80 Seiten

2010
Pearson IT Certification
978-0-7897-4319-0 (ISBN)

Infos

Using Microsoft SQL Server 2008 Reporting Services (SSRS), thousands of businesses are capturing more timely insights for more effective action. To succeed with SSRS, businesses need professionals who've mastered this technology. Thousands of these professionals are seeking to demonstrate their expertise by passing one of Microsoft's new SSRS exams: MCTS 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance or MCITP: Business Intelligence Developer 2008 70-452. In 4+ hours of personal, interactive video mentoring, leading SQL Server trainer Wendy Henry walks you through all the Reporting Services tasks and concepts you need to plan an SSRS environment, implement and manage SSRS, and design and develop successful reporting solutions with SSRS Report Designer and Report Builder. Henry combines audio instruction, step-by-step screencasts, and more: everything you need to fully understand the tasks you're watching. There's never been a more efficient, cost-effective, compelling SQL Server 2008 Reporting Services training solution.

Autor

Wendy Henry is an independent technical trainer, presenter, author, and consultant to various Fortune 500 companies regarding Microsoft network architecture and integration. She delivers technical training for various providers around the world, and is contributing partner on SharePoint-eLearning.com. She has more than 17 years’ experience in the IT industry, and has been a Microsoft Certified Trainer (MCT) since 1998. Her certifications include Microsoft MCP, MCDST, MCSA, MCSE, MCDBA, MCTS, MCITP, and MCT; Novell CNE and CNI; Cisco CUSE and CCNA; and CompTIA A+, Net+, and Server+.

Inhalt

I.          Implementing and Managing SQL Server 2008 Reporting Services

a.         Lab 1:  Install and Configure SSRS

i.          Pre-Installation Checklist (min req's, editions, etc.)

ii.          Install SSRS in non-clustered environment then a clustered environment

iii.         Configuring Logging, Storage & Security

iv.         Configuring Infrastructure (Internet deployment, My Reports)

v.         Configuring Instances via Reporting Services Configuration Tool (Rsconfig.exe)

vi.         Maintaining Instances via Reporting Services Web Services Library

b.         Lab 2:  SSRS Solution Management

i.          Managing SSRS Reports Using Report Manager (data sources, creds, properties, linked reports)

ii.          Deploying SSRS Report Solutions (BIDS, Report Builder, Report Server Catalog)

c.         Lab 3:  Secure and Schedule SSRS Reports

i.          Implementing Security on a SSRS Solution

ii.          Subscribing to a SSRS Report (delivery options, rendering format, data-driven)

iii.         Scheduling a SSRS Report (shared vs report-specific, on-demand, caching, snapshots)

 

II.         Developing Reporting Solutions in SQL Server 2008 Reporting Services

a.         Lab 1:  Create Reports

i.          Creating Reports (Report Wiz vs Report Designer vs manual XML authoring)

ii.          Designing Reports (report properties, page layout, headers/footers)

iii.         Creating a Report Model for Report Builder (Model Designer vs Report Mgr)

iv.         Importing Data Source Views into a Report Model Project

b.         Lab 2:  Define and Display Report Data

i.          Create Datasets (CommandType, multidim, parameterized queries)

ii.          Display Datasets in Data Regions (filters, group/sort, nesting, aggregates)

iii.         Control Data by Applying Parameters (data types, defaults, bind, dynamics)

iv.         Include Data using Sub Reports (business logic)

c.         Lab 3:  Monitor and Maintain SSAS

i.          Extend a Report by Using Expressions (embedded functions & assemblies)

ii.          Apply Formatting and Style (dynamic format expressions, static formatting)

iii.         Configure Report Navigation Options (visibility, drilldown, drillthrough, URL)

Produkt-Details

• Erscheint lt. Verlag: 28.11.2010
• Verlagsort: Upper Saddle River
• Sprache: englisch
• Maße: 159 x 232 mm
• Themenwelt: Informatik ► Datenbanken ► SQL Server
• ISBN-10: 0-7897-4319-1 / 0789743191
• ISBN-13: 978-0-7897-4319-0 / 9780789743190
• Zustand: Neuware