Upgrading to SQL Server 2016

SQL Server 2016    |    Intermediate
  • 10 videos | 46m 56s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 22 users Rating 4.5 of 22 users (22)
When performing a SQL Server 2016 upgrade, it's important to understand numerous recommended pre- and post-installation best practices. Examine upgrade options, such as in-place and side-by-side upgrades.

WHAT YOU WILL LEARN

  • Create an upgrade strategy for sql server 2016
    Recognize the supported upgrade paths for sql server 2016
    Use the data migration assistance in sql server 2016
    Explain how to upgrade from sql server 2005
    Explain how and when to use the in-place upgrade option
  • Explain how and when to use the side-by-side upgrade option
    Describe hybrid and rolling upgrade options in sql server 2016
    Demonstrate how to use the upgrade advisor in sql server 2016
    Describe the sql server distributed replay feature
    Determine the appropriate installation options and features for a given scenario

IN THIS COURSE

  • 4m 51s
    In this video, you will learn how to create an upgrade strategy for SQL Server 2016. FREE ACCESS
  • 3m 9s
    After completing this video, you will be able to recognize the supported upgrade paths for SQL Server 2016. FREE ACCESS
  • Locked
    3.  Data Migration Assistant
    5m 54s
    In this video, you will learn how to use the data migration assistance in SQL Server 2016. FREE ACCESS
  • Locked
    4.  Upgrading from SQL Server 2005
    3m 36s
    After completing this video, you will be able to explain how to upgrade from SQL Server 2005. FREE ACCESS
  • Locked
    5.  In-place Upgrade
    3m 28s
    After completing this video, you will be able to explain how and when to use the in-place upgrade option. FREE ACCESS
  • Locked
    6.  Side-by-side Upgrade
    5m 26s
    After completing this video, you will be able to explain how and when to use the side-by-side upgrade option. FREE ACCESS
  • Locked
    7.  Hybrid and Rolling Upgrade Options
    4m 9s
    Upon completion of this video, you will be able to describe hybrid and rolling upgrade options for SQL Server 2016. FREE ACCESS
  • Locked
    8.  Upgrade Advisor
    5m 5s
    In this video, you will learn how to use the upgrade advisor in SQL Server 2016. FREE ACCESS
  • Locked
    9.  SQL Server Distributed Replay
    5m 21s
    After completing this video, you will be able to describe the SQL Server distributed replay feature. FREE ACCESS
  • Locked
    10.  Exercise: Choose Server 2016 Installation Options
    5m 58s
    In this video, you will learn how to determine the appropriate installation options and features for a given scenario. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Windows Client: Preparing to Install Windows 10
Rating 4.7 of 84 users Rating 4.7 of 84 users (84)
Course Windows 11 Installation Basics
Rating 4.6 of 16 users Rating 4.6 of 16 users (16)
Book Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database, 3rd Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Securing Azure SQL Databases
Rating 4.6 of 20 users Rating 4.6 of 20 users (20)
Course T-SQL Queries
Rating 4.3 of 218 users Rating 4.3 of 218 users (218)
Course Blockchains & Ethereum: Performing Transactions in Ethereum
Rating 4.5 of 40 users Rating 4.5 of 40 users (40)