Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Azure Database Services for Government
- Overview of the Azure SQL family: SQL Database, Managed Instance, and SQL Server on Virtual Machines
- Understanding service tiers and pricing models for government
- Use cases for cloud-hosted relational databases in public sector operations
Provisioning and Configuration for Government
- Creating Azure SQL resources using the portal and templates
- Configuring elastic pools and managed instances for government
- Managing firewall rules and connectivity for secure public sector operations
Backup, Restore, and High Availability for Government
- Understanding built-in backup and restore features for government
- Enabling geo-replication and failover groups for enhanced resilience in government systems
- Implementing high availability and disaster recovery strategies for government operations
Monitoring and Performance Tuning for Government
- Using Query Performance Insight and Extended Events for government
- Optimizing indexes and reviewing query plans to enhance performance in public sector databases
- Analyzing telemetry, alerts, and resource consumption for effective monitoring in government environments
Security and Compliance for Government
- Implementing authentication methods (SQL and Azure Active Directory) for secure access
- Managing encryption, auditing, and threat detection to meet government compliance standards
- Securing data access and enforcing role-based security in public sector applications
Automation and Maintenance for Government
- Automating routine tasks with Azure Automation and Runbooks for efficient operations
- Scheduling jobs using the Elastic Jobs Agent to streamline maintenance processes
- Addressing database updates, patching, and service level agreement (SLA) considerations for government systems
Summary and Next Steps for Government
- Reviewing key takeaways and best practices for optimizing Azure SQL services in the public sector
- Exploring certification options, such as DP-300, to enhance skills in government IT roles
- Identifying resources for ongoing learning and professional development in government technology environments
Requirements
- Experience with relational database concepts and SQL for government applications
- Familiarity with fundamental database administration practices
- Basic understanding of cloud computing, particularly within the Azure environment
Audience
- Database administrators responsible for managing cloud-hosted relational databases in a government setting
- IT professionals transitioning on-premise databases to Azure for government use
- Cloud engineers and architects supporting database operations within government agencies
28 Hours
