Udemy

SQL Server 2016 Database Reporting

Enroll Now
  • 683 Students
  • Updated 4/2017
4.5
(72 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 44 Minute(s)
Language
English
Taught by
Packt Publishing
Rating
4.5
(72 Ratings)
2 views

Course Overview

SQL Server 2016 Database Reporting

Create impressive reports from your SQL Server data

With SQL Server 2016 Reporting Services, users are excited about being able to visualize their data in new, creative ways for use in presentations, analysis, and decision support—even on mobile devices.


In this course, users will receive step-by-step instructions on how to create stunning, high-impact reports. The course starts with an introduction to the technologies employed. Next, users are shown how to create a basic report and then how to format it and add features (such as headers and footers) to make it more readable, impressive, and practical. The course teaches how to create drill-down and drill-through reports. Pie charts, gauges. and maps are next on the agenda and the course wraps up with lessons on how to assemble a dashboard on the SQL Server Reporting Services web portal. This course will empower you to overcome any obstacle while creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services.


About The Author


Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida. He received his Ph.D. in Integrated Computing and M.S. in Instrumental Sciences from the University of Arkansas at Little Rock. He received a B.A. in Physics from Hendrix College. Before joining UWF, he worked as a data warehouse developer for Northrop Grumman Information Systems and prior to that as a database application developer for Acxiom. Dr. Snider's teaching and research interests include data mining, data warehousing, information visualization, and cyber security.

Course Content

  • 11 section(s)
  • 56 lecture(s)
  • Section 1 Installation and setup
  • Section 2 Wizarding Your First Report
  • Section 3 Formatting a Tabular Report
  • Section 4 Adding Headers and Footers
  • Section 5 Creating a Drill-Down Report
  • Section 6 Using Parameters in a Report
  • Section 7 Creating a Drill-Through Report
  • Section 8 Baking Pie and Bar Charts
  • Section 9 Gauges, Sparklines, and Indicators
  • Section 10 Analytical Maps
  • Section 11 The Reporting Services Web Portal

What You’ll Learn

  • Define a SQL Server Reporting Services data source in the Report Wizard, Add a new column and change the column headers in a report, Create new data fields for use in the report without changing the query or stored procedure, Write queries that are specialized for drill-down reports, and create the drill-down report object, Explore different parameter types in SQL Server Reporting Services, Configure the parent report to support drill-through actions, Write queries that are optimized for maps and add maps to your reports, Write queries to utilize gauges, spark lines, and indicators in a report, Deploy and secure reports on the web portal


Reviews

  • T
    Todd Darby
    5.0

    Provides just enough info without being verbose.

  • P
    Prasad Medepalli
    4.5

    Yes it is a good match. Speeding up the video when showing installing was a good idea so I do not fall asleep

  • M
    Michelle Aldag
    3.5

    Short, mini sessions good. Wasn't quite what I was hoping for.

  • E
    Evgueni Koldachenko
    5.0

    The course is very well structured. It stays to the point without deviations or unnecessary repetition. Excellent coverage. Great value.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed