Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Module 1: Introduction to SQL Server Reporting Services – SSRS
- Overview of SSRS
- Installing Reporting Services
- The Reporting Lifecycle
- Highlights of Reporting Services
- Reporting Services Scenarios
- Reporting Services Developer Tools
Module 2: Authoring Basic Reports
- Creating a Basic Table Report
- Report Definition Language
- Accessing Data
- Formatting Report Pages
- Headers and Footers
- Calculating Values
- Common Aggregate Functions
Module 3: Enhancing Reports
- Interactive Navigation
- Use Show/Hide to Provide Drill-Down Interactivity
- Navigate From Report To Report Using Links
- Working with Data Regions
- Using Report Manager
- Distribute and Manage Published Reports
Module 4: Introduction to SQL Server Integration Services – SSIS
- What Is SSIS?
- When to Use SSIS?
- SSIS Architecture
- Integration Services Scenarios
- Integration Services Developer Tools
- Control Flow and Design Flow Design Surfaces
- Migrating data across Excel, Flat Files, XML and database providers
- Adding Tasks to a Package
Module 5: SSIS Going Further
- Building a Package
- Troubleshooting a Package
- Deploying a Package to the SSIS Server
- Scheduling a Package with SQL Server Agent
- Securing a Package in Management Studio
- Using Variables, Event Handlers and Configurations
Module 6: Introduction to SQL Server Analysis Services – SSAS
- What Is SSAS?
- When to Use SSAS
- SSAS Architecture
- Analysis Services Tools
- Understanding Fact and Dimension tables
Module 7: SSAS Going Further
- Creating an Analysis Services Project in Visual Studio
- Fact and Dimension Tables
- Creating a Data Source
- Creating a Data Source View
- Creating a Cube Object Definition
- Deploy Definitions to OLAP Server and Load in Data
- Browse a Cube to Query Data
- Creating Key Performance Indicators (KPI’s) to Give Meaning to Data
Requirements
Before attending this course, students must have:
- Understanding of relational database concepts
- Experience of querying a relational database
- Fundamental understanding of reporting and analysis
Testimonials
Interaction with the teacher, the opportunity to ask hot questions
Grzegorz Ziegert
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
Raphael Keymer - Markit Valuations Limited
Knowledge of the lecturer
Paweł Dybowski
Commitment and passion of the trainer ☺. And with the problem of managing backupmi, Joby.
Krzysztof Klockowski
I enjoyed the attention to detail, knowledge and enthusiasm for the subject.
Bristol City Council
The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.
Jim Lane
everything :)
Szymon Lasota - Lingaro Sp. z o.o.
Practical knowledge
Tomasz Bartczak - Lingaro Sp. z o.o.
Exercises on real data
- Lingaro Sp. z o.o.
learning about reading query plans (individual elements)
- Lingaro Sp. z o.o.
Very interesting examples, ease of knowledge transfer by the teacher.
- Lingaro Sp. z o.o.
a large number of topics.
- Lingaro Sp. z o.o.
Help in designing the actual database we intend to build based on the knowledge of the course; Quickly create reports.
- Carlsberg Shared Services Sp. z o. o.
I liked the practical and immediate application of concepts to lectures.
- Nordex Energy GmbH
Relevance to BigQuery.
- Spark44
We use BigQuery and the trainer decided we would use BigQuery instead to run all of the codes which was really really useful
- Spark44
topics covered, although I would have loved it better if SSIS and SSRS were also covered.
- SYKES Asia, Inc.
the in depth knowledge and customize approach
Julius Mapili - SYKES Asia, Inc.
The exercises and hands-on activity
Raymund Libre - SYKES Asia, Inc.
Overall understanding about SQL
MTU Aero Engines Polska Sp. z o. o.
A lot of useful infromation has been provided.
MTU Aero Engines Polska Sp. z o. o.
I got a great starting point in sql server administatrion
MTU Aero Engines Polska Sp. z o. o.
Pace was perfect. Topics suitable.
MTU Aero Engines Polska Sp. z o. o.
Well prepared trainer open for additional questions of any kind at any time
Thomas Griffig - MTU Aero Engines Polska Sp. z o. o.
backup and maintanace issues
Colian sp. z o.o.
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
It felt very relatable. The exercises were well picked out and I was able to work well with it due to clear knowledge provided.
Leah Bayliss - Thames Water Utilites Ltd
Phil was great! He was both patient and knowledgeable. The training went at a good pace, moving a team of mixed SQL abilities through the basics into more advanced SQL querying together. The exercises were an excellent way for us to commit our newly learned skills to memory, and Phil's instructions/class discussions on numerous ways to achieve the same thing were interesting.
Sophie Clement - Thames Water Utilites Ltd
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Related Courses
MS SQL Server 2016
14 hours
SQL language in MSSQL
14 hours
SQL in SQL Server
14 hours
Transact SQL Advanced
7 hours
Transact SQL Basic
14 hours
Administration with Powershell
35 hours