SQL Server 2014 New Features

An in depth conversion workshop for existing SQL Server administrators and developers
Overview

SQL Server 2014 introduces the concept of your data anyplace, anytime. If you are familiar with SQL Server 2012, 2008 R2 (or an earlier version) and wish to learn all about these additional benefits SQL Server 2014 can bring, then this is the course for you.  The length of this course can be tailored depending on what content you wish to cover and experience; starting at a single day with the potential to go to an entire week.

Course Code
SQL144NF
Duration
4 Days
Delivery Style
Classroom
Course Type
Private Only
Max Delegates
12
Available as Nutshell
No

Book your team training at your premises

  • Date
  • Venue
  • Cost
  • More info
Purpose of this course

The course will introduce delegates to the new feature of Microsoft SQL Server 2014.  The exact content of the workshop and the appropriate duration will be discussed and agreed with you prior to booking.  It will depend on the features you are interested in and which previous version of SQL Server you use.  Our aim is to produce a workshop that meets your exact objectives.  The duration of the workshop will depend on the features required but will look to maximize the benefit you gain from the time and money you spend.

Who is this course for

Database administrators, support staff and Transact SQL developers who need to understand the important new features of Microsoft SQL Server 2014.

You will learn how to
  • Install/Upgrade to SQL Server 2014
  • Use the new features of SSRS 2014
  • Understand the changes to Integration Services
Benefits for your organisation

SQL Server 2014 introduces a whole range of new features that your organisation will want to exploit. It also changes many familiar features that your organisation currently uses. This course will ensure your organisation quickly becomes familiar with the important new features of SQL Server 2014.

Benefits for you as an individual

If you are familiar with an earlier version of SQL Server then the upgrade to the 2014 version can seem daunting. This course will quickly get you up to speed with SQL Server 2014. It will also enable you to exploit the powerful new features.

SQL Server Database Engine

Installing SQL Server 2014
Upgrading to SQL Server 2014
Always On
FileTable
Database Recovery Advisor
Contained Databases
Columnstore Indexes
Throw Statement
New Functions
Offset and Fetch in Order By

SQL Server Integration Services

New Features of Integration Services
SQL Server Data Tools
Parameters
Project Deployment
Configurations
Changes to Pivot Transformation

SQL Server Reporting Services

New Feature of Reporting Services
Alternatives to Report Models

Prerequisites

Delegates must have extensive experience of Microsoft SQL Server at an earlier version.

About the Lead Trainer

Stephen has 20 years’ experience in the IT industry. A member of the Institute of IT Training and British Computer Society with a degree in business computing systems, Stephen has a solid foundation upon which his ITIL® Expert qualification sits.