OD20765: MoD 20765: Provisioning SQL Databases (On Demand)

*1  exkl. 19% MwSt. / *2  inkl. 19% MwSt.

This Online-Training covers the following topics:

  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture
  • SQL Server Services and Configuration Options
  • 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?
  • 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.
  • Considerations for SQL Installing Server
  • TempDB Files
  • Installing SQL Server 2016
  • Automating Installation
  • Assess the available resources
  • Install an instance of SQL Server
  • Perform post installation checks
  • Automating Installation
  • Describe the considerations when installing SQL Server.
  • Describe TempDB files.
  • Install SQL Server 2016.
  • Automate a SQL Server installation.
  • Upgrade Requirements
  • Upgrade SQL Server Services
  • Migrating SQL Server Data and Applications
  • Create the Application Logins
  • Restore Database Backups
  • Orphaned Users and Database Compatibility Level
  • Describe the upgrade requirements for SQL Server.
  • Upgrade SQL Server.
  • Migrate SQL Server data and applications.
  • 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
  • Configuring tempdb Storage
  • Creating Databases
  • Attaching a Database
  • Enable Buffer Pool Extension
  • Describe Data Storage with SQL Server.
  • Manage Storage for System Databases.
  • Manage Storage for User Databases.
  • Move and Copy Database Files.
  • Describe the Side-by-Side Upgrade: Migrating SQL Server Data and Applications process.
  • Describe and use Buffer Pool Extensions.
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Use DBCC CHECKDB to Verify Database Integrity
  • Rebuild Indexes
  • Create a Database Maintenance Plan
  • Ensure Database Integrity.
  • Maintain Indexes.
  • Automate Routine Database Maintenance.
  • SQL Server storage Performance
  • SMB Fileshare
  • SQL Server Storage in Microsoft Azure
  • Stretch Databases
  • Run Stretch Database Advisor
  • Implement Stretch Database
  • Describe SQL Server Storage Performance.
  • Describe SMB Fileshare.
  • Explain SQL Server Storage in Microsoft Azure.
  • Describe Stretch Database.
  • SQL Server Virtual Machines in Azure
  • Azure Storage
  • Azure SQL Authentication
  • Deploying an Azure SQL Database
  • Plan an Azure SQL Database, Networking, performance tiers, security
  • Provision an Azure SQL Database
  • Connect to an Azure SQL Database
  • Describe SQL Server Virtual Machines in Azure.
  • Describe Azure Storage.
  • Explain Azure SQL Authentication, auditing and compliance.
  • Deploy an Azure SQL Database.
  • Database Migration Testing Tools
  • Database Migration Compatibility Issues
  • Migrating a SQL Server Database to Azure SQL Database
  • Perform Migration Testing
  • Migrate a SQL Server Database to Azure SQL Database
  • Test a Migrated Database
  • Describe various database migration testing tools.
  • Explain database migration compatibility issues.
  • Migrate a SQL Server database to Azure SQL database.
  • Deploying SQL Server on an Azure VM
  • The Deploy Database to a Microsoft Azure VM Wizard
  • Provision an Azure VM
  • Use the Deploy Database to Azure VM Wizard
  • Deploy SQL Server on an Azure VM.
  • Use The Deploy Database to a Microsoft Azure VM Wizard.
  • Managing Azure SQL Database Security
  • Configure Azure storage
  • Azure Automation
  • Configure Azure Security
  • Automate Azure Deployment
  • Manage Azure SQL Database Security.
  • Configure Azure storage.
  • Implement Azure Automation.

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.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.

  • 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

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10–12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

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

  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)
  • Provision, migrate and manage databases in the cloud
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As a Microsoft Gold Learning Partner, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 29. June 2017

Auf Wunsch bieten wir Ihnen maßgeschneiderte Trainings an – Ort, Zeit und Themenauswahl können Sie selbst bestimmen. Sprechen Sie uns einfach auf unsere individuellen Trainings an, wir beraten Sie gerne.

Unsere Standorte
  • Adresse:
    Kurfürsten-Anlage 64-68
    69115 Heidelberg
  • Telefon:
    06221 8322-0
  • E-Mail:

GFN Geschäftszeiten
  • Montag - Freitag: 9 Uhr bis 18 Uhr

Kontaktformular


Jetzt neu bei der GFN AG
Beliebte Kurse