LO035417 Professional Azure SQL Database Administration
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.
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
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 connectionSoftware: • 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 ArchitectureMigrating 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 MethodBacking up the SQL Database • Automatic Backups • Manual BackupsRestoring an Azure SQL Database • Restore TypesSecuring an Azure SQL Database • Access Control • Proactive Security • Scaling Out Azure SQL Database • Vertical Scaling • Horizontal ScalingElastic Pools • Introducing Elastic Pools • Elastic JobsHigh Availability and Disaster Recovery • High Availability • Disaster RecoveryMonitoring and Tuning Azure SQL Database • Monitoring an Azure SQL Database Using the Azure Portal • Tuning an Azure SQL Database
FOLLOW ON COURSES:
Not available. Please contact.
Additional information
