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

ENC9K-Implementing Cisco Catalyst 9000 Switches

This course includes Cisco Training Exclusives

EXCLUSIVE TO GLOBAL KNOWLEDGE – Accelerate your Cisco learning experience with complimentary access to the IT Skills Video On-Demand Library, Introduction to Cybersecurity digital learning course, course recordings, IT Resource Library, and digital courseware.

Learn more

This hands-on course covers many features of the Cisco IOS XE platform and describes how to manage devices from a single dashboard, the Cisco DNA Center. You will learn how to use the Cisco Catalyst 9000 family of switches to enable Software Defined Access (SD-Access) and provide end-to-end security and automation with centralized management using DNA Center.

Uncategorized

Developing websites using IBM Web Content Manager 8

IBM Web Content Manager is a powerful solution that delivers engaging, personalized web experiences across multiple channels. It keeps content relevant, consistent, and drives higher conversion rates, improves customer loyalty, and increases user engagement. This course is designed to introduce experienced web developers to the concepts and skills necessary to build a website and authoring system using IBM Web Content manager. Through hands-on exercises, web developers will go through the entire lifecycle process from planning through development and delivery. This version of the course specifically addresses new features in IBM Web Content Manager 8.0 such as:

New topics such as WCM tags, CTC, Page templates, and Managed Pages
New authoring environment that uses basic and standard home page
Change management features such as Project Workflow

Uncategorized

Supporting Windows 8.1(M20688)

In this course, you will gain the knowledge and skills required to support a Windows 8.1 deployment in a medium and large enterprise environment. You will learn to resolve technical issues by developing a troubleshooting methodology for Windows 8.1.

This course incorporates materials from the Official Microsoft Learning Product 20688 Managing and Maintaining Windows 8 and it can assist you in your preparation for Exam 70-688: Supporting Windows 8.1.

Uncategorized

Exam Readiness: AWS Certified Advanced Networking ï¿½ Specialty

The AWS Certified Advanced Networking ? Specialty exam validates advanced technical skills and experience designing and implementing AWS and hybrid IT network architectures at scale. As a networking specialist, you will design a secure, scalable, and highly available network infrastructure on AWS while addressing requirements like network security, hybrid IT connectivity, network integration with other AWS services, routing techniques, and network troubleshooting.