TypeClassroom Training
Time5 Days
REGISTER

Contact Us

Fields marked with an * are required
Provisioning SQL Databases Training Course & Certification

Provisioning SQL Databases Training Course & Certification

Description

Audience & Prerequisites

Certification

Provisioning SQL Databases Training Course

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

Objectives of Provisioning SQL Databases Training

  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)
  • Provision, migrate and manage databases in the cloud

Intended Audience for Provisioning SQL Databases Course

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.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Prerequisites Provisioning SQL Databases Certification

This course requires that you meet the following 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

For more info kindly contact us.

Section 1SQL Server 2016 Components
Lecture 1Introduction to the SQL Server Platform
Lecture 2Overview of SQL Server Architecture
Lecture 3SQL Server Services and Configuration Options
Lecture 4Lab: When we do use a separate installation of SQL Server and when would use a separate instance?
Lecture 5Lab: Which version of SQL Server is most suitable in your organization?
Section 2Installing SQL Server 2016
Lecture 6Considerations for SQL Installing Server
Lecture 7TempDB Files
Lecture 8Installing SQL Server 2016
Lecture 9Automating Installation
Lecture 10Lab: Assess the available resources
Lecture 11Lab: Install an instance of SQL Server
Lecture 12Lab: Perform post installation checks
Lecture 13Lab: Automating Installation
Section 3Upgrading SQL Server to SQL Server 2016
Lecture 14Upgrade Requirements
Lecture 15Upgrade SQL Server Services
Lecture 16Migrating SQL Server Data and Applications
Lecture 17Lab: Create the Application Logins
Lecture 18Lab: Restore Database Backups
Lecture 19Lab: Orphaned Users and Database Compatibility Level
Section 4Working with Databases
Lecture 20Introduction to Data Storage with SQL Server
Lecture 21Managing Storage for System Databases
Lecture 22Managing Storage for User Databases
Lecture 23Moving and Copying Database Files
Lecture 24Side-by-Side Upgrade: Migrating SQL Server Data and Applications
Lecture 25Buffer Pool Extension
Lecture 26Lab: Configuring tempdb Storage
Lecture 27Lab: Creating Databases
Lecture 28Lab: Attaching a Database
Lecture 29Lab: Enable Buffer Pool Extension
Section 5Enable Buffer Pool Extension
Lecture 30Ensuring Database Integrity
Lecture 31Maintaining Indexes
Lecture 32Automating Routine Database Maintenance
Lecture 33Lab: Use DBCC CHECKDB to Verify Database Integrity
Lecture 34Lab: Rebuild Indexes
Lecture 35Lab: Create a Database Maintenance Plan
Section 6Database Storage Options
Lecture 36SQL Server storage Performance
Lecture 37SMB Fileshare
Lecture 38SQL Server Storage in Microsoft Azure
Lecture 39Stretch Databases
Lecture 40Lab: Run Stretch Database Advisor
Lecture 41Lab: Implement Stretch Database
Section 7Planning to Deploy SQL Server on Microsoft Azure
Lecture 42SQL Server Virtual Machines in Azure
Lecture 43Azure Storage
Lecture 44Azure SQL Authentication
Lecture 45Deploying an Azure SQL Database
Lecture 46Lab: Plan an Azure SQL Database, Networking, performance tiers, security
Lecture 47Lab: Provision an Azure SQL Database
Lecture 48Lab: Connect to an Azure SQL Database
Section 8Migrating Databases to Azure SQL Database
Lecture 49Database Migration Testing Tools
Lecture 50Database Migration Compatibility Issues
Lecture 51Migrating a SQL Server Database to Azure SQL Database
Lecture 52Lab: Perform Migration Testing
Lecture 53Lab: Migrate a SQL Server Database to Azure SQL Database
Lecture 54Lab: Test a Migrated Database
Section 9Deploying SQL Server on a Microsoft Azure Virtual Machine
Lecture 55Deploying SQL Server on an Azure VM
Lecture 56The Deploy Database to a Microsoft Azure VM Wizard
Lecture 57Lab: Provision an Azure VM
Lecture 58Lab: Use the Deploy Database to Azure VM Wizard
Section 10Managing databases in the Cloud
Lecture 59Managing Azure SQL Database Security
Lecture 60Configure Azure storage
Lecture 61Azure Automation
Lecture 62Lab: Configure Azure Security
Lecture 63Lab: Automate Azure Deployment