Flash Sale: Save 15% on IT Training

closeClose

Provisioning SQL Databases

  • Tuition USD $2,696 Save $300
  • Reviews star_rate star_rate star_rate star_rate star_half 1508 Ratings
  • Course Code 20765
  • Duration 5 days
  • Available Formats Virtual, Classroom



This 5 day instructor
led training course teaches students how to provision SQL databases both on
premise and in SQL Azure.


Skills Gained

Aftercompleting 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

Who Can Benefit

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

Thiscourse requires that you meet the following prerequisites:

  • Basic knowledge of the Microsoft Windows operating systemand its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design

Course Details

Outline


Module 1: SQL Server Components
This module describes the various SQL Server components and versions.
Lessons

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

Aftercompleting this module, you will be able to:
  • Describe SQL Server components and versions.
  • Describe SQL Server architecture and resource usage.
  • Describe SQL Server services and how you manage the configuration of those services.

Module 2: Installing SQL Server
This modules describes the process to install SQL Server 2016.
Lessons
  • Considerations for SQL Installing Server
  • TempDB Files
  • Installing SQL Server
  • Automating Installation

Lab : Installing SQL Server
  • Preparing to install SQL Server
  • Install an instance of SQL Server
  • Perform post installation checks
  • Automating Installation

Aftercompleting this module, you will be able to:
  • Describe the considerations when installing SQL Server.
  • Describe TempDB files.
  • Install SQL Server.
  • Automate a SQL Server installation.

Module 3: Upgrading SQL Server to SQL Server 2017
This module describes the process for upgrading to SQL Server 2017.
Lessons
  • Upgrade Requirements
  • Upgrade SQL Server Services
  • Side by Side Upgrade: Migrating SQL Server Data and Applications

Lab : Upgrading SQL Server
  • Create the Application Logins
  • Restore the backups of the TSQL Database
  • Orphaned Users and Database Compatibility Level

Aftercompleting this module, you will be able to:
  • Describe the upgrade requirements for SQL Server.
  • Upgrade SQL Server.
  • Migrate SQL Server data and applications.

Module 4: Working with Databases
This module describes the preinstalled 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
  • Buffer Pool Extension

Lab : Managing Database Storage
  • Configuring tempdb Storage
  • Creating Databases
  • Attaching a Database
  • Enable Buffer Pool Extension

Aftercompleting this module, you will be able to:
  • Describe Data Storage with SQL Server.
  • Manage Storage for System Databases.
  • Manage Storage for User Databases.
  • Move and Copy Database Files.
  • Describe and use Buffer Pool Extensions.

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 DBCC CHECKDB to Verify Database Integrity
  • Rebuild Indexes
  • Create a Database Maintenance Plan

Aftercompleting this module, you will be able to:
  • Ensure Database Integrity.
  • Maintain Indexes.
  • Automate Routine Database Maintenance.

Module 6: Database Storage Options
Describe SQL Server storage options.
Lessons
  • SQL Server storage Performance
  • SMB Fileshare
  • SQL Server Storage in Microsoft Azure
  • Stretch Databases

Lab : Implementing Stretch Database
  • Run Stretch Database Advisor
  • Implement Stretch Database

Aftercompleting this module, you will be able to:
  • Describe SQL Server Storage Performance.
  • Describe SMB Fileshare.
  • Explain SQL Server Storage in Microsoft Azure.
  • Describe 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

Aftercompleting this module, you will be able to:
  • Describe SQL Server Virtual Machines in Azure.
  • Describe Azure Storage.
  • Explain Azure SQL Authentication, auditing and compliance.
  • Deploy 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

After completing this module, students will be able to:
  • Describe various database migration testing tools.
  • Explain database migration compatibility issues.
  • Migrate a SQL Server database to Azure SQL 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

After completing this module, students will be able to:
  • Deploy SQL Server on an Azure VM.
  • Use The Deploy Database to a Microsoft Azure VM Wizard.
  • Configure SQL Server Connections

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
  • Add data masking
  • Use Azure automation to stop Virtual Machines

After completing this module, students will be able to:
  • Manage Azure SQL Database Security.
  • Configure Azure storage.
  • Implement Azure Automation.

Additional Reading

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

The instructor really took his time and made sure I was able to understand the concepts.

This was my second course through ExitCertified, and it continues to be a great way to learn and advance my career!

well organized and designed course. Tommy is good teacher and answer our all the questions

Thank you for the opportunity which let me enjoy the Core Spring class. Looking forward for more classes

This course gave me a clearer understanding of the AWS cloud architecture.

3 options available

undo
  • Jan 25, 2021 Jan 29, 2021 (5 days)
    Location
    Virtual
    Language
    English
    Time
    08:30 16:30 EST
    Enroll
    Enroll
  • Mar 8, 2021 Mar 12, 2021 (5 days)
    Location
    Virtual
    Language
    English
    Time
    11:30 19:30 EST
    Enroll
    Enroll
  • Mar 29, 2021 Apr 2, 2021 (5 days)
    Location
    iMVP
    Language
    English
    Time
    9:00AM 5:00PM EDT
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward