Provisioning SQL Databases

MS SQL Server

Hands On Technology Transfer, Inc.
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure. Topics include an overview SQL Server 2016 components and versions; database maintenance plans;SQL Server storage options; planning to deploy SQL Server on Azure; migrating databases to Azure SQL Database; deploying SQL Server on Microsoft Azure virtual machines and managing SQL Server on Azure.
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
This is primarily ilt training
book
workshop / seminarThis is a workshop seminar
group study and discussionThis class may involve group study
coursewareCourseware may be available for purchase
instructor led trainingThis class may be available at a classroom in Chelmsford, MA, or at one of these training facilities: Chelmsford, MA, Irving, TX, San Jose, CA, Schaumburg, IL, Altamonte Springs, FL, Houston, TX, Santa Ana, CA,
Course Level:basic
Duration:5 days
Training Presented in:English
Training Provided by Hands On Technology Transfer, Inc.
Provisioning SQL Databases
SQL Server 2016 Components
  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture and Resource Usage
  • SQL Server Services and Configuration Options
  • Separate Installation of SQL Server vs a Separate Instance
  • Deciding Which Version of SQL Server is Most Suitable
Installing SQL Server 2016
  • Considerations for SQL Installing Server
  • TempDB Files
  • Installing SQL Server 2016
    • Performing Post Installation Checks
  • Automating a SQL Server Installation
Upgrading SQL Server to SQL Server 2016
  • Upgrade Requirements for SQL Server
  • Upgrading SQL Server Services
  • Migrating SQL Server Data and Applications
  • Creating the Application Logins
  • Restoring Database Backups
Working with Databases
  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving and Copying Database Files
  • Migrating SQL Server Data and Applications
  • Using Buffer Pool Extensions
  • Configuring TempDB Storage
  • Creating Databases
  • Attaching a Database
Performing Database Maintenance
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Using DBCC CHECKDB to Verify Database Integrity
  • Rebuilding Indexes
  • Creating a Database Maintenance Plan
Database Storage Options
  • SQL Server Storage Performance
  • SMB Fileshare
  • SQL Server Storage in Microsoft Azure
  • Implementing Stretch Databases
  • Running Stretch Database Advisor
Deploying SQL Server on Microsoft Azure
  • SQL Server Virtual Machines in Azure
  • Azure Storage
  • Azure SQL Authentication
  • Planning an Azure SQL Database, Networking, Performance Tiers and Security
  • Provisioning an Azure SQL Database
  • Connecting to an Azure SQL Database
  • Deploying an Azure SQL Database
Migrating Databases to Azure SQL Database
  • Performing Migration Testing
  • Database Migration Compatibility Issues
  • Migrating a SQL Server Database to Azure SQL Database
  • Testing a Migrated Database
Deploying SQL Server on a Microsoft Azure Virtual Machine
  • Deploying SQL Server on an Azure Virtual Machine
  • Using the Deploy Database to a Microsoft Azure Virtual Machine Wizard
  • Provisioning an Azure Virtual Machine
Managing Databases in the Cloud
  • Managing Azure SQL Database Security
  • Configuring Azure storage
  • Automating Azure Automation
About The Training Provider: Hands On Technology Transfer, Inc.
Hands On Technology Transfer, Inc. - Hands On Technology Transfer, Inc. (HOTT) offers competency-based IT training programs in more than 75 cities across the United States, Canada and the United Kingdom, covering over 60 IT subject areas. These programs are designed with one main goal - making sure you and your staff will be competent and productive. Topics include .NET, SQL, Java, Mobile Programming, UNIX/ Linux, HTML5,...
Do you offer provisioning sql databases training?
Custom Search
tcw11-v473M-12/11/17-18:40:46-()[B]-[B]-[A] -10:14:20