We may earn an affiliate commission when you visit our partners.
Glenn Berry

This course will teach you how to correctly prepare for and perform an upgrade/migration to SQL Server 2016. You'll learn how to plan considerations, tools for finding upgrade blockers, and various methods for moving the data.

Read more

This course will teach you how to correctly prepare for and perform an upgrade/migration to SQL Server 2016. You'll learn how to plan considerations, tools for finding upgrade blockers, and various methods for moving the data.

When moving to a new version of SQL Server, it's important to plan and test the upgrade process and use a risk-free migration approach that limits application downtime. In this course, SQL Server: Upgrading and Migrating to SQL Server 2016, you'll learn how to do all of these things. First, you'll discover how to choose the correct Edition of SQL Server 2016, install it correctly, and how to use various tools to find upgrade blockers and breaking changes. Next, you'll explore some of the ways to make a migration go more quickly and find problems after the migration. Finally, you'll learn the methods available for migrating databases to SQL Server 2016. When you've finished with this course, you'll have the skills and knowledge needed to plan and execute an upgrade/migration to SQL Server 2016 successfully.

Enroll now

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

What's inside

Syllabus

Course Overview
Introduction
Upgrade Planning
Upgrade Testing
Read more
Migration Planning
Migration Testing
Production Migration

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Explores the methods to identify and remediate upgrade blockers, strategies for migrating data quickly, and methods for migrating databases to SQL Server 2016 which are valuable skills for database administrators
Taught by Glenn Berry, an industry expert in SQL Server and database migration, giving students an edge in understanding the latest technologies
Covers the core concepts of planning, performing, and testing an upgrade/migration to SQL Server 2016, which are valuable skills for database administrators

Save this course

Save SQL Server: Upgrading and Migrating to SQL Server 2016 to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL Server: Upgrading and Migrating to SQL Server 2016 with these activities:
Review database fundamentals
Reviewing database fundamentals will provide a strong foundation for understanding the concepts covered in this course.
Browse courses on Database Fundamentals
Show steps
  • Review relational database concepts (tables, columns, rows, keys)
  • Practice writing basic SQL queries
Review SQL Server 2012
Refresh your knowledge of SQL Server 2012 to prepare for the upgrade to SQL Server 2016.
Show steps
  • Review the SQL Server 2012 documentation.
  • Take a SQL Server 2012 online course.
Attend a SQL Server 2016 upgrade workshop
Gain hands-on experience upgrading to SQL Server 2016 in a guided environment.
Browse courses on SQL Server 2016
Show steps
  • Find a SQL Server 2016 upgrade workshop in your area.
  • Register for the workshop.
  • Attend the workshop.
Six other activities
Expand to see all activities and additional details
Show all nine activities
Follow a SQL Server 2016 upgrade tutorial
Follow a step-by-step guide to upgrade to SQL Server 2016 to gain practical skills.
Browse courses on SQL Server 2016
Show steps
  • Find a SQL Server 2016 upgrade tutorial online.
  • Follow the steps in the tutorial.
Practice installation scenarios
Practice using various tools to ensure successful installation of SQL Server 2016.
Show steps
  • Install SQL Server 2016 using the graphical interface.
  • Install SQL Server 2016 using the command prompt.
  • Install SQL Server 2016 using a silent installation.
Database Upgrade Simulation Exercises
Practice upgrading an existing database to SQL Server 2016 in a simulated environment. This helps solidify understanding of the upgrade process and potential issues.
Browse courses on Database Upgrade
Show steps
  • Set up a test environment with a copy of your existing database.
  • Perform the upgrade using the tools and methods covered in the course.
  • Test the upgraded database for functionality and performance.
Test upgrade blockers
Practice using various tools to identify and resolve upgrade blockers.
Browse courses on SQL Server
Show steps
  • Use the SQL Server Upgrade Advisor to identify potential upgrade blockers.
  • Use the Database Compatibility Checker to identify potential compatibility issues.
  • Use the Data Migration Assistant to identify potential data migration issues.
Document Your Upgrade Plan and Process
Creating a detailed document of your upgrade plan and process helps you stay organized, identify potential issues, and ensure a smooth migration.
Show steps
  • Gather information about your current database environment.
  • Define the scope and objectives of the upgrade.
  • Create a step-by-step plan for the upgrade process.
  • Identify potential risks and mitigation strategies.
  • Document the entire process for future reference.
Develop a migration plan
Practice creating a detailed plan for migrating databases to SQL Server 2016.
Show steps
  • Identify the source and target databases.
  • Choose a migration method.
  • Create a rollback plan.
  • Test the migration plan.
  • Execute the migration plan.

Career center

Learners who complete SQL Server: Upgrading and Migrating to SQL Server 2016 will develop knowledge and skills that may be useful to these careers:
Data Architect
A Data Architect designs and manages data systems. They work with stakeholders to understand business needs and translate those needs into technical requirements. Data Architects also develop and implement data management strategies. This course can help you become a Data Architect by teaching you how to plan and execute an upgrade/migration to SQL Server 2016. You'll learn how to choose the correct Edition of SQL Server 2016, install it correctly, and how to use various tools to find upgrade blockers and breaking changes. You'll also learn about the different methods available for migrating databases to SQL Server 2016.
Database Administrator
A Database Administrator (DBA) is responsible for the day-to-day operation and maintenance of databases. They ensure that databases are available, performant, and secure. DBAs also work with developers to design and implement new database systems. This course can help you become a DBA by teaching you how to plan and execute an upgrade/migration to SQL Server 2016. You'll learn how to choose the correct Edition of SQL Server 2016, install it correctly, and how to use various tools to find upgrade blockers and breaking changes. You'll also learn about the different methods available for migrating databases to SQL Server 2016.
Data Warehouse Engineer
A Data Warehouse Engineer designs and develops data warehouse systems. They work with stakeholders to understand business needs and translate those needs into technical requirements. Data Warehouse Engineers also develop and implement data warehouse solutions.
Data Analyst
A Data Analyst uses data to solve business problems. They collect, clean, and analyze data to identify trends and patterns. Data Analysts also present their findings to stakeholders in a clear and concise way. This course can help you become a Data Analyst by teaching you how to plan and execute an upgrade/migration to SQL Server 2016. You'll learn how to use SQL Server 2016 to query and analyze data. You'll also learn about the different methods available for migrating databases to SQL Server 2016.
Database Developer
A Database Developer designs and develops database systems. They work with stakeholders to understand business needs and translate those needs into technical requirements. Database Developers also develop and implement database solutions.
Systems Analyst
A Systems Analyst analyzes and designs business systems. They work with stakeholders to understand business needs and translate those needs into technical requirements. Systems Analysts also develop and implement business solutions.
Project Manager
A Project Manager plans and manages projects. They work with stakeholders to understand project goals and objectives. Project Managers also develop and implement project plans.
Business Analyst
A Business Analyst analyzes and designs business processes. They work with stakeholders to understand business needs and translate those needs into technical requirements. Business Analysts also develop and implement business solutions.
Software Engineer
A Software Engineer designs, develops, and tests software applications. They work with stakeholders to understand business needs and translate those needs into technical requirements. Software Engineers also develop and implement software solutions.
Network Administrator
A Network Administrator is responsible for the planning, implementation, and management of computer networks. They work with stakeholders to understand business needs and translate those needs into technical requirements. Network Administrators also develop and implement network strategies.
IT Manager
An IT Manager is responsible for the planning, implementation, and management of IT systems. They work with stakeholders to understand business needs and translate those needs into technical requirements. IT Managers also develop and implement IT strategies.
Security Analyst
A Security Analyst is responsible for the planning, implementation, and management of security systems. They work with stakeholders to understand business needs and translate those needs into technical requirements. Security Analysts also develop and implement security strategies.
Help Desk Analyst
A Help Desk Analyst provides technical support to users. They answer questions and resolve problems over the phone, email, or chat.
Technical Writer
A Technical Writer creates and maintains technical documentation. They work with subject matter experts to understand technical concepts and translate those concepts into clear and concise writing.
Computer Support Specialist
A Computer Support Specialist provides technical support to users. They troubleshoot and resolve computer problems. Computer Support Specialists also install and configure software and hardware.

Reading list

We've selected 11 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in SQL Server: Upgrading and Migrating to SQL Server 2016.
Provides a comprehensive overview of high availability and disaster recovery strategies for SQL Server 2016. Covers topics such as clustering, mirroring, and log shipping.
Covers the fundamentals of SQL injection attacks and provides techniques for preventing and mitigating them in SQL Server applications. Useful for developers and security professionals concerned with database security.
Comprehensive guide to understanding and optimizing SQL Server execution plans. It covers everything from basic plan analysis to advanced performance tuning techniques.
Provides a comprehensive overview of SQL Server security, including authentication, authorization, encryption, and auditing. It is an essential resource for anyone who wants to protect their SQL Server databases from unauthorized access and attacks.
Provides a comprehensive overview of SQL Server performance tuning, including performance monitoring, query optimization, and index design. It is an essential resource for anyone who wants to improve the performance of their SQL Server databases.
Provides a comprehensive overview of SQL Server data warehousing, including data modeling, data integration, and data analysis. It is an essential resource for anyone who wants to build and manage a SQL Server data warehouse.
Provides a comprehensive overview of SQL Server BI development, including data modeling, data visualization, and reporting. It is an essential resource for anyone who wants to build and manage a SQL Server BI solution.
Provides a comprehensive overview of SQL Server machine learning, including data preparation, model building, and model deployment. It is an essential resource for anyone who wants to use SQL Server to build and deploy machine learning models.
Provides a comprehensive overview of SQL Server Power BI, including data modeling, data visualization, and reporting. It is an essential resource for anyone who wants to build and manage a SQL Server Power BI solution.
Provides a comprehensive overview of SQL Server Azure, including database creation and management, data migration, and security. It is an essential resource for anyone who wants to build and manage a SQL Server Azure solution.
Provides advanced coverage of SQL Server 2016 query performance tuning. It valuable resource for anyone who wants to improve the performance of their SQL Server queries.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to SQL Server: Upgrading and Migrating to SQL Server 2016.
SQL Server: Installing and Configuring SQL Server 2016
Most relevant
SQL Server: Understanding, Configuring, and...
Most relevant
SQL Server: Understanding, Configuring and...
Most relevant
Solving Real World Problems with SQL Server 2016 Query...
Most relevant
SQL Server 2016 New Features for Developers
Most relevant
Practical SQL Server Security, Compliance, and Auditing
Most relevant
Migrating from Microsoft SQL Server to Amazon DynamoDB
Most relevant
SQL Server Administration: (SQL Server Integration...
Most relevant
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser