SQL Azure Training

SQL Azure (Microsoft Azure SQL Database) is a cloud-based, elegant technology for creating and using databases in Microsoft Cloud. Easy UI and Faster, reliable deliverables with SQL Server Cloud. We at SQL School offer complete real-time and practical on SQL Azure Trainings.

SQL Azure (SQL Database) Training Schedules

 
Schedule Timings (IST) Free Demo Start Date Register
1 6:30 AM - 8 AM
Recently Started
Register
2 10:00 AM - 11:30 AM Dec 8th Dec 8th Register
3 7 PM - 8:30 PM Coming Soon Register

None of the above schedules work for you? opt for On-demand, Self Paced Video Training Course

Pre-requisites: Participant should have knowledge on SQL Server &/ Admin Concepts to attend this course.

Trainer : Mr Sai Phanindra T (11+ Yrs Exp)

Dur : 6 Days (1 Hr per day)

Course Fee : INR 4000/- (USD 60)


COURSE HIGHLIGHTS
Server, DB Insights DR Drills, Threat Detection
Security & Firewall Geo Replication
Azure VM, AD Sync MCSA Certification

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

 
EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. Register Today
 

Who can benefit from this SQL Azure Online Training course?

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