Goals
- Understand how to install or update a SQL Server instance
- Have the necessary skills for database maintenance
- Know how to optimize aspects relating to information storage
- Be able to migrate a local database to SQL Azure
Program
SQL Server
Services Architecture and Configuration Options Server
Installation, Automation
TempDB Files
Workshop – Installation of SQL Server and configuration of services
Upgrade prerequisites
Updating services
Migration management
Workshop – SQL Server Update Considerations
SQL Server Databases
Creating Databases, Features
Managing Files and Filegroups
Moving Database Files
Buffer Pool Extension
Workshop – SQL Server database management
Database integrity
Index management
Automation of database maintenance
Workshop – Database maintenance strategies
SQL Server Storage Performance
SMB
Stretch Databases File Share
Workshop – Performance measurement and file sharing
SQL Server Virtual Machines in Azure
Deploying a SQL Azure database
Migrating a database to MS Azure: tools, compatibility
Deploying SQL Server on an Azure VM
Managing databases in the cloud
Workshop – Deployment of SQL Server in MS Azure
Passing of the certification (if foreseen in the financing)
Duration
5 days
Price
£ 2599
Audience
Database administrators and developers
Prerequisites
Have taken the "SQL Server 2016 (20764) Administration of a database infrastructure" training course or equivalent knowledge
Reference
BAS100744-F
Sessions
Contact us for more informations about session date