We may earn an affiliate commission when you visit our partners.
SQL Server
Upgrading and Migrating to SQL Server 2016
Glenn Berry
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.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/5hbceq/sql
What's inside
Syllabus
Course Overview
Introduction
Upgrade Planning
Upgrade Testing
Read more
Syllabus
Course Overview
Introduction
Upgrade Planning
Upgrade Testing
Read more
Migration Planning
Migration Testing
Production Migration
Good to know
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
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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.
Review database fundamentals
Show steps
Reviewing database fundamentals will provide a strong foundation for understanding the concepts covered in this course.
Browse courses on
Database Fundamentals
Show steps
Show steps
Show steps
- Review relational database concepts (tables, columns, rows, keys)
- Practice writing basic SQL queries
Review SQL Server 2012
Show steps
Refresh your knowledge of SQL Server 2012 to prepare for the upgrade to SQL Server 2016.
Show steps
Show steps
Show steps
- Review the SQL Server 2012 documentation.
- Take a SQL Server 2012 online course.
Attend a SQL Server 2016 upgrade workshop
Show steps
Gain hands-on experience upgrading to SQL Server 2016 in a guided environment.
Browse courses on
SQL Server 2016
Show steps
Show steps
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
Show steps
Follow a step-by-step guide to upgrade to SQL Server 2016 to gain practical skills.
Browse courses on
SQL Server 2016
Show steps
Show steps
Show steps
- Find a SQL Server 2016 upgrade tutorial online.
- Follow the steps in the tutorial.
Practice installation scenarios
Show steps
Practice using various tools to ensure successful installation of SQL Server 2016.
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
Practice using various tools to identify and resolve upgrade blockers.
Browse courses on
SQL Server
Show steps
Show steps
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
Show steps
Creating a detailed document of your upgrade plan and process helps you stay organized, identify potential issues, and ensure a smooth migration.
Show steps
Show steps
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
Show steps
Practice creating a detailed plan for migrating databases to SQL Server 2016.
Show steps
Show steps
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
For more career information including salaries, visit:
OpenCourser.com/course/5hbceq/sql
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.
Save
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.
Save
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/5hbceq/sql
Share
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
OpenCourser.com/course/pz05gx/sql
SQL Server: Installing and Configuring SQL Server 2016
Most relevant
SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping
OpenCourser.com/course/173zi9/sql
SQL Server: Understanding, Configuring, and...
Most relevant
SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring
OpenCourser.com/course/6ea1gy/sql
SQL Server: Understanding, Configuring and...
Most relevant
Solving Real World Problems with SQL Server 2016 Query Store
OpenCourser.com/course/5jqq0l/solving
Solving Real World Problems with SQL Server 2016 Query...
Most relevant
SQL Server 2016 New Features for Developers
OpenCourser.com/course/atoog8/sql
SQL Server 2016 New Features for Developers
Most relevant
Practical SQL Server Security, Compliance, and Auditing
OpenCourser.com/course/syvh6d/practical
Practical SQL Server Security, Compliance, and Auditing
Most relevant
Migrating from Microsoft SQL Server to Amazon DynamoDB
OpenCourser.com/course/c4unaf/migrating
Migrating from Microsoft SQL Server to Amazon DynamoDB
Most relevant
SQL Server Administration: (SQL Server Integration Services)
OpenCourser.com/course/bo4rtq/sql
SQL Server Administration: (SQL Server Integration...
Most relevant
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
OpenCourser.com/course/bfrjcd/sql
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
Most relevant
Time
132 hours
Level
Intermediate
Via
Pluralsight
Instructor
Glenn Berry
Language
English
Good to know
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
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