SQL Azure Training

Azure SQL Database is Microsoft's Database as a Service offering. This course will help you get the latest and most on-demand Azure SQL and HA-DR Operations with Azure Databases. This course is helpful for anyone who wanted to step into Microsoft Cloud Technologies. This Azure Training course is completely practical ande real-time.

Trainer : Mr. Sai Phanindra T (11+ Yrs EXP). Profile

Timings (IST) Free Demo Start Date Register
Weekends 8 AM to 10 AM Oct 28th Nov 4th Register
** If above schedule does not work for you, please find below options :
 

Option 1: SQL Azure Training Videos - On-demand, 24x7 Access

 
Option 2: Interactive Training from other experienced faculty

 

SQL AZURE TRAINING HIGHLIGHTS


Daily Tasks & Lab Real-time Examples
Azure HD Insights PowerBI Integration
Azure Gateways Resume Guidance
All Trainings are completely practical and real-time.
 
ALL SESSIONS ARE COMPLETELY PRACTICAL, REAL-TIME.
Total Course Fee: 9000/- [USD 150]. Dur: 2 Weeks / 3 Wknds

SQL AZURE Training Course Contents:

Chapter 1: Design a hybrid SQL Server solution

  • Design a Disaster Recovery topology for a hybrid deployment, design a data storage architecture, design a security architecture, design a data load strategy, design a data synchronization strategy
  • Implement SQL Server on Azure Virtual Machines (VMs)
  • Provision SQL Server on an Azure VM, configure firewall rules, configure and optimize storage, migrate an on-premises database to Microsoft Azure, configure and optimize VM sizes by workload

Chapter 2: Design a hybrid SQL Server solution

  • Design a database solution on Azure SQL database and SQL Server in Azure
  • Design a solution architecture, design a Geo/DR topology, design a security architecture, design a data load strategy, determine the appropriate service tier, determine the appropriate deployment scenario, determine IaaS vs PaaS, determine application access in Azure

Chapter 3: Implement Azure SQL Database

  • Provision Azure SQL Database, configure firewall rules, configure Active GeoReplication, migrate an on-premises database to SQL Database, configure for scale and performance
  • Design and implement MySQL and PostgreSQL database solutions in Azure
  • Design security, design a data load strategy, determine the appropriate service tier, provision databases and servers, configure firewall rules, migrate to Azure, configure for scale and performance

Chapter 4: Design and implement SQL Server Database security

  • Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure Transparent Database Encryption (TDE); configure row-level security; configure data encryption; configure data masking; configure Always Encrypted
  • Design and implement Azure SQL Database security
  • Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure row-level security; configure data encryption; configure data masking; configure Always Encrypted, configure Automatic Threat Detection

Chapter 5: Design and implement High Availability Solutions

  • Design a high-availability solution topology, design a high-availability solution for SQL on Azure VMs, implement high-availability solutions
  • Design and implement scalable solutions
  • Design a scale-out solution, implement multi-master scenarios with database replication, implement elastic scale for Azure SQL Database
  • Design and implement Azure SQL Database data recovery
  • Implement self-service restore, copy and export databases, implement long-term retention backups

Chapter 6: Monitor and troubleshoot SQL Server VMs on Azure

  • Monitor database and instance activity, monitor by using DMVs and DMFs, monitor performance and scalability
  • Monitor and troubleshoot SQL Database
  • Monitor and troubleshoot SQL Database, monitor database activity, monitor by using DMVs and DMFs, monitor performance and scalability
  • Automate and manage database implementations on Azure
  • Automate and manage SQL Server on Azure VMs, automate and manage Azure SQL Database, configure automation and runbooks

Chapter 7: Real-time Project Database and Remote Cloud Access

Chapter 8: Interview FAQs and Certification Guidance for Microsoft Exam: 70-473

Register Today

Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 LIVE Server.
 

SQL Azure Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
  • Detailed Formula Engine with MDX
  • Basic to Advanced MDX Functions
  • MDX Integration with MSBI SSAS
  • MDX Integration with Power BI, Excel
  • MDX Constructs with Time Intelligence
  • Advanced MDX with Nested Sub Queries

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T