Updating Your Skills to SQL Server 2016 Course Overview

Certainly! The "Updating Your Skills to SQL Server 2016" course is designed for individuals with some prior experience in database technologies, specifically with Microsoft SQL Server. To ensure a successful learning experience, the following are the minimum required prerequisites for students considering this training:

• Basic understanding of database design, including knowledge of normalization and relational database concepts.
• Experience working with SQL Server 2014 or earlier versions, including creating and managing databases, and using Transact-SQL for querying data.
• Familiarity with SQL Server Management Studio (SSMS) and its use for managing the SQL Server environment.
• Knowledge of basic Windows server administration, including tasks such as managing Windows services and accounts.
• Understanding of Microsoft Windows operating systems and their core functionality.

Please note that this course assumes you are already familiar with the foundations of SQL Server and are looking to update your skills to the latest version. If you are new to SQL Server, we recommend starting with a foundational course before attempting to update your skills to SQL Server 2016.

Target Audience for Updating Your Skills to SQL Server 2016

1. This course is tailored for IT professionals seeking to update their skills to SQL Server 2016, focusing on new features and performance enhancements.

   
   

2. Target Audience:

   
   

• Database Administrators
• Database Developers
• Business Intelligence Professionals
• IT Professionals with prior SQL Server experience
• Data Analysts who use SQL Server
• System Architects who need to understand new features
• SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) professionals
• IT Project Managers overseeing SQL Server deployments
• Data Professionals preparing for Microsoft certification exams related to SQL Server 2016

Learning Objectives - What you will Learn in this Updating Your Skills to SQL Server 2016?

Introduction to Course Learning Outcomes:

This course offers a comprehensive overview of the enhancements and new features introduced in SQL Server 2016, designed to help professionals update their skills and maximize their data management capabilities.

Learning Objectives and Outcomes:

• Understand the key features and capabilities introduced in SQL Server 2016, including performance, security, scalability, reporting, BI, data access, OLAP, and cloud integrations.
• Learn how to improve database performance using new features like Query Store, TempDB enhancements, and JSON support.
• Explore new security features such as Always Encrypted, Row-Level Security, and Dynamic Data Masking to protect sensitive data.
• Gain insights into enhanced high availability and disaster recovery solutions with AlwaysOn Availability Groups.
• Discover the new and improved SQL Server Reporting Services (SSRS), including modernized reports and mobile report publishing.
• Understand the enhancements in SQL Server Integration Services (SSIS) and how to work with the latest data access patterns.
• Examine the advancements in SQL Server Analysis Services (SSAS), including new OLAP features and improved BI tools.
• Familiarize yourself with the new tools and features for SQL Server data access, including enhancements to Transact-SQL and the introduction of PolyBase.
• Learn about the options and considerations for SQL Server cloud deployment with Azure SQL Database and SQL Server on Azure Virtual Machines.
• Understand the implications of the new features on your existing SQL Server environment and how to strategically implement them to benefit your organization.