Microsoft SQL Server 20162019-01-18T16:03:25+01:00

Microsoft SQL Server 2016

Courses / Data and Databases



Microsoft SQL Server 2016

Teams will learn to build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in-from in-memory performance and advances security to in-database analytics.

Study time: Full time – 4 days| Part time – 2 weeks
Vendor: Microsoft
Business support: Our customer success team measures and ensures engagement
Prerequisites: Developers with two+ years experience and good working knowledge of relational databases
Assessment: Exam based – MCSA 70-761, 70-762,  70-764, 70-765
Ideal for: Database developer, database analyst ETL and data warehouse developers

Meet the Trainer             

Aaron Sampson
Aaron Sampson
Aaron Sampson is a seasoned and experienced IT professional who started in the industry in 1995. Aaron has been involved with extensive practical implementations in a variety of technical and operational capacities. Most of his experience has been in environments using Windows/Active Directory systems, SQL databases, and Exchange messaging environments. He holds multiple certifications as a Microsoft Certified Professional and pursues upgrades, new versions, and new technologies.
Contact Us

“Data is growing at a rapid pace. By 2020 the new information generated per second for every human being will approximate amount to 1.7 megabytes.”


Content overview

70-761, 70-762: MCSA SQL Server 2016 Database Development

  • T-SQL Querying
  • Querying and Manipulating Data
  • Filter and Modify Data in SQL Server 2016
  • Using Functions in SQL Server 2016
  • Aggregating Data in SQL Server 2016
  • Subqueries and Predicate
  • Operators and Expressions in SQL Server 2016
  • Database Programmability Objects and Non-Relational Data
  • SQL Server 2016 Database Objects
  • SQL Server 2016 Indexes and Views
  • Colu0mnstore Indexes
  • Programmability Objects
  • Triggers and Functions
  • Transactions and Isolation Levels
  • Managing Database Concurrency
  • Optimize SQL Database Objects and Infrastructure
  • Database Instances
  • Performance Tuning

70-764, 70-765: MCSA SQL Server 2016 Database Administration

  • Microsoft SQL Server 2016: Encryption
  • Microsoft SQL Server 2016: Data Access and Permissions
  • Microsoft SQL Server 2016: Auditing
  • Microsoft SQL Server 2016: Backing Up Databases
  • Microsoft SQL Server 2016: Restoring Databases
  • Microsoft SQL Server 2016: Managing Database Integrity
  • Microsoft SQL Server 2016: Monitoring Database Activity and Queries
  • Microsoft SQL Server 2016: Monitoring SQL Server Instances
  • Microsoft SQL Server 2016: Managing Indexes and Statistics
  • Microsoft SQL Server 2016: High Availability and Disaster Recovery
  • Components of a SQL Server 2016 Installation
  • Installing and Upgrading SQL Server 2016
  • SQL Server Virtual Machines on Azure
  • SQL Server Instances and Storage Considerations
  • Microsoft Azure SQL Database Security
  • Azure SQL Database Encryption
  • SQL Server Performance Settings
  • Deploying Applications to Microsoft Azure SQL Databases
  • Azure Virtual Machines

Our Promise

Contact Us

Trusted by…

Back to Data and Databases

Request a Callback

First Name*
Last name*
Company Email*
Company name*
Your role

Contact Information

Phone: 01273 907 919