Provisioning SQL Databases (Provisioning SQL DB)

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


  • Category
    Database
  • Duration
    5 Days (40 Hours)
  • Level
    Intermediate

What Will I Learn ?

After completing this course, students will be able to:
  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)
  • Provision, migrate and manage databases in the cloud

Prerequisite Knowledge

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

Who can benefits ?

    

Opportunity Scope

Mentor shall discuss on classroom.

Modules / Chapter

Module 1: SQL Server 2016 Components

This module describes the various SQL Server 2016 components and versions

  • Lessons:
    • Introduction to the SQL Server Platform
    • Overview of SQL Server Architecture
    • SQL Server Services and Configuration Options
  • Lab: Discussion: SQL Server versions
    • When we do use a separate installation of SQL Server and when would use a separate instance?
    • Which version of SQL Server is most suitable in your organization?

Module 2: Installing SQL Server 2016

This module describes the process to install SQL Server 2016.

  • Lessons:
    • Considerations for SQL Installing Server
    • Temp Db Files
    • Installing SQL Server 2016
    • Automating Installation
  • Lab: Installing SQL Server
    • Assess the available resources
    • Install an instance of SQL Server
    • Perform post installation checks
    • Automating Installation

Module 3: Upgrading SQL Server to SQL Server 2016

This module describes the process for upgrading to SQL Server 2016.

  • Lessons:
    • Upgrade Requirements
    • Upgrade SQL Server Services
    • Migrating SQL Server Data and Applications
  • Lab: Upgrading SQL Server
    • Create the Application Logins
    • Restore Database Backups
    • Orphaned Users and Database Compatibility Level



Module 4: Working with Databases

This module describes the reinstalled system databases, the physical structure of databases and the most common configuration options related to them.

  • Lessons:
    • Introduction to Data Storage with SQL Server
    • Managing Storage for System Databases
    • Managing Storage for User Databases
    • Moving and Copying Database Files
    • Side-by-Side Upgrade: Migrating SQL Server Data and Applications
    • Buffer Pool Extension
  • Lab: Managing Database Storage
    • Configuring tempdb Storage
    • Creating Databases
    • Attaching a Database
    • Enable Buffer Pool Extension

Module 5: Performing Database Maintenance

This module covers database maintenance plans.

  • Lessons:
    • Ensuring Database Integrity
    • Maintaining Indexes
    • Automating Routine Database Maintenance
  • Lab: Performing Database Maintenance
    • Use DB CC CHECK DB to Verify Database Integrity
    • Rebuild Indexes
    • Create a Database Maintenance Plan

Module 6: Database Storage Options

Describe SQL Server storage options.

  • Lessons:
    • SQL Server storage Performance
    • SMB File share
    • SQL Server Storage in Microsoft Azure
    • Stretch Databases
  • Lab: Implementing Stretch Database
    • Run Stretch Database Advisory
    • Implement Stretch Database

Module 7: Planning to Deploy SQL Server on Microsoft Azure

This module describes how to plan to deploy SQL Server on Azure.

  • Lessons:
    • SQL Server Virtual Machines in Azure
    • Azure Storage
    • Azure SQL Authentication
    • Deploying an Azure SQL Database
  • Lab: Plan and Deploy an Azure SQL Database
    • Plan an Azure SQL Database, Networking, performance tiers, security
    • Provision an Azure SQL Database
    • Connect to an Azure SQL Database

Module 8: Migrating Databases to Azure SQL Database

This module describes how to migrate databases to Azure SQL Database.

  • Lessons:
    • Database Migration Testing Tools
    • Database Migration Compatibility Issues
    • Migrating a SQL Server Database to Azure SQL Database
  • Lab: Migrating SQL Server Databases to Azure
    • Perform Migration Testing
    • Migrate a SQL Server Database to Azure SQL Database
    • Test a Migrated Database

Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine

This module describes how to deploy SQL Server on Microsoft Azure VMs

  • Lessons:
    • Deploying SQL Server on an Azure VM
    • The Deploy Database to a Microsoft Azure VM Wizard
  • Lab: Deploying SQL Server on an Azure Virtual Machine
    • Provision an Azure VM
    • Use the Deploy Database to Azure VM Wizard

Module 10: Managing databases in the Cloud

This module describes how to manage SQL Server on Azure.

  • Lessons:
    • Managing Azure SQL Database Security
    • Configure Azure storage
    • Azure Automation
  • Lab: Managing Databases in the Cloud
    • Configure Azure Security
    • Automate Azure Deployment.


Enquiry Form

Required fields are marked (*).

(Max 350 words only)

Contact Information

  • Address

    Anamnagar - 32 Kathmandu, Nepal

  • Email

    info@labanepal.com

  • Phone

    +977-1-4102721, 4102722, 4244804

  • Opening Hours

    10 AM - 5 PM

Registration Form

Required fields are marked (*).

(Max 350 words only)

Contact Information

  • Address

    Anamnagar - 32 Kathmandu, Nepal

  • Email

    info@labanepal.com

  • Phone

    +977-1-4102721, 4102722, 4244804

  • Opening Hours

    10 AM - 5 PM

newsletter

Sign Up for News and Offers

Subscribe for the latest news and great deals we offer