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

Fundamentals of IBM Watson Explorer Deep Analytics Edition oneWEX (v12.0.x)

This course is designed to teach you core concepts of IBM Watson Explorer Deep Analytics Edition oneWEX. You will learn to identify the oneWEX platforms as well as the process flow and data flow of oneWEX projects. You will explore oneWEX tools, such as Content Miner and the Admin Console, while gaining hands-on experience in data acquisition and enrichment. Finally, you will be exposed to more advanced topics, such as Application Builder, Content Analytics Studio, and API usage.

Uncategorized

Security in the Google Cloud Platform

This full-day instructor-led course helps prospective candidates structure their preparation for the Professional Data Engineer exam. The session will cover the structure and format of the examination, as well as its relationship to other Google Cloud certifications. Through lectures, quizzes, and discussions, candidates will familiarize themselves with the domain covered by the examination, so as to help them devise a preparation strategy. Rehearses useful skills including exam question reasoning and case comprehension. Tips. Review of topics from the Data Engineering curriculum.

Uncategorized

Developing Solutions with IBM Decision Server Insights V8.8

This course is also available in the On-Demand delivery format with Developing Solutions with IBM Decision Server Insights V8.8 (ZB399G). This option does not require any travel.

In this course, you learn about the main features of the Decision Server Insights component of IBM Operational Decision Manager Advanced V8.8.

Decision Server Insights enables real-time, in-memory, rule-based, event-driven, and analytical decision making. You experience how to use analytics, time-based reasoning, and location-based reasoning to build a real-world solution that detects and responds to business situations. You also learn the key capabilities of the multi-agent architecture of Decision Server Insights by developing several agents that are bound to a single entity for different purposes.

This course focuses on solution development, deployment, testing, and administration. You learn how to implement the business logic that detects business situations and uses situational context to decide and take the next best action.

The course begins with an overview of the programming model for Decision Server Insights and the architecture for the Decision Server Insights runtime environment. You learn how to design a Decision Server Insights solution, model the business entities and events that you care about, and implement the business logic. You work with a realistic test client to test the behavior of your implementation after deployment.

The course also covers administration topics, including installation, configuration of the Decision Server Insights reference topology, solution deployment in a grid environment, and grid administration.

Uncategorized

DCINX9K ï¿½ Introducing Cisco Nexus 9000 Switches in NX-OS Mode v2.0

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

The DCINX9K – Introducing Cisco Nexus 9000 Switches in NX-OS Mode v2.0 course shows you how to implement, manage, and troubleshoot Cisco Nexus 9000 Series Switches in Cisco NX-OS mode. Through expert instruction and extensive hands-on learning, you will learn how to deploy capabilities including Virtual Extensible LAN (VXLAN), Multiprotocol Label Switching (MPLS), high availability features, Intelligent Traffic Director, troubleshooting tools and techniques, NX-OS programmability features, and open interface technologies. The course also provides an introduction to Cisco Data Center Network Manager (DCNM) for management.