SQL Server Upgrading Skills

Enabling you to use, administer, configure and support major new aspects of Microsoft SQL Server at recent up to date versions.
Overview

Microsoft SQL Server is a powerful data platform that is improving with every release.    For example, SQL Server Always On technologies provide near zero downtime.  Enhancements to the OVER clause provides powerful new ways to query SQL Server data.  The Integration Services Catalog revolutionises the management of Integration Services packages.

Course Code
Q3ClaTech258
Duration
3 Days
Delivery Style
Classroom
Course Type
Public or Private
Max Delegates
12
Available as Nutshell
No

Book your virtual training

  • Date
  • Venue
  • Cost
  • More info

Book your place

Purpose of this course

The course covers important features of SQL Server that have been introduced or enhanced at from SQL Server 2012 to SQL Server 2019.  It includes strategies to upgrade database to newer releases.  The course will also include Reporting Services and Integration Services as part of SQL Server.  The course will include lectures, demonstrations and exercises to consolidate the topics covered.

Who is this course for

Experienced database administrators, support technicians and SQL developers who need to be able to use SQL Server from the 2012 to 2019 releases.  This includes the popular SQL server 2016 release.

You will learn how to
  • Install SQL Server 2019
  • Upgrade SQL Server databases
  • Make us of the Integration Services Catalog
  • Use the reporting Services Web Portal
  • Configure Availability Groups
  • Use the enhanced OVER clause
Benefits for your organisation

Each new release of SQL Server brings a range of new features and enhancements.  Your organisation will want to make use of these important features.  This course will enable your organisation to take advantages of these important enhancements.

Benefits for you as an individual

Without action your important SQL server skill could become out of date.  This course will bring you up to date at SQL Server 2019.  It will ensure you are able to continue to work effectively with SQL Server.

Installing SQL Server
•    SQL Server Setup
•    New TempDB install option
•    Upgrading Databases
•    SQL Server Migration Assistant
 
Configuring Databases
•    Buffer Pool Extension
•    FileTable
 
Securing SQL Server
•    Contained Database
•    Server auditing
•    Database auditing
 
Enhancing Database Availability
•    Overview of Availability Groups
•    Configuring Availability Groups
•    Managing Availability Groups
•    Listener Configuration
•    Basic Availability Groups
 
 
Transact SQL Enhancements
•    Splitting, Aggregating and Trimming Strings
•    APPROX_COUNT_DISTINCT
•    JSON Support
•    OVER Clause and Analytic functions
•    Windowing Queries
•    System Versioned Temporal tables
•    Introduction to Columnstore Indexes
 
Integration Services
•    Overview of Integration Service Catalog
•    Configuring Integration Service Catalog
•    Parameters ad Environments
•    Package Parts
 
Reporting Services
•    Web Portal
•    Key Performance Indicators
•    Mobile Reports
 
Prerequisites

Delegates must have comprehensive experience of SQL Server 2008 R2 or 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.