No Upcoming Events
No upcoming Scheduled Courses. Contact us for information on booking a private course or join the waiting list for a public event.
Contact Us
Enabling you to use, administer, configure and support major new aspects of Microsoft SQL Server at recent up to date versions.
Descriptions
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 2019Upgrade 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 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.
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.
Prerequisites
Delegates must have comprehensive experience of SQL Server 2008 R2 or an earlier version.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
Get Started
Forget trawling through endless course catalogues – Find the training that’s right for you
Learn MoreLatest News from Quanta
Service Management State of Play: All talks available to watch now.
Following the recent Service Management State of Play event in collaboration with PeopleCert, we are pleased to share the presentations…
Read More
Quanta Achieves FTG Gold Partner Status
We’re thrilled to share that Quanta Training has been awarded FTG Gold Partner status at this year’s FTG (Forces Transition…
Read More
ITIL Version 5: Bringing Clarity, Confidence & Connection to the Digital Age
With the launch of ITIL Version 5, Quanta’s head of portfolio for IT Service Management and ITIL Master, Adam White-Bower…
Read More