Code: 
TSQL
Duration: 
2 Day(s)
Price: 
£1000-1621

Overview

Business Intelligence solutions provide the infrastructure that enables users at all levels of a business to make better decisions based on more accurate and up-to-date information. This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build and operate a business intelligence solution using SQL Server 2008 R2 Integration Services, Analysis Services, Reporting Services, Excel 2010 and PerformancePoint Services for SharePoint 2010

This workshop - style course is designed for IT professionals who are interested in learning how to implement Business Intelligence solutions on the Microsoft BI Stack. Basic knowledge of common business requirements for a BI solution is assumed and some experience with SQL Server is required

Audience

  • BI Developers
  • MIS Managers
  • BI Consultants

Prerequisites

  • Basic knowledge of Business Intelligence
  • Knowledge of relational database systems

Course Specifics

Course Outline

  • Introduction to TSQL
  • Basic Select Query (includes Select.From..)
  • Using the Where clause (=,<>,LIKE,IS NULL,.)
  • Sorting data (Order by..)
  • Grouping and summarising data (aggregations and group by)
  • Joins (inner,left,right,union)
  • Calling views and stored procs
  • Common functions (isnull,coalesce,left,right,convert,.)

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Course Location Days Cost Date
Onsite
2 1621 £1621 2018-07-16
London
2 1621 £1621 2018-06-13
Birmingham
2 1621 £1621 2018-06-07
Manchester
2 1621 £1621 2018-05-31
London
2 1621 £1621 2018-05-10
Glasgow
2 1621 £1621 2018-05-08
London
2 1621 £1621 2018-04-19
Manchester
2 1621 £1621 2018-04-05
London
2 1621 £1621 2018-03-28
Bristol
2 1621 £1621 2018-03-28
London
2 1621 £1621 2018-03-08
Birmingham
2 1621 £1621 2018-03-08
Leeds
2 1621 £1621 2018-03-01
London
2 1621 £1621 2018-02-12
Manchester
2 1621 £1621 2018-02-01
Glasgow
2 1621 £1621 2018-01-25
London
2 1621 £1621 2018-01-04
Manchester
2 1621 £1621 2017-12-21
Bristol
2 1621 £1621 2017-12-14
London
2 1621 £1621 2017-12-11
Leeds
2 1621 £1621 2017-12-07
London
2 1621 £1621 2017-11-30
London
2 1621 £1621 2017-11-23
Newcastle
2 1621 £1621 2017-11-09
Birmingham
2 1621 £1621 2017-11-06
London
2 1621 £1621 2017-11-06
Manchester
2 1621 £1621 2017-11-02
London
2 1621 £1621 2017-10-12
Exeter
2 1000 £1000 2017-10-06
Manchester
2 1621 £1621 2017-10-05
Glasgow
2 1621 £1621 2017-09-26
Cardiff
2 1000 £1000 2017-09-20
Aberdeen
2 1621 £1621 2017-09-19
Bristol
2 1621 £1621 2017-09-14
Birmingham
2 1621 £1621 2017-09-11
Leeds
2 1621 £1621 2017-09-07
London
2 1621 £1621 2017-08-31
Manchester
2 1000 £1000 2017-08-21
Manchester
2 1621 £1621 2017-08-14
London
2 1621 £1621 2017-08-03
Belfast
2 1000 £1000 2017-08-02
Milton Keynes
2 1621 £1621 2017-07-27
Glasgow
2 1000 £1000 2017-07-24
London
2 1621 £1621 2017-07-19