Professional Azure SQL Database Administration
- Course Code LO035417
- Duration 3 days
Course Delivery
Additional Payment Options
-
GTC 16 inc. VAT
GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details
Jump to:
Course Delivery
This course is available in the following formats:
-
Company Event
Event at company
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopThis 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.
Company Events
These events can be delivered exclusively for your company at our locations or yours, specifically for your delegates and your needs. The Company Events can be tailored or standard course deliveries.
Course Schedule
TopTarget Audience
TopThis 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 Objectives
TopIf 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
Course Content
TopMicrosoft 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 Prerequisites
TopHardware:
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
