Purchase this course now
  • Purchasing this course allows you access to view and download the videos
  • More product info
  • Looking for multi-user licensing info?
$99.95

Currency conversions:

SQL Server 2005 Reporting Services

  • ·Skill level: 200-500
  • ·Run Time: 17+ hours (99 videos)
  • ·CourseId: 154


Learn SQL Server 2005 Reporting Services (SSRS) online with this training course from master trainer Scott Whigham. This course will teach you how to create your own reports (charts, graphs and more) as well as help you master Reporting Services administration, installation, configuration, and security. This course features nearly 100 videos organized in eight chapters and totals more than 17 hours of instructor-led training for SQL Reporting Services 2005.

Browse this course's videos now
  • Search for videos within this course

This course is featured in the following packages


Table of Contents

Download a PDF of the videos in this course Download PDF version


  • What format is this course in? This course is a video training course in standard .AVI format. After purchasing this course, you will be able to immediately download the entire course (all chapters and all exercises/files).
  • How does it work? It's simple: a user purchases the course and then downloads the course to their hard drive. You can download entire chapters at a time or individual videos. You can then watch the videos from anywhere!
  • If I buy the course, what is included? You get every video in this course along with all of the video exercises/hands-on labs, PDFs, script files and other "bits" that the course may contain. Most courses are a blend of demo and lecture (similar to a live classroom course) but, depending on the topic, some courses are lecture-only while others are demo-only.
  • Are there any free/sample videos from this course? Yes! Check out our free SSRS 2005 videos
  • If I buy the course, do the videos ever expire? No, the videos do not ever expire. Once you download the videos, you have them for as long as you want! You can read more about this and other questions about purchasing our courses in our pre-sales questions FAQs.
  • Do I have to have an internet connection to watch the videos? No, the videos do not require an internet connection. You will, however, need an internet connection to download the videos!
  • Can I get a certificate saying I passed/took the course? Yes. Once you have downloaded all of the videos in the course, send us a request for a certificate through our contact us page. We'll send you a certificate that looks like this sample certificate.
  • Will this course help me pass a certification exam? Absolutely. We have a lot of members who have successfully earned Microsoft certifications with the help of our training materials. We do not, however, consider ourselves a "certification training company"; we are a "real world training company" and we think there is an important difference between the two. Read more

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Our SQL Server Reporting Services course is designed for the beginner-intermediate - beginners and advanced users are welcome as well yet most material is in the Level 200-300 range.
While a true beginner could take this course, it is actually recommended that you have at least 30 days experience working with SQL Server (or equivalent work experience with another database system) prior to taking this course. Prior knowledge of query writing is assumed.

Browse this course's videos now

Table of Contents (with descriptions/times)

This SSRS 2005 video training course is separated into chapters. You may view the videos in each chapter separately by clicking the links below or, if you'd like to view every video on a single page, you want The Big List.

Chapter 1 - Introduction to SQL Server Reporting Services

Abstract: Just what exactly is this fancy SQL Server Reporting Services? How does it work? Can I get emails that have my reports in them? This chapter covers the basics - it's really for first-time SSRS (that's SQL Server Reporting Services BTW) users and is designed to get you up to speed quickly on the terms, definitions, concepts, architecture and more.
Number of Videos: 6
Total Run Time: 1 hour and 6 minutes

Chapter 2 - Installing Reporting Services for SQL Server 2005

Abstract: In this chapter, you can expect to find some great instructional videos on how to install SSRS for SQL Server 2005, including how to do a default installation, a files-only installation, how to install SSRS on Windows Vista and more!
Number of Videos: 20
Total Run Time: 3 hours and 5 minutes

Chapter 3 - Configuring Your Reporting Services Installation

Abstract: In this chapter, the videos and video series will take you through the entire process of customizing and configuring your Reporting Services installation.
Number of Videos: 5
Total Run Time: 1 hour and 3 minutes

Chapter 4 - Security in SQL Server Reporting Services

Abstract: Item-level security, Roles, Encrytion, and basic Security are what the video series in this chapter are all about!
Number of Videos: 13
Total Run Time: 2 hours and 37 minutes

Chapter 5 - Developing Reports Using the Business Intelligence Development Studio (BIDS)

Abstract: In this chapter/chapter, the videos are all mainly focused on helping you develop your Reporting Services reports via BIDS, Business Intelligence Developemnt Studio.
Number of Videos: 38
Total Run Time: 6 hours and 27 minutes

Chapter 6 - Administering SQL Server Reporting Services

Abstract: This videos and video series in the chapter will help you to decipher what edition of SSRS will work best for you, along with helping you to understand and to write custom reports for your report server.
Number of Videos: 5
Total Run Time: 52 minutes

Chapter 7 - Inside SQL Server Reporting Services: Understanding the Architecture of SSRS

Abstract: In this chapter/chapter, the videos and video series are all centered around the goal of giving you a look at the inner workings of SSRS, and helping you to understand it's architecture.
Number of Videos: 9
Total Run Time: 1 hour and 47 minutes

Chapter 8 - Ad-Hoc Reporting, Report Models, and the Report Builder

Abstract: One of the most interesting new features of SQL Server 2005's Reporting Services implementation is the ability to use Report Models so that users can create ad-hoc reports without resorting to writing SQL or MDX. In fact, these modern day report tools built into SSRS are so easy that you do not need to know SQL/DMX at all to get the data that you want! This chapter/chapter focuses on learning what report models are, what SDML (Semantic Model Definition Language) is and how it works, roles, attributes, fields, entities and just about everything associated with ad hoc reporting in SQL Server Reporting Services.
Number of Videos: 3
Total Run Time: 36 minutes

Browse this course's videos now

^ Back to top