Online Course: SQL Server Architectures and Development for Reporting Services

Course Overview

This course is designed for software developers, architects and their managers who specify, design, code, assemble, test, deploy, support, update and live with business applications that manage SQL Server data or develop Business Intelligence solutions targeting Reporting Services

Sessions

Session 1 – SQL Foundations –

1. Understanding the SQL Server service
2. Understanding the Query Optimizer
3. Understanding the support tools
4. Managing Users and Rights

Session 2 – Reporting Services Foundations –

1. Understanding Reporting Services
2. Managing Data Sources 3. Building Business Intelligence Solutions
4. Creating and Managing Report Subscriptions
5. Managing Users, Groups and Rights

Session 03 – Report Tools Foundations –

1. Installing and Configuring the Report Builder ans SQL Server Data Tools
2. Building New Reports from Scratch
3. Leveraging Existing Reports
4. Specifying and Capturing Parameters
5. Saving reports

Session 04 – Report Design Foundations –

1. Understanding Report Designs
2. Accessing Data Sources
3. Understanding Report Elements
4. Understanding Data Regions
5. Understanding Report Layout

Session 05 – Reporting: Advanced Topics –

1. Installing and Configuring Reporting Services Preparing the Development Server and Workstation
2. Managing complex projects
3. Specifying and Capturing Parameters
4. Managing Code-driven Expressions
5. Other Advanced Techniques

Session 06 – Report Viewer Control –

1. Exploring the ReportViewer Class
2. Managing Local and Server-side Reports
3. Managing Parameters
4. Creating Click-Through Reports
5. Implementing Code-behind

Speaker

William Vaughn has been a storyteller from a very early age—perhaps from the time he had to explain why he was presenting his mom with a bunch of her prized tulips. More recently, his furtive imagination spawned The Seldith Chronicles, a series of young adult books that follow the lives, exploits and challenges of a clan of forest elves no taller than a mushroom who, live in the local forests. In the fall of 2014, William published The Timkers, a new adult novel that follows Sam, a troubled young man running from the police only to find himself transported to 1930 where he meets the love of his life—and has to leave her behind.

Before his fantasy writing career began, William travelled the world as an Army brat and then as a technical speaker, mentor and award-winning technical author known the world-over. He has worked in the technical arena for over forty years, principally focusing on SQL Server, Reporting Services and Visual Basic. He’s written over a dozen books and contributed to a like number on these subjects. He settled in Redmond, Washington at the edge of a forest teeming with story ideas and within artillery-range of Microsoft to keep them honest.