Select specific date to see price, venue and full details.
Describe key capabilities and components of SQL Server 2016 Describe new and enhanced features in reporting and Power BI in SQL Server 2016Describe new and enhanced features in SQL Server performance Describe new and enhanced data access features Describes new and enhanced features in SQL Server security Describe new and enhanced features in SQL Server OLAPDescribe what’s new in SQL Server Availability and Scalability Describe new SQL Server cloud functionality Experience of building and managing database, data warehouse,and business intelligence (BI) solutions with SQL Server 2014.
Using the SQL coding language, a SQL programmer designs tables, writes queries, and ensures that these queries perform at optimal speeds.
This course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers.
This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
To book courses using vouchers please call our sales team on 03.
Or for more information on claiming vouchers you can speak to our dedicated Software Assurance administration team on 01753 898 351.
Typical tasks for a SQL programmer include: Some SQL programmers assist the database administrator with standard maintenance, but this is not usually required.
However, having experience in database administration and maintenance is a great addition to the standard skill set of a SQL programmer.
Familiarity with the Windows Server 2012 R2 operating system and networking.
Familiarity with Microsoft Excel and Microsoft Share Point Server 2013.
Module 1: Introduction to SQL Server 2016 Overview of SQL Server 2016 SQL Server 2016 Editions and Components Installing SQL Server 2016 SQL Server Management Studio Enhancements Lab : Installing SQL Server 2016 Module 2: What’s New in SQL Server Performance Columnstore Indexes for Operational In-memory OLTP Enhancements The Query Data Store Native JSON Temporal Tables Lab : Implementing SQL Server 2016 Performance Improvements Module 3: What’s New in SQL Server Security Using Always Encrypted Row-level Security Dynamic Data Masking Lab : Implementing SQL Server 2016 Security Improvements Module 4: What’s New in SQL Server Availability and Scalability?