18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
United States
share button
Free Webinar: Database Recovery Models And Its Significance : July 29, 2020. 

20765: Provisioning SQL Databases Training


What 20765: Provisioning SQL Databases training is all about?

This Microtek Learning course is ideal for preparing candidates to the provisioning of SQL Server databases in On-premise and SQL Azure.

  • START DATE
  • CLASS TIMINGS
  • DELIVERY MODE
  • PRICE
  • ACTION
  • 08/10/2020
  • 9:00 am - 5:00 pm EST
  • $ 2012
  • 09/21/2020
  • 9:00 am - 5:00 pm EST
  • $ 2012
  • 10/26/2020
  • 9:00 am - 5:00 pm EST
  • $ 2012
  • 11/16/2020
  • 9:00 am - 5:00 pm EST
  • $ 2012
  • 12/14/2020
  • 9:00 am - 5:00 pm EST
  • $ 2012
What are the course objectives for 20765: Provisioning SQL Databases training?
  • Provisioning a Database Server
  • Upgrading SQL Server
  • Configuring SQL Server
  • Managing Databases and Shared Files
  • Provisioning, migrating, and managing cloud databases
Who should attend 20765: Provisioning SQL Databases training?

The users administering and maintaining SQL Server databases are the primary audience for this course. The users have administration and maintenance as their focus area and work around databases as their primary area of responsibility. The other audience suitable for the course are the users developing apps and feeding data via SQL server databases.

What is the course outline for 20765: Provisioning SQL Databases training?
  • 1. SQL Server Components
  • a). Introduction to the SQL Server Platform
  • b). Overview of SQL Server Architecture
  • c). SQL Server Services and Configuration Options
  • 2. Installing SQL Server
  • a). Considerations for SQL Installing Server
  • b). TempDB Files
  • c). Installing SQL Server
  • d). Automating Installation
  • e). Lab : Installing SQL Server
  • 3. Upgrading SQL Server to SQL Server 2017
  • a). Upgrade Requirements
  • b). Upgrade SQL Server Services
  • c). Side by Side Upgrade: Migrating SQL Server Data and Applications
  • d). Lab : Upgrading SQL Server
  • 4. Working with Databases
  • a). Introduction to Data Storage with SQL Server
  • b). Managing Storage for System Databases
  • c). Managing Storage for User Databases
  • d). Moving and Copying Database Files
  • e). Buffer Pool Extension
  • f). Lab : Managing Database Storage
  • 5. Performing Database Maintenance
  • a). Ensuring Database Integrity
  • b). Maintaining Indexes
  • c). Automating Routine Database Maintenance
  • d). Lab : Performing Database Maintenance
  • 6. Database Storage Options
  • a). SQL Server storage Performance
  • b). SMB Fileshare
  • c). SQL Server Storage in Microsoft Azure
  • d). Stretch Databases
  • e). Lab : Implementing Stretch Database
  • 7. Planning to Deploy SQL Server on Microsoft Azure
  • a). SQL Server Virtual Machines in Azure
  • b). Azure Storage
  • c). Azure SQL Authentication
  • d). Deploying an Azure SQL Database
  • e). Lab : Plan and Deploy an Azure SQL Database
  • 8. Migrating Databases to Azure SQL Database
  • a). Database Migration Testing Tools
  • b). Database Migration Compatibility Issues
  • c). Migrating a SQL Server Database to Azure SQL Database
  • d). Lab : Migrating SQL Server Databases to Azure
  • 9. Deploying SQL Server on a Microsoft Azure Virtual Machine
  • a). Deploying SQL Server on an Azure VM
  • b). The Deploy Database to a Microsoft Azure VM Wizard
  • c). Lab : Deploying SQL Server on an Azure Virtual Machine
  • 10. Managing databases in the Cloud
  • a). Managing Azure SQL Database Security
  • b). Configure Azure storage
  • c). Azure Automation
  • d). Lab : Managing Databases in the Cloud
Price: 2875
5 Days | $ 2012