Training agenda
  1. SQL Server Components

    • Introduction to the SQL Server Platform
    • Overview of SQL Server Architecture
    • SQL Server Services and Configuration Options
  2.  Installing SQL Server

    • Considerations for SQL Installing Server
    • TempDB Files
    • Installing SQL Server
    • Automating Installation
  3.  Upgrading SQL Server to SQL Server 2017

    • Upgrade Requirements
    • Upgrade SQL Server Services
    • Side by Side Upgrade: Migrating SQL Server Data and Applications
  4.  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
    • Buffer Pool Extension
  5.  Performing Database Maintenance 

    • Ensuring Database Integrity
    • Maintaining Indexes
    • Automating Routine Database Maintenance
  6.  Database Storage Options

    • SQL Server storage Performance
    • SMB Fileshare
    • SQL Server Storage in Microsoft Azure
    • Stretch Databases
  7. Planning to Deploy SQL Server on Microsoft Azure

    • SQL Server Virtual Machines in Azure
    • Azure Storage
    • Azure SQL Authentication
    • Deploying an Azure SQL Database
  8.  Migrating Databases to Azure SQL Database

    • Database Migration Testing Tools
    • Database Migration Compatibility Issues
    • Migrating a SQL Server Database to Azure SQL Database
  9.  Deploying SQL Server on a Microsoft Azure Virtual Machine

    • Deploying SQL Server on an Azure VM
    • The Deploy Database to a Microsoft Azure VM Wizard
  10.  Managing databases in the Cloud

    • Managing Azure SQL Database Security
    • Configure Azure storage
    • Azure Automation