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

Nutanix Enterprise Cloud Platform Administration [V5.5]

The course covers all of the tasks Nutanix administrators perform, including configuring and maintaining a Nutanix environment. It also introduces basic Nutanix troubleshooting tools, offers tips for solving common problems and provides guidelines for escalating problems to Nutanix support.

Uncategorized

Configuring Cisco MDS 9000 Series Switches (DCMDS) v3.0

Through expert instruction and extensive hands-on practice the DCMDS – Configuring Cisco MDS 9000 Series Switches v3.0 course teaches you how to deploy and use capabilities such as virtual storage area networks (VSANs), Role-Based Access Control (RBAC), N-Port Virtualization (NPV) fabric security, zoning, automation with NX-API,ï¿½ Slow Drain Analysis, Fibre Channel over TCP/IP (FCIP) tunnels, and more. You will learn how to configure and implement platform features and learn troubleshooting techniques pertaining to Fibre Channel (FC) domains, firmware upgrades, zones, and zone mergers.

Uncategorized

Oracle 12c Advanced SQL

In this course, you will receive a hands-on introduction to advanced SQL concepts, especially as they relate to Oracle’s implementation of the SQL Language. Topics necessary to the development and administration of an Oracle 12c database are covered. This course is specifically designed for those who know generic SQL but are not familiar with SQL*Plus and more importantly, Oracle’s implementation of SQL.

Uncategorized

Access Control, Authentication, and Public Key Infrastructure

This course defines the components of access control, provides a business framework for implementation, and discusses legal requirements that impact access control programs. It looks at the risks, threats, and vulnerabilities prevalent in information systems and IT infrastructures and how to handle them. It provides learners a professional resource detailing how to put access control systems to work in addition to how to test and manage them.

In addition to premium instructional content from Jones & Bartlett Learning’s comprehensive Information Systems Security and Assurance (ISSA) curriculum, this course provides access to a customized "virtual sandbox" learning environment that aggregates an unparalleled spectrum of cybersecurity applications. Providing instant, unscheduled access to labs from the convenience of a web-browser, this course allows you to practice "white hat" hacking on a real IT infrastructureï¿½these are not simulations. Winner of the "Security Training and Educational Programs" top prize at the prestigious 2013 Global Excellence Awards by Info Security Products Guide, the industry’s leading information security research and advisory guide, these labs provide valuable exposure to complex, real world challenges and overï¿½20 hours of training exercises on how hackers and perpetrators use these applications and tools.

Certification:

This course covers content within the following industry certification exams:

System Security Certified Practitioner (SSCP) – two content domains covered
ï¿½Certified Information Systems Security Professional (CISSP) – four content domains covered
ï¿½Security + – one content domain covered
ï¿½National Institute of Standards and Technology (NIST) – five content domains covered
ï¿½8570.01 – two content domains covered