Database Design, Tools & Techniques with Azure SQL Online Training

  • Time

    10:00am - 3:00pm

  • End Date

    23 May, 2022 - 25 May, 2022

  • Price

    ₦200,000

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.

 

DATE:

1ST BATCH: 23rd – 25th May, 2022                          

2ND BATCH: 7th – 9th Nov, 2022  

Other Dates

Start Date End Date
07 Nov, 2022 09 Nov, 2022
Start Date End Date
23 May, 2022 25 May, 2022

Share this course