Provisioning SQL Databases Training from ICC Teleservices
Duration 40(Hrs)
Buy Now
COURSE OUTLINE
1 - SQL SERVER COMPONENTS
- Navigate the SQL Server Platform
- Learn About the SQL Server Architecture
- Get to Know SQL Server Services and Configuration Options
2 - INSTALLING SQL SERVER 2016
- Describe Key Considerations for Installing SQL Server
- Get Exposed to TempDB files
- Install SQL Server 2016
- Automate the Installation Process
- Lab: Installing SQL Server
3 - UPGRADING SQL SERVER TO SQL SERVER 2017
- Understand Upgrade Requirements
- Upgrade SQL Server Services
- Migrate SQL Server Data and Applications
- Perform a Side-by-Side Upgrade: Migrate SQL Server Data and Applications
- Lab : Upgrading SQL Server
4 - WORKING WITH DATABASES
- Learn How Data Storage Works with SQL Server
- Manage Storage for System and User Databases
- Move and Copy Database Files
- Configure Buffer Pool Extensions
- Lab : Managing Database Storage
5 - PERFORMING DATABASE MAINTENANCE
- Understand and Check Database Integrity
- Maintain Indexes
- Automate Routine Database Maintenance
- Lab: Performing Database Maintenance
6 - DATABASE STORAGE OPTIONS
- Get Familiar with SMB Fileshare
- Analyze SQL Server Storage Performance
- Configure SQL Server Storage in Microsoft Azure
- Work with Stretch Databases
- Lab: Implementing Stretch Database
7 - PLANNING TO DEPLOY SQL SERVER ON MICROSOFT AZURE
- Learn About SQL Server Virtual Machines in Azure
- Gain Exposure to Azure Storage
- Navigate Azure SQL Authentication, Auditing and Compliance
- Deploy an Azure SQL Database
- Lab: Plan and Deploy an Azure SQL Database
8 - MIGRATING DATABASES TO AZURE SQL DATABASE
- Practice Using Database Migration Testing Tools
- Resolve Migration Compatibility Issues
- Migrate a SQL Server Database to Azure SQL Database
- Lab: Migrating SQL Server Databases to Azure
9 - DEPLOYING SQL SERVER ON A MICROSOFT AZURE VIRTUAL MACHINE
- Deploy SQL Server on an Azure VM
- Move On-Premises Data Using the Deploy Database to an Azure VM Wizard
- Lab: Deploying SQL Server on an Azure Virtual Machine
10 - MANAGING DATABASES IN THE CLOUD
- Manage Azure SQL Database Security
- Configure Azure Storage
- Implement Azure Automation
- Lab: Managing Databases in the Cloud