Database Design, Tools & Techniques with Azure SQL
Details
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
Outline
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
Speaker/s
Special Offer
Schedules
| Tue, Fri | 09:00 AM — 04:00 PM |
| No. of Days: | 4 |
Alpha Partners is a reputable firm of Training and Management Consultants with many years of corporate training experience in Finance, Accounting, Auditing, Banking, Management, Information Technology, Oil and Gas Sector, Security, Engineering, Public Relations, Secretarial Studies, Leadership, Marketing and other fields of human endeavour.
We are one of the leading players in the profession. Our firm, a multi-disciplinary one with highly talented, experienced and dedicated partners and staff who have experiences in different facets of working life was established in 1996 and has branches in Lagos, Enugu and Awka.
We offer a wide range of professional services, which covers audits, accounting, finance, taxation, ICT, security, engineering, insurance, human resources management, secretarial and consultancy services in all ramifications.
Our numerous clients attest to the high quality services we offer which contribute in no small measure in ensuring sound and efficient management of their resources.
Related Courses
