Provisioning SQL Databases (M20765)

COURSE OUTLINE:

Description

This course provides you with the knowledge and skills to provision a Microsoft SQL Server 2016 database. You will cover SQL Server 2016 provision both on-premise and in Azure, and youï¿½ll cover installing from new and migrating from an existing install.

This course incorporates material from the Official Microsoft Learning Product 20765: Provisioning SQL Databases.

Audience

Individuals who administer and maintain SQL Server databases, performing database administration and maintenance as their primary area of responsibility, or who work in environments where databases play a key role in their primary job.
Individuals who develop applications that deliver content from SQL Server databases.

Prerequisites

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design.

Learning Objectives

Provision a database server.
Upgrade SQL Server.
Configure SQL Server.
Manage databases and files (shared).

Course Outline:

1. SQL Server 2016 Components

Introduction to the SQL Server Platform
Overview of SQL Server Architecture
SQL Server Services and Configuration Options

2. Installing SQL Server 2016

Considerations for Installing SQL Server
TempDB Files
Installing SQL Server 2016
Automating Installation

3. Upgrading SQL Server to SQL Server 2016

Upgrade Requirements
Upgrade SQL Server Services
Migrating SQL Server Data and Applications

4. Deploying SQL Server on Microsoft Azure

SQL Server Virtual Machines in Azure
Deploying an Azure SQL Database
Migrating an On-Premise Database to an Azure SQL Database

5. Working with Databases

Overview of SQL Server Databases
Creating Databases
Database Files and Filegroups
Moving Database Files
Buffer Pool Extension

6. Database Storage Options

SQL Server Storage Performance
SMB Fileshare
SQL Server Storage in Azure
Stretch Databases

7. Performing Database Maintenance

Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

RELATED COURSES

Uncategorized

AIX Network Installation Manager (NIM): Concepts and Configuration

Learn the fundamental capabilities of the Network Installation Management (NIM) facility of the AIX 6 operating system.

This course uses a combination of instructor lecture and machine exercises to provide you with practical background knowledge.

Uncategorized

SAP HANA Introduction (HA100v12)

In this course, you will get an overview of SAP HANA. You will learn about in-memory computing, SAP HANA architecture and main implementation scenarios. You will also learn about modeling and data processing, data provisioning, as well as the different types of applications that run on SAP HANA, such as SAP BI tools, SAP Business Warehouse and SAP HANA XS applications. This course is also valuable for everyone who is part of an S/4HANA project, as it helps understand the key innovations in SAP Business Suite that the underlying SAP HANA Platform permits.

This course is based on software release:

SAP HANA SPS12

Uncategorized

AWS Certification Prep Toolkit: SysOps Administrator ï¿½ Associate

Preparing for the AWS Certified SysOps Administrator – Associate exam will be hard work. In addition to hands-on experience and supporting resources, youï¿½ll need authorized Systems Operations on AWS training, exam readiness workshops and an exam voucher to be fully prepared. Exclusive to Global Knowledge is the AWS Certification Prep Toolkit, which includes the three-day Systems Operations on AWS training, the SysOps Administrator – Associate Exam Readiness Workshop and an Associate-level Exam Voucher, at a valuable rate.

What do you get with your AWS Certification Prep Toolkit?

Choose to take the hands-on training course in a classroom, virtually or in an onsite, private group training session ï¿½ followed by the exam readiness workshop virtually. Use your voucher when youï¿½re ready to book your AWS exam at a PSI testing center.

Uncategorized

Enabling & Managing Office 365 (M20347)

In this course, you will learn to evaluate, plan, deploy, and operate Microsoft Office 365 services, including its identities, dependencies, requirements, and supporting technologies. You will learn the skills required to set up and sustain an Office 365 tenant and users.

GK Digital Learning is also available with digital Microsoft Official Courseware (dMOC). Click hereï¿½to purchase.

ï¿½