Updating your database development skills
Using the SQL coding language, a SQL programmer designs tables, writes queries, and ensures that these queries perform at optimal speeds.
Most SQL developers are either database administrators or experts in managing database development.
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.
Target Audience: 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.
Additional this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server2016 certification.
There are different flavors of SQL depending on the platform you use, but they all perform the same basic functions—retrieve, add, edit, and delete database data.
Or for more information on claiming vouchers you can speak to our dedicated Software Assurance administration team on 01753 898 351.Book: Introducing Microsoft SQL Server 2005 for Developers 1. This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.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?Enhanced Always On Availability Groups What’s New in Database Caching?