Updating Your Skills to SQL Server 2017

OD10998A

Created by
Got Questions? Enquire Now
  • Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2016.
  • Familiarity with the Windows Server 2016 operating system and networking.
  • Familiarity with Microsoft Office 2016.
  • Full access to the official Digital Microsoft Official Courseware (dMOC)
  • Microsoft’s HD-quality streaming videos
  • Access to Hands-On, Live Lab
  • Microsoft Training Support 24*7
  • Exercises, Readings and Knowledge checks

This two-day instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

  • Describe key capabilities and components of SQL Server 2017
  • Describe new and enhanced features in SQL Server Performance, Availability, and Scalability
  • Describe new and enhanced features in SQL Server data access
  • Describe new and enhanced features in SQL Server reporting and BI
  • Describe new and enhanced features in SQL Server OLAP
  • Describe new and enhanced data analytics features
  • Describe new and enhanced features in SQL Server Cloud deployments
  • Describe SQL Server on Linux functionality
  • The primary audience for this course is existing database professionals with experience of SQL Server 2016 who want to update their skills to SQL Server 2017.
  • The secondary audience is existing SQL Server 2016 MCSAs who want to prepare for the Upgrade exam for SQL Server 2017 certification.

Microsoft Official Courses On-Demand (MOC On-Demand) are authorized Microsoft official courses exclusively developed by Microsoft Certified Trainers. MOC on-demand delivers a comprehensive training experience comprising a merge of high-quality audiovisuals, academic readings, Microsoft labs online and knowledge check/assessments.

MOC on-demand is a self-paced training structured for IT Professionals and Developers which makes them proficient in the Microsoft technology and develop technical skills. It focusses on providing you a live, real-time environment for hands-on training while including all the interactive features with credible content that other On-demand offerings lack.

MOC On-Demand comprises a range of courses which are structured in a modular format consisting different modules that are further segregated into lessons, each of which contains questions to testify your knowledge.

Self-paced learning

An online course structure which gives you utmost flexibility to learn.

Official Microsoft content

HD-quality streaming videos with interactive content delivered by expert instructors -“straight from the source”.

Digital Microsoft Official Curriculum

Access to the official curriculum anywhere & anytime.

Hands-on live labs

Microsoft Labs Online to work on your technical skills with integrated lab steps.

Knowledge assessments

Knowledge check and instant feedback to mark your stand in the training process.

24x7 availability

Microsoft-hosted mentors available to you round the clock via chat, email, & phone.

Authored by Microsoft certified experts

In-depth technical content structured by individuals who wrote the software and delivered by expert instructors.

Module 1: Introduction to SQL Server 2017

  • Overview of SQL Server 2017
  • Functionality across versions

Module 2: What’s new in SQL Server Performance, Scalability, and Availability.

  • Adaptive query processing
  • Automatic tuning
  • Availability Scalability

Module 3: What’s New in SQL Server data Access

  • SQL Graph

Module 4: What’s new in SQL Server Reporting and BI

  • Power BI report Server
  • Reporting Services update

Module 5: New and Enhanced Features in SQL Server Analysis Services

  • Tabular model updates

Module 6: New and Enhanced data Analytics Features

  • New and enhanced data analytics features

Module 7: What’s new in SQL Server in the Cloud

  • Azure SQL database features
  • Managed Instances

Module 8: SQL Server on Linux

  • SQL Server on Linux
  • Deploying SQL Server on Linux

ms-excel-basic-to-advanced-level

MS Excel Basic to Advanced Level

By : Ramzan Rajani

Lecture 15

front-end-web-design-using-wysiwyg-web-builder-like-a-pro

Front End Web Design Using WYSIWYG ...

By : Ishmeal Lamptey

Lecture 39

Free

implementing-configuring-cisco-routers-part-1

Implementing & Configuring Cisco Ro...

By : Dariusz Lipski

Lecture 10

learn-nxtgen-hacking-with-technology

Learn NxtGen Hacking with Technolog...

By : Gopikrishna C

Lecture 80

digital-marketing-and-basics-of-seo

Digital Marketing and Basics of SEO

By : Abhirup Moitra

Lecture 10

google-tensorflow-hands-on-with-python-latest

Google TensorFlow Hands on with Pyt...

By : UNP United Network of Professionals

Lecture 51

Buy

$29

Enjoy Limitless Learning. Get Access to Unlimited Courses with Premium Subscrption Subscribe Now

Sign up and start learning
By signing up. you agree to our Terms of Use and Privacy Policy
Forget Password