Discover Classes. Earn Rewards.

SQL Server 2014 Reporting Services is unfortunately unavailable

Thankfully we have 11 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.

SQL Level 1

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Unlock the power of SQL and relational databases with this comprehensive course. Learn how to write SQL queries, filter results, and combine data from multiple tables, all while gaining a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.

(372) Beginner 18 and older

SQL Level 3

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Take your SQL skills to the next level with this advanced course at Noble Desktop. Learn how to use subqueries, views, functions, stored procedures, and more to manipulate and analyze data in databases. Gain in-depth techniques that will prepare you for a job in data analysis or data science.

(372) Advanced 18 and older

SQL Level 2

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Enhance your SQL skills by mastering Outer Joins, NULL data, grouping, aggregate functions, filtering, and working with dates/times. Extract and analyze specific data from databases, turning raw information into valuable insights. Prerequisite: SQL proficiency equivalent to Noble Desktop's SQL Level 1 course.

(372) Intermediate 18 and older

Data Analytics Technologies Bootcamp

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

In this course, students will master Excel, SQL, and Tableau, some of the top data analytics tools. Here, students will gain the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.

(372) All levels 18 and older
$1,949

8 sessions

Gift it!

SQL Bootcamp

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Master the art of turning raw data into actionable insights with SQL queries. This hands-on course will teach you how to filter, group, and join data, as well as use advanced techniques like subqueries and aggregate functions. Gain the skills to excel in any data-driven industry and make more informed decisions.

(372) All levels 18 and older
$975

3 sessions

Gift it!
See all SQL classes NYC

SQL Server 2014 Reporting Services

  • All levels
  • 18 and older
  • $1,795
  • (Exact location to be announced), New York, NY
  • 24 hours over 3 sessions

Start Dates (0)

  • $1,795
  • NY - Manhattan @ (Exact location to be announced), New York, NY 00000
  • 24 hours over 3 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this sql class:

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility

This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility. It begins with a discussion of the Reporting Services architecture and how to set up Reporting Services servers. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports, sub-reports, matrix reports (pivot tables), free-form reports and reports with charts and gauges. 


Students learn how to group data and add subtotals and totals to reports, as well as how to add custom calculations using the built-in functions or using custom functions written in .NET. Also demonstrated are all of the data sources for reports that Reporting Services supports including: SQL Server databases, Access databases, XML files, Oracle databases, data warehouses and Analysis Services data cubes.


Report Models, and how they can support end users creating ad-hoc reports, are covered and students practice with them in comprehensive hands on exercises. This includes a demonstration of Report Builder, which is a free report authoring tool from Microsoft. 


The course ends with a complete overview of Report Server administration, including how to deploy and secure reports, how to schedule automatic report generation and delivery, how to backup reports, how to store previous copies of reports in history folders, and how to maintain and troubleshoot Report Servers.


Course Prerequisites:

 
  • Familiarity with database concepts, Windows desktop navigation and software installation techniques. 
  • Attendance at HOTT's SQL Programming course or Microsoft Transact-SQL Programming course is highly recommended although not required.

Course Overview


Reporting Services Architecture

  • All Report Server Components Defined
  • Review of the Report Server Databases
  • Managing the Report Manager Web Interface
  • Report Lifecycle Step by Step

Creating Basic Reports

  • Creating Table Reports
  • Formatting Options
  • Adding Headers and Footers
  • Using Subtotals and Formulas
  • Adding Charts and Gauges
  • Using Lists for Free-Form Reports
  • Paging and Sorting
  • Managing Data Sources

Advanced Report Features

  • Setting Up Input Parameters
  • Adding Custom Report Navigation
  • Adding Drill-Down for Master-Detail Reports
  • Linking Reports
  • Using Sub-reports
  • Adding Conditional Formatting

Matrix Reports

  • Pivoting Data with Matrix Controls
  • Adding Multiple Data Regions
  • Grouping and Sorting
  • Adding Subtotals
  • Adding Custom Aggregate Formulas
  • Using the TablixControl

Implementing Report Models

  • Understanding Report Models
  • Defining and Deploying Report Models
  • Setting Friendly Names for Source Data
  • Managing and Securing Report Models

Report Builder Utility

  • Creating Reports with Report Builder
  • Connecting to Report Models
  • Adding Charts and Gauges in Report Builder
  • Differences Between SQL Server Data Tools and Report Builder

Reporting Services Security

  • Organizing Reports in Folders
  • Setting Permissions on Reports and Folders
  • Managing Security Roles
  • Securing Data Sources and Report Models
  • Logging Activity on the Report Server

Automating Report Creation and Delivery

  • Creating Snapshot Reports
  • Storing Previous Versions of Reports
  • Caching Reports to Improve Performance
  • Defining Subscriptions to Automate Report Delivery
  • Rending Reports in Excel, MS Word or as a PDF
  • Hiding Reports from Users

Adding Custom Code

  • Querying the Report Server
  • Creating Custom Data Extensions
  • Creating Command Objects
  • Creating Data Reader Objects
  • Generating Report Definition Language

.NET Integration with Reporting Services

  • Writing User-Defined Functions in .NET
  • Using Custom Functions
  • Referencing .NET Libraries
  • Managing Report Servers from .NET Applications
    - Accessing SSRS from .NET Applications
    - Retrieving Report Items
    - Listing Report Metadata
  • Using the ReportViewer Control in ASP.NET Applications

Refund Policy

Tuition includes all course materials. Students may withdraw before the second day of class to receive a 100% refund, provided course materials are returned to the instructor. Prorated refunds may be granted for withdrawals after the first day.

Cancellations and Changes: There are no cancellation fees.

Attendance Requirements: Students must attend each day of a course and successfully complete hands on exercises in order to receive a certificate of completion. If a student wishes to retake any portion of a class that he or she completes, the student may do so within 12 months at no extra cost.

Intended Audience: Hands On Technology Transfer, Inc., provides IT training designed for technology professionals who wish to quickly upgrade their computer skills. In most states, the employer bears all training costs.

Reviews of Classes at Hands On Technology Transfer, Inc. (7)

(4.6-star rating across 7 reviews)
See reviews for other classes at Hands On Technology Transfer, Inc.
loading...
Hide Reviews

Review Summary by CourseHorse

Students have overwhelmingly positive feedback about the SQL Server 2014 Reporting Services classes. They appreciated the knowledgeable, friendly, and helpful instructors. The overall class experience was excellent, and many students expressed a desire for additional training with instructors as knowledgeable as the ones they had. The classes exceeded expectations in terms of course material, explanation of labs, and the level of personal attention received. Students not only gained valuable information but also developed skills in SQL Server 2014 Reporting Services. They were able to walk away with a deep understanding of the material and felt confident in their abilities to apply it. Quotes: - "The instructor was very knowledgeable, friendly, and helpful. Overall class experience was excellent. The remote class option was great!" - "Amazing instructor. Knew the material very well and his class was very informative. I hope to have additional training with instructors as knowledgeable as him." - "SST hires excellent staff from administration to instructors who offer superior personal attention. Both classes I've attended have exceeded my expectations from the course material to the explanation of the labs and the help I received."

Similar Classes

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 17950 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Hands On Technology Transfer, Inc.

HOTT delivers instructor-led technical training across the United States, Canada and the United Kingdom. Whether you attend in person, remote-live or on-demand, our classroom-based training philosophy zeroes in on your ability to work more productively and with higher quality results after training....

Read more about Hands On Technology Transfer, Inc.

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Hands On Technology Transfer, Inc.

Hands On Technology Transfer, Inc.

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...