Ready to watch this entire course?
Become a member and get unlimited access to the entire skills library of over 4,800 courses, including more Developer and personalized recommendations.Start Your Free Trial Now
- View Offline
Note: These tutorials are applicable to both the 2008 and 2012 versions of SQL Server.
- Understanding the elements of a report
- Grouping table regions
- Joining data from multiple tables
- Displaying data in a matrix
- Customizing report parameters
- Filtering and sorting data
- Creating charts
- Adding sparklines and data bars
- Creating at-a-glance reports with indicators
- Using Maps in Reporting Services
- Configuring report security
- Printing and exporting reports
Skill Level Advanced
So that we can focus on using Reporting Services, there are awesome things I'm expecting you to know coming into this course. Now if you are already comfortable with SQL Server 2008 or SQL Server 2012, that's great. You are ready to go. But it isn't essential and you be an expert on SQL Server. What is essential is you understand at least the basics of relational databases. If I talk about tables and rows and columns, keys and relationships, you know what I mean. Now this database knowledge doesn't have to be from SQL Server, although that is most convenient. It could be from Access or Oracle, DB2 or My SQL, as relational databases are all very similar in concept.
But if you're completely new to databases, first take a look at our Foundations of Programming: Databases course that covers all the basic concepts. It is also helpful to know some SQL. You don't have to be an expert; just knowing how to write select statements is good. And as you'll see, you won't have to write much SQL if you don't want to, but SQL Server Reporting Services is a product built on top of a classic relational database. So the more of that classic relational database knowledge you already have, the more you will be able to get out of this product. So if you can write basic SQL queries, great; and if you are a complete expert, even better.
Now what if you have got some of this knowledge but just need a refresher on this. Well, we have a SQL Essential Training course and one of the quickest ways you could go through this is to take a look at the SQL Server 2008 Essential Training Course, particularly the Creating Databases and Retrieving Data with SQL chapters. And with this in mind, next I am going to quickly cover some setup questions you might have, some basic terminology, and what we actually need to get started.
Sign up for a Premium Membership to download courses for Internet-free viewing.
Watch offline with your iOS, Android, or desktop app.Start Your Free Trial
After signing up, download the course here or from the iOS/Android App.