Learn SQL Reporting Services Beginning Report Training

Course Curriculum

Chapter 1: Module #1: Foundation

Lecture 1: Foundation #1 – Getting Started

Lecture 2: Learning Outline

Lecture 3: Training Slideshow

Lecture 4: Foundation #2 – Installing Tools

Lecture 5: Foundation #2a – Installing SQL Server Developer Edition

Lecture 6: Foundation #2b – Installing SQL Server Management Studio

Lecture 7: Foundation #2c – Installing Visual Studio for SQL Server Reporting Services

Lecture 8: Foundation #3 – Installing the Chinook Database

Lecture 9: Foundation #4 – What’s in the Chinook Database?

Lecture 10: Foundation #5: SQL Server Reporting Services Components

Lecture 11: Foundation #6: SQL Server Reporting Services Tools

Lecture 12: Foundation #7: Getting Help with SQL Server Reporting Services

Chapter 2: Module #2: Working with Visual Studio (formerly: Sql Server Data Tools (SSDT))

Lecture 1: Lesson #1 – Creating a Project in SQL Server Data Tools (SSDT)

Lecture 2: Lesson #2 – Solutions, Project, and Reports Hierarchy

Lecture 3: Lesson #3 – Opening a Project in SQL Server Data Tools (SSDT)

Chapter 3: Module #3: Creating Reports with the Report Wizard

Lecture 1: Lesson #4 – Report 1 – Customer Email List

Lecture 2: Lesson #5 – Report 1b – Customer Email List Modified

Lecture 3: Lesson #6 – Report 2 – Customer Invoice Total Report

Lecture 4: Lesson #7 – Report 2b – Customer Invoice Total Report Modified

Lecture 5: Lesson #8 – Report 3 – Support by Customer City Report

Lecture 6: Lesson #9 – Report 3b – Support by Customer City with Parameters

Lecture 7: Lesson #10 – Report Architecture

Chapter 4: Module 4: Creating Reports from Scratch

Lecture 1: Lesson #11 – Report 4 – Sales by City

Lecture 2: Lesson #12 – Report 4b – Sales by City Modifications

Lecture 3: Lesson #13 – Report 4c – Sales by City – Properties Window

Lecture 4: Lesson #14 – Report 4d – Sales by City – Country Parameters

Lecture 5: Lesson #15 – Report 4e – Sales by City – Display Parameters

Lecture 6: Lesson #16 – Report 4f – Sales by City – Merge Cells

Chapter 5: Module 5 – Charts, Maps, Gauges, and Dashboards

Lecture 1: Lesson #17 – Report 5 – Sales over Time – Line Chart

Lecture 2: Lesson #18 – Report 6 – Sales and Invoice over Time Chart

Lecture 3: Lesson #19 – Report 6b – Sales and Invoice over Time – Secondary Axis

Lecture 4: Lesson #20 – Report 6c – Sales and Invoice over Time – Calculated Field

Lecture 5: Lesson #21 – Report 7 – Sales by Genre

Lecture 6: Lesson #22 – Report 8 – Sales by State

Lecture 7: Lesson #23 – Report 9 – Management Dashboard – Part 1 – Datasource

Lecture 8: Lesson #24 – Report 9 – Management Dashboard – Part 2 – Report

Chapter 6: Module 6 – The Customer Invoice Report

Lecture 1: Lesson #25 – Report 10 – Customer Invoice – Part 1 – Datasource

Lecture 2: Lesson #26 – Report 10 – Customer Invoice – Part 2 – Invoice Line Items

Lecture 3: Lesson #27 – Report 10 – Customer Invoice – Part 3 – Invoice Header and Bill To

Lecture 4: Lesson #28 – Report 10 – Customer Invoice – Part 4 – Logo and Border Formatting

Lecture 5: Lesson #29 – Report 10 – Customer Invoice – Part 5 – Total, Export to PDF, Image

Lecture 6: Lesson #30 – Report 10b – Customer Invoice Part 6 – Footer, Image, Global Variable

Lecture 7: Lesson #31 – Deploying Report to the Report Server and Report Manager

Chapter 7: Module 7 – Conclusion

Lecture 1: Lesson #32 – Course Review

Lecture 2: Lesson #33 – Next Steps – Where do you go from here?