Event Details
The Database Design, Tools and Techniques with Azure SQL workshop is created to provide participants with skills and knowledge useful in designing and building database/ database applications with the Azure SQL Database system. It is a cloud database service that is based on Microsoft's SQL Server. It is compatible with most SQL Server features and is optimized for Software-as-a-Service (SaaS) and Database-as-a- Service (DBaaS) applications. Participants also get to learn to administer and secure their Azure databases.
CONTENT
Azure SQL Database Primer
- Introduction
- The Azure SQL Database Architecture
- Provisioning an Azure SQL Database
- Differences between Azure SQL Database and SQL Server
- Introduction to Managed Instance
- Connecting to SQL Managed Instance
Migrating a SQL Server Database to an Azure SQL Database
- Database Transaction Units (DTU) Pricing Models
- Choosing Between a vCore Pricing Model and DTU-based Service Tiers
- Azure Database Migration Services
Backing Up and Restoring an Azure SQL Database
- Automatic Backups
- Manual Backups
- Restore Types
Securing an Azure SQL Database
- Access Control
- Authentication
- Azure SQL Database Authentication Structure
- Authorization
- Creating Contained Database Users for Azure AD Authentication
- Advanced Data Security
- Auditing
Scaling out an Azure SQL Database
- Vertical Scaling
Azure SQL Database Elastic Pools
- Introducing Elastic Pools
- Elastic Database Jobs
High Availability and Disaster Recovery
- High Availability
- Accelerated Database Recovery (ADR)
- Disaster Recovery
- Synchronous Replication
Monitoring and Tuning Azure SQL Database
- Monitoring an Azure SQL Database Using the Azure Portal
- Monitoring Queries Using the Query Performance Insight Blade
- Monitoring an Azure SQL Database Using DMVs
- Tuning an Azure SQL Database
Database Features
- Azure SQL Data Sync
- Online and Resumable Data Definition Language (DDL) Operations
- SQL Graph Queries and Improvements
FOR WHOM: CIOs, IT Development Managers, Heads of Department, System Administrators/Engineers, IT Professionals and others who want to sharpen their knowledge in IT world.
TRAINING METHODOLOGY
The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.
This course is available in the following locations:
Nigeria - $5500
Rwanda - $7500
UK - $8500
USA - $8500