This is a 3-day course which balances theory and hand-on applications that are focused on practical takeaways to learn Azure SQL Database.
This course complies with instructional designing principles for all the 9 lessons. This will ensure that you repeat and reinforce your gained knowledge at every step. Each and every minute spent during this 3-day course will incrementally take you to a next level.
TARGET AUDIENCE:
This course is for database administrators, database developers, or application developers interested in developing new or migrating existing applications with Azure SQL Database.
Prior experience of working on an on-premises SQL Server, and should have knowledge of PowerShell and C# are the prerequisites for this course.
COURSE PREREQUISITES:
Hardware:
For successful completion of this course, students will require computer systems with the following:
• Intel Core i5 or equivalent Processor: i3
• Memory: 8 GB RAM
• Hard disk: 20 GB
• Projector
• Internet connection
Software:
• OS: Windows 8 or above
• Browser: Latest version of Google Chrome
• SQL Server Management Studio 17.2 or above
• Microsoft Azure PowerShell
• Microsoft RML Utilities
• Microsoft® Data Migration Assistant v3.4
• SQL Server 2016 Feature pack
COURSE CONTENT:
Microsoft Azure SQL Database Primer
• Azure SQL Database Architecture
Migrating an SQL Server Database to an Azure SQL Database
• Azure SQL Database Service Tiers
• Determining an Appropriate Service Tier
• Determining Compatibility Issues
• Determining the Migration Method
Backing up the SQL Database
• Automatic Backups
• Manual Backups
Restoring an Azure SQL Database
• Restore Types
Securing an Azure SQL Database
• Access Control
• Proactive Security
• Scaling Out Azure SQL Database
• Vertical Scaling
• Horizontal Scaling
Elastic Pools
• Introducing Elastic Pools
• Elastic Jobs
High Availability and Disaster Recovery
• High Availability
• Disaster Recovery
Monitoring and Tuning Azure SQL Database
• Monitoring an Azure SQL Database Using the Azure Portal
• Tuning an Azure SQL Database
COURSE OBJECTIVE:
If you are interested in developing new or migrating existing applications with Azure SQL Database, then this course is for you.
The course will provide enough knowledge of the following:
• Provision a new Azure SQL Database or Migrate an existing on-premise SQL Server database to Azure SQL Database
• Backup and restore Azure SQL Database
• Secure and scale an Azure SQL Database
• Monitor and tune an Azure SQL Database
• Implement high availability and disaster recovery with Azure SQL Database
• Automate common management tasks with PowerShell
• Develop a scalable cloud solution with SQL Database
FOLLOW ON COURSES:
Not available. Please contact.