Provisioning SQL Databases
Days 5 Code20765 Fee £1985
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database.
Course Details
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
Prerequisites
Students should have the following prerequisite knowledge prior to attending this course:
-
Basic knowledge of the Microsoft Windows operating system and its core functionality.
-
Working knowledge of relational databases.
-
Working knowledge of Transact-SQL.
-
Some experience with database design
Course Outline
Module 1: SQL Server 2016 ComponentsDescribe the SQL Server platform, SQL Server services, and SQL Server configuration options.
Lessons
Lab : SQL Server Versions ( Discussion session) After completing this module, you will be able to:
Module 2: Installing SQL Server 2016 This modules describes the process to install SQL Server 2016. Lessons
Lab : Installing SQL Server After completing this module, you will be able to:
Module 3: Upgrading SQL Server to SQL Server 2016 This module describes how you go about upgrading your current SQL Server installation to SQL Server 2016. Lessons
Lab : Upgrading SQL Server After completing this module, you will be able to:
Module 4: Deploying SQL Server on Microsoft Azure This module describes the options available to run SQL Server on Azure. Lessons
Lab : Migrating SQL Server with Azure After completing this module, you will be able to:
Module 5: Working with Databases This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them. Lessons
Lab : Managing Database Storage After completing this module, you will be able to:
Module 6: Database Storage Options At the end of this module you will be able to describe the database storage options. Lessons
Lab : Implementing Stretch Database After completing this module, you will be able to:
Module 7: Performing Database Maintenance This module covers database maintenance. Lessons
Lab : Performing Ongoing Database Maintenance After completing this module, you will be able to:
|
Additional ReadingAfter completing this course, students will be able to:
|