20765 Provisioning SQL Databases

Are you looking for hands-on experience provisioning a SQL Server database? This course from Network Technology Academy will equip you with the skills you need to level up in your data career. In the Provisioning SQL Databases course, you will learn how to configure and manage SQL Server databases both on-premises and in SQL Azure.

After finishing this course, you’ll understand the key steps involved in provisioning SQL Server databases. You’ll be able to configure, upgrade and manage SQL Server with confidence. This course empowers you to:

  • Provision a database server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage shared databases and files
  • Set up, migrate and manage databases in the cloud

Course Outline
1 - SQL SERVER COMPONENTS
  • Navigate the SQL Server Platform
  • Learn About the SQL Server Architecture
  • Get to Know SQL Server Services and Configuration Options
2 - INSTALLING SQL SERVER 2016
  • Describe Key Considerations for Installing SQL Server
  • Get Exposed to TempDB files
  • Install SQL Server 2016
  • Automate the Installation Process
  • Lab: Installing SQL Server
3 - UPGRADING SQL SERVER TO SQL SERVER 2017
  • Understand Upgrade Requirements
  • Upgrade SQL Server Services
  • Migrate SQL Server Data and Applications
  • Perform a Side-by-Side Upgrade: Migrate SQL Server Data and Applications
  • Lab : Upgrading SQL Server
4 - WORKING WITH DATABASES
  • Learn How Data Storage Works with SQL Server
  • Manage Storage for System and User Databases
  • Move and Copy Database Files
  • Configure Buffer Pool Extensions
  • Lab : Managing Database Storage
5 - PERFORMING DATABASE MAINTENANCE
  • Understand and Check Database Integrity
  • Maintain Indexes
  • Automate Routine Database Maintenance
  • Lab: Performing Database Maintenance
6 - DATABASE STORAGE OPTIONS
  • Get Familiar with SMB Fileshare
  • Analyze SQL Server Storage Performance
  • Configure SQL Server Storage in Microsoft Azure
  • Work with Stretch Databases
  • Lab: Implementing Stretch Database
7 - PLANNING TO DEPLOY SQL SERVER ON MICROSOFT AZURE
  • Learn About SQL Server Virtual Machines in Azure
  • Gain Exposure to Azure Storage
  • Navigate Azure SQL Authentication, Auditing and Compliance
  • Deploy an Azure SQL Database
  • Lab: Plan and Deploy an Azure SQL Database
8 - MIGRATING DATABASES TO AZURE SQL DATABASE
  • Practice Using Database Migration Testing Tools
  • Resolve Migration Compatibility Issues
  • Migrate a SQL Server Database to Azure SQL Database
  • Lab: Migrating SQL Server Databases to Azure
9 - DEPLOYING SQL SERVER ON A MICROSOFT AZURE VIRTUAL MACHINE
  • Deploy SQL Server on an Azure VM
  • Move On-Premises Data Using the Deploy Database to an Azure VM Wizard
  • Lab: Deploying SQL Server on an Azure Virtual Machine
10 - MANAGING DATABASES IN THE CLOUD
  • Manage Azure SQL Database Security
  • Configure Azure Storage
  • Implement Azure Automation
  • Lab: Managing Databases in the Cloud

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

This course is SATV-Eligible
All class times shown are in Pacific Standard Time (PST)

Contact Us For Price

Course Length: 5 Days

1. Choose a Date | 2. Click Enroll Now
Need Help Picking the Right Course? Give us a call! 781-388-0026
Awaiting product image

Description

After finishing this course, you’ll understand the key steps involved in provisioning SQL Server databases. You’ll be able to configure, upgrade and manage SQL Server with confidence.

This course empowers you to:

  • Provision a database server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage shared databases and files
  • Set up, migrate and manage databases in the cloud

Reviews

There are no reviews yet.

Be the first to review “20765 Provisioning SQL Databases”

Your email address will not be published. Required fields are marked *

Related products

© Copyright - Network Technology Academy
20764 Administering a SQL Database Infrastructure 20767 Implementing a SQL Data Warehouse