Upgrading and Querying SQL 2016


This five-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016 and give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines, namely - database administration, database development and business intelligence. The primary audience for this course are existing database professionals with experience of SQL Server 2014 who want to update their skills to SQL Server 2016.

This course includes Exam + Labs Online 90 Day Access (Some Exclusions May Apply).


At the end of the course, students will be able to:

  • describe key capabilities and components of SQL Server 2016
  • describe new and enhanced features in SQL Server performance
  • describes new and enhanced features in SQL Server security
  • describe what’s new in SQL Server Availability and Scalability
  • describe the basic architecture and concepts of Microsoft SQL Server 2016
  • understand the similarities and differences between Transact-SQL and other computer languages
  • write SELECT queries
  • query multiple tables.


In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • experience of building and managing database, data warehouse, and business intelligence(BI) solutions with SQL Server 2014
  • familiarity with the Windows Server 2012 R2 operating system and networking
  • familiarity with Microsoft Excel and Microsoft SharePoint Server 2013
  • working knowledge of relational databases
  • basic knowledge of the Microsoft Windows operating system and its core functionality.


Onsite training?

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline