academy-it-microsoft-office-vendor-training
  • academy-it-microsoft-office-vendor-training

55369A – Provisioning Databases on SQL Server

$4,100.00

About this course

This five-day instructor-led course is intended for IT professionals who are interested in expanding their knowledge base and technical skills about SQL Server. In this course, students learn how to provision SQL Server databases both on-premises and in Azure. The course covers new installations and migrations from existing installations.

Course Outline

 

Clear
SKU: 55369A Categories: , , , , , Tag:

Description

Audience Profile

This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.

At Course Completion

After completing this course, students will be able to:

  • Describe the components of SQL Server
  • Provision a database server that runs SQL Server
  • Upgrade a database server
  • Configure a new database on SQL Server
  • Maintain a database hosted on SQL Server
  • Configure storage for a database
  • Plan to deploy SQL Server on Microsoft Azure
  • Move a database from SQL Server on premises to Microsoft Azure
  • Provision SQL Server on an Azure virtual machine

Prerequisites

  • Basic understanding of relational databases
  • Basic Windows knowledge

Course Outline

Related products

  • academy-it-microsoft-office-vendor-training
    50331D – Windows Client , Enterprise Desktop Support Technician
    $4,100.00

    About this course

    (Updated for Windows 10 and Windows Server 2016) This three-day instructor-led course provides students with the knowledge and skills needed to isolate, document and resolve problems on Windows Desktops in a corporate domain. The material is geared towards corporate IT technicians that support Windows 7, 8 or 10 devices.

    PowerShell scripts and support files are now included to allow students to perform classroom lab exercises on their own time using Azure Virtual Machines.

    Course Outline

    Select options
  • academy-it-microsoft-office-vendor-training
    AZ-500T00 – Microsoft Azure Security Technologies
    $3,280.00

    About this course

    This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization’s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.

    Course Outline

    Select options
  • academy-it-microsoft-office-vendor-training
    MS-700T00 – Managing Microsoft Teams
    $3,280.00

    About this course

    The Managing Microsoft Teams course is designed for persons who are aspiring to the Microsoft 365 Teams Admin role. A Microsoft Teams administrator plans, deploys, configures, and manages Microsoft Teams to focus on efficient and effective collaboration and communication in a Microsoft 365 environment. In this course, you will learn about various Teams management tools, security and compliance feature for Teams, network requirement for Teams deployment as well as different Teams settings and policies for managing collaboration and communication experience in Teams.

    Course Outline

    Select options
  • academy-it-microsoft-office-vendor-training
    DP-300T00A – Administering Relational Databases on Microsoft Azure
    $3,280.00

    About this course

    This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

    Course Outline

     

     

    Select options