• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/05/2018 11/09/2018
  • VLT
Live Online
12/03/2018 12/07/2018
  • VLT
Live Online

20765: Provisioning SQL Databases Course 

20765: Provisioning SQL Databases course is intended to show understudies how to arrangement SQL Server databases both on preface and in SQL Azure. 

20765: Provisioning SQL Databases Audience Profile 

The essential gathering of people for 20765: Provisioning SQL Databases course is people who regulate and keep up SQL Server databases. These people perform database organization and support as their essential region of duty, or work in situations where databases assume a key part in their essential occupation. 

The auxiliary gatherings of people for 20765: Provisioning SQL Databases course are people who create applications that convey content from SQL Server databases. 

  • At Course Completion
  • Subsequent to finishing this course, understudies will have the capacity to: 
  • Arrangement a Database Server 
  • Update SQL Server 
  • Design SQL Server 
  • Oversee Databases and Files (shared) 
  • Arrangement, relocate and oversee databases in the cloud 

20765: Provisioning SQL Databases Course Outline 

Module 1: SQL Server 2016 Components 

20765: Provisioning SQL Databases module depicts the different SQL Server 2016 parts and forms. 

Lessons 

  • Prologue to the SQL Server Platform 
  • Outline of SQL Server Architecture 
  • SQL Server Services and Configuration Options 

Lab : Discussion: SQL Server forms 

  • When we do utilize a different establishment of SQL Server and when might utilize a different case? 
  • Which variant of SQL Server is most appropriate in your association? 

In the wake of finishing this module, you will have the capacity to: 

  • Portray SQL Server parts and forms. 
  • Depict SQL Server engineering and asset utilization. 
  • Depict SQL Server administrations and how you deal with the setup of those administrations. 

Module 2: Installing SQL Server 2016 

20765: Provisioning SQL Databases modules portrays the procedure to introduce SQL Server 2016. 

Lessons 

  • Contemplations for SQL Installing Server 
  • TempDB Files 
  • Introducing SQL Server 2016 
  • Computerizing Installation 

Lab : Installing SQL Server 

  • Survey the accessible assets 
  • Introduce an occasion of SQL Server 
  • Perform post establishment checks 
  • Robotizing Installation 

Subsequent to finishing this module, you will have the capacity to: 

  • Depict the contemplations when introducing SQL Server. 
  • Portray TempDB documents. 
  • Introduce SQL Server 2016. 
  • Mechanize a SQL Server establishment. 

Module 3: Upgrading SQL Server to SQL Server 2016 

20765: Provisioning SQL Databases module portrays the procedure for moving up to SQL Server 2016. 

Lessons 

  • Overhaul Requirements 
  • Overhaul SQL Server Services 
  • Moving SQL Server Data and Applications 

Lab : Upgrading SQL Server 

  • Make the Application Logins 
  • Reestablish Database Backups 
  • Stranded Users and Database Compatibility Level 

In the wake of finishing this module, you will have the capacity to: 

  • Portray the update necessities for SQL Server. 
  • Overhaul SQL Server. 
  • Move SQL Server information and applications. 

Module 4: Working with Databases 

20765: Provisioning SQL Databases module portrays the preinstalled framework databases, the physical structure of databases and the most widely recognized design alternatives identified with them. 

Lessons 

  • Prologue to Data Storage with SQL Server 
  • Overseeing Storage for System Databases 
  • Overseeing Storage for User Databases 
  • Moving and Copying Database Files 
  • One next to the other Upgrade: Migrating SQL Server Data and Applications 
  • Cradle Pool Extension 

Lab : Managing Database Storage 

  • Arranging tempdb Storage 
  • Making Databases 
  • Appending a Database 
  • Empower Buffer Pool Extension 

In the wake of finishing this module, you will have the capacity to: 

  • Portray Data Storage with SQL Server. 
  • Oversee Storage for System Databases. 
  • Oversee Storage for User Databases. 
  • Move and Copy Database Files. 
  • Portray the Side-by-Side Upgrade: Migrating SQL Server Data and Applications process. 
  • Portray and utilize Buffer Pool Extensions. 

Module 5: Performing Database Maintenance 

20765: Provisioning SQL Databases module covers database upkeep designs. 

Lessons 

  • Guaranteeing Database Integrity 
  • Looking after Indexes 
  • Mechanizing Routine Database Maintenance 

Lab : Performing Database Maintenance 

  • Utilize DBCC CHECKDB to Verify Database Integrity 
  • Reconstruct Indexes 
  • Make a Database Maintenance Plan 

In the wake of finishing this module, you will have the capacity to: 

  • Guarantee Database Integrity. 
  • Look after Indexes. 
  • Mechanize Routine Database Maintenance. 

Module 6: Database Storage Options 

Portray SQL Server stockpiling alternatives. 

Lessons 

  • SQL Server stockpiling Performance 
  • SMB Fileshare 
  • SQL Server Storage in Microsoft Azure 
  • Extend Databases 

Lab : Implementing Stretch Database 

  • Run Stretch Database Advisor 
  • Execute Stretch Database 

In the wake of finishing this module, you will have the capacity to: 

  • Depict SQL Server Storage Performance. 
  • Depict SMB Fileshare. 
  • Clarify SQL Server Storage in Microsoft Azure. 
  • Depict Stretch Database. 

Module 7: Planning to Deploy SQL Server on Microsoft Azure 

20765: Provisioning SQL Databases module depicts how to plan to convey SQL Server on Azure. 

Lessons 

  • SQL Server Virtual Machines in Azure 
  • Sky blue Storage 
  • Purplish blue SQL Authentication 
  • Sending an Azure SQL Database 

Lab : Plan and Deploy an Azure SQL Database 

  • Plan an Azure SQL Database, Networking, execution levels, security 
  • Arrangement an Azure SQL Database 
  • Interface with an Azure SQL Database 

In the wake of finishing this module, you will have the capacity to: 

  • Portray SQL Server Virtual Machines in Azure. 
  • Portray Azure Storage. 
  • Clarify Azure SQL Authentication, evaluating and consistence. 
  • Send an Azure SQL Database. 

Module 8: Migrating Databases to Azure SQL Database 

20765: Provisioning SQL Databases module portrays how to relocate databases to Azure SQL Database. 

Lessons 

  • Database Migration Testing Tools 
  • Database Migration Compatibility Issues 
  • Moving a SQL Server Database to Azure SQL Database 

Lab : Migrating SQL Server Databases to Azure 

  • Perform Migration Testing 
  • Move a SQL Server Database to Azure SQL Database 
  • Test a Migrated Database 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray different database relocation testing devices. 
  • Clarify database movement similarity issues. 
  • Move a SQL Server database to Azure SQL database. 

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

20765: Provisioning SQL Databases module portrays how to convey SQL Server on Microsoft Azure VMs. 

Lessons 

  • Sending SQL Server on an Azure VM 
  • The Deploy Database to a Microsoft Azure VM Wizard 

Lab : Deploying SQL Server on an Azure Virtual Machine 

  • Arrangement an Azure VM 
  • Utilize the Deploy Database to Azure VM Wizard 

In the wake of finishing this module, understudies will have the capacity to: 

  • Send SQL Server on an Azure VM. 
  • Utilize The Deploy Database to a Microsoft Azure VM Wizard. 

Module 10: Managing databases in the Cloud 

20765: Provisioning SQL Databases module portrays how to oversee SQL Server on Azure. 

Lessons 

  • Overseeing Azure SQL Database Security 
  • Arrange Azure stockpiling 
  • Purplish blue Automation 

Lab : Managing Databases in the Cloud 

  • Arrange Azure Security 
  • Computerize Azure Deployment 

In the wake of finishing this module, understudies will have the capacity to: 

  • Oversee Azure SQL Database Security. 
  • Arrange Azure stockpiling. 
  • Actualize Azure Automation.

This course requires you meet the accompanying essentials: 

  • Essential learning of the Microsoft Windows working framework and its center usefulness. 
  • Working information of Transact-SQL. 
  • Working information of social databases. 
  • Some involvement with database plan

Awards