Enable Technology

SQL SERVER REPORTING SERVICES PRESTWICH TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES PRESTWICH




About Enable Technology Prestwich SQL Server Reporting Services Training Courses

We offer intensive two and three days SQL Server Reporting Services courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We provide every candidate with SQL Server Reporting Services training materials which they keep after the course. It is our company policy to provide SQL Server Reporting Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Reporting Services course can contact the Tutor for as long as they need assistance after the training.

SQL Server Reporting Services courses are taught by a Microsoft Certified Solutions Expert. During the Covid 19 crisis we can deliver this course online. Delegates participate in a virtual SQL Server Reporting Services class and can both talk to and share their screen with the tutor. We will work with you prior to the course to tailor the SQL Server Reporting Services syllabus to match your requirements.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: TalkTalk Direct Limited, Shell UK Oil Products Ltd, Keele University, Homeserve PLC, Norfolk Police Constabulary, Birmingham Heartlands Hospital, Nationwide Building Society Limited and Capita Group PLC.




SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Prestwich
  • Telephone on 01952 305730
  • Course Outline
  • A two day intensive course introducing the comprehensive range of SQL Server Reporting Services 2008 report writing and deployment features.

  • Some of the training topics covered include ...
  • Investigate the scheduling of report snapshots 
    Learn how to enable and control report caching 
    Investigate what SQL Server Reporting Services can do 
    Understand scope as it applies to aggregate functions 
    Learn how to create parameters in ad-hoc SQL 
    Managing Reporting Services
    Snapshots and Subscriptions
    Investigate Reporting Services charts 
    Introducing SQL Server Reporting Services
    Learn about datasets and data regions 
    Discover the various global collections that you can reference in your expressions 
    Understand how to plan and configure for deployment 
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    Learn how to create data-driven report subscriptions 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Learn how to use URL to integrate Reporting Services reports into your applications 
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Learn how to work with rich text to produce mail merge style reports 
    Explore the use of Reporting Services gauges 
    Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place 

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Prestwich
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day course which equips participants with the skills necessary to effectively use SQL Server 2005 Reporting Services. Enable Technology also run a comparable two day Reporting Services 2000 training course.

  • Some of the training topics covered include ...
  • Filters
    Current Classroom Folder Structure
    Report Design Options
    Filters
    Perspectives
    Understanding the Model Designer
    Create a Database for Report Execution Data
    Database Components
    Managing Tables with the Table Properties Dialog
    Default Folder Structure
    Starting SQL Server Business Intelligence Development Studio
    Using the Report Manager
    Deploying Reports with Development Studio
    Chart Types
    Report Formatting Toolbar
    Saving a Report
    Understanding Security Settings
    A Closer Look at Preview
    Settings

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Prestwich
  • Telephone on 01952 305730
  • Course Outline
  • This three day intensive course will give delegates a comprehensive understanding of how to design and publish parametrised reports, manage permissions, schedule automated reporting and configure report caching. The course also demonstrates how to build reports designed for tablets and mobile devices.

  • Some of the training topics covered include ...
  • Sorting and grouping
    Use report services configuration manager to reconfigure SSRS servers.
    Publish a report to reporting services Working with Reporting Services Data
    Topics include Introduction to Reporting Services
    Databars, sparklines, indicators, gauges, and maps
    Extend reporting services functionality with external assemblies.
    Images and charts
    Reporting services tools Reporting Services Data Sources
    Reporting services components
    Formatting data
    Implementing report filters and parameters Visualizsng Data with Report Services
    Introduction to reporting services
    Preparing data for mobile reports
    Configuring data access with report designer
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Configuring data access with report builder
    Drilldown and drill through Sharing Reporting Services Reports
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Overview of mobile reports
    Schedules
    Report sub-reports

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Prestwich
  • Telephone on 01952 305730
  • Course Outline
  • Aimed at Report Writers using SQL Server Reporting Services (SSRS) 2012 and 2014 this intensive two day course demonstrates how to create and deploy parameterised reports using Report Builder and Report Designer. No prior Reporting Services experience is assumed but a reasonable grasp of SQL is essential.

  • Some of the training topics covered include ...
  • Cascading Parameters
    Create A Shared DataSet for Northwind
    Globals Collection
    Create a Shared Data Source and Two Data Sets
    Null Handling
    Displaying the Parameter Value and Label for a Drop-Down List Parameter
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    Reporting Services Modes
    Variable Collection
    Working with Maps and Spatial Data  Enhancing Reports with Data Visualisation
    Create a Report with Interactive Sorting Dynamic Reports with Parameters
    Parameters and Stored Procedures
    Creating a Shared Data Source and Data Sets
    Field Collection
    Service Architecture  Report Building Tools
    Installing and Configuring Reporting Services Reporting Services Architecture
    Reordering Report Parameters Using Drop-Down List Parameters
    Tablix Cell Content and Scope Building a Tablix Report
    Creating a Customer Contact List  Creating Ad Hoc Reports With Report Builder
    Interactive Sorting
    Native Mode Architecture

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Prestwich
  • Telephone on 01952 305730
  • Course Outline
  • Aimed at Data Analysts and SQL users this instructor-led course provides participants with the necessary knowledge to develop reports using Microsoft SQL Server 2016 Report Builder. The course covers Report Builder wizards, basics of report design, report parameters, report expressions, filters, report visualisations including graphs, charts, images and gauges. The course also covers the use of maps, interactive reports, report parts, sub reports, subscriptions and exporting options.

  • Some of the training topics covered include ...
  • Understanding Visualizations
    Utilizing Chart Wizard
    Using Tables
    SQL Server 2016 Report Builder Advanced Reporting
    SQL Server 2016 Report Builder Basic Reports
    Exploring Table or Matrix Wizard
    Introduction to SQL Server 2016 Report Builder
    Understanding HTML5 and Textboxes
    Utilizing Dynamic Headers and Footers
    Examining Management
    Examining Maps
    Planning Your Reports
    Examining Parameters
    Formatting Reports
    Working with Expressions
    Creating Subreports and Drillthrough Reports
    Utilizing Charts
    Working with Datasets
    Exploring Gauges

  • See Training Course Details...



Email us about this courses



Other Prestwich Enable Technology Training Courses

HTML - Prestwich Web Development Training Courses
SQL Prestwich Training Courses
Mobile Prestwich Training Courses
DAX - Prestwich Excel Training Courses
PL/SQL - Prestwich SQL Training Courses
Microsoft Project Level 2 Prestwich Training Courses
Crystal 2013 - Prestwich Crystal Reports Training Courses
Power BI Prestwich Training Courses
SSAS Tabular Prestwich Training Courses
Power Query Prestwich Training Courses
JavaScript - Prestwich JavaScript Training Courses
Excel Basic Prestwich Training Courses
Access 2016 Prestwich Training Courses
Crystal 2011 - Prestwich Crystal Reports Training Courses
Excel Power Pivot Prestwich Training Courses



North West - Possible Sql Server Reporting Services Training Course Locations


Widnes, Lancaster, Skelmersdale, Farnworth, Wigan, Accrington, Chorley, Hyde, Rochdale, Middleton, Birkenhead, Salford, Crewe, Thornton-Cleveleys, North West, Wallasey, Leigh, Liverpool, Chadderton, Lytham Urmston, Blackpool, Sale, Bolton, Winsford, Kirkby, Runcorn, Blackburn, Cheshire, Denton, Ellesmere Port, Northwich, Merseyside, Altrincham, Wythenshawe, Huyton, Macclesfield, Prestwich, Southport, Bury, Saddleworth, Stockport, Ashton-under-Lyne, Oldham, Lancashire, Barrow-in-Furness, Bootle, Chester, Morecambe, Leyland, Stretford, Carlisle, Warrington, Manchester, Eccles, Preston, Crosby, Burnley