Provisioning SQL Databases
20765
Intermedio
DDBB SQL Server
30 horas
480 €
Convocatorias
Inicio - Fin
Horario  
No hay convocatorias abiertas
Contenido
Module 1: SQL Server 2016 Components
  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture
  • SQL Server Services and Configuration Options
Module 2: Installing SQL Server 2016
  • Considerations for SQL Installing Server
  • TempDB Files
  • Installing SQL Server 2016
  • Automating Installation
Module 3: Upgrading SQL Server to SQL Server 2016
  • Upgrade Requirements
  • Upgrade SQL Server Services
  • Migrating SQL Server Data and Applications
Module 4: Working with Databases
  • 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
Module 5: Performing Database Maintenance
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
Module 6: Database Storage Options
  • SQL Server storage Performance
  • SMB Fileshare
  • SQL Server Storage in Microsoft Azure
  • Stretch Databases
Module 7: Planning to Deploy SQL Server on Microsoft Azure
  • SQL Server Virtual Machines in Azure
  • Azure Storage
  • Azure SQL Authentication
  • Deploying an Azure SQL Database
Module 8: Migrating Databases to Azure SQL Database
  • Database Migration Testing Tools
  • Database Migration Compatibility Issues
  • Migrating a SQL Server Database to Azure SQL Database

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

  • Deploying SQL Server on an Azure VM
  • The Deploy Database to a Microsoft Azure VM Wizard
Module 10: Managing databases in the Cloud
  • Managing Azure SQL Database Security
  • Configure Azure storage
  • Azure Automation

Itinerario
Este curso pertenece al itinerario: