₹0 Cart
4.60(5)

Azure SQL-DBA (Advanced)

  • Course level: Expert

Description

Course Includes

  1. Azure SQL DB Architecture
  2. Migrations
  3. HA – DR
  4. Security
  5. LINUX
  6. PowerShell
  7. Virtual Machines

Learning Outcome

  • Suitability for relational databases
  • Configuration for Azure SQL database
  • Introduction to Azure Virtual Machines (VM) and Stretch Databases
  • How to use Azure Cloud Shell
  • Azure Power Shell
  • Azure HA-DR
  • Security Management

Modules

Module 1: AZURE CLOUD INTRODUCTION

  1. Introduction to Cloud & Advantages
  2. Cloud Architecture: IaaS, PasS, and SaaS
  3. Microsoft Cloud Advantages, Azure Platform
  4. Azure Products and Services – MarketPlace
  5. Database Implementations in Azure Platform
  6. Comparing PaaS and IaaS Implementations; Paas
    Implementations For SQL Server
  7. IaaS Implementations For SQL Server; Logical, Virtual Machine, Managed Instance
  8. Installing SSMS and Azure Data Studio; Azure Account and Free Subscription
  9. Azure Resources: Resource Groups Usage
  10. Azure Active Directory: User & Groups
  11. Azure Active Directory Authentication

Module 2: AZURE SQL SERVER CONFIGURATION

  1. Installing SSMS and Azure Data Studio
  2. Azure Account and Free Subscriptions
  3. Azure SQL Server (Logical Server)
  4. Azure SQL Server Logical Server Firewall
  5. Firewall Rules – IP for Remote Access
  6. Server Properties and Status Format
  7. Password Resets in Azure SQL Server
  8. Azure SQL Databases & Pricing Tiers
  9. Azure SQL Database Access from SSMS
  10. Elastic Scaling with Azure Databases
  11. General Purpose and Business Critical
  12. Basic, Standard and Premium Plans: Gen 4, Gen 5

Module 3: DATABASE MIGRATIONS, DTU, ELASTIC QUERIES

  1. Data Migration and Database Migration in Azure
  2. Azure Storage: Creation & Containers LRS,GRS, and RA-GRS Azure Storage Accounts
  3. Storage Containers, Storage Explorer Tool
  4. Data Migration Assistant (DMA), Assessment
  5. Migrations To Azure SQL; DB Exports & Imports with bacpac
  6. Schema Generation & Compatibility
  7. DTU: Data Transaction Unit, Resource Allocations
  8. Basic, Standard & Premium Plans For SQL DB
  9. vCore Based Purchasing: Gen 4 and Gen 5 Types
  10. General Purpose & Business Critical Plans
  11. Compute Tier: Provisioned and Serverless
  12. Bounding Box Model, Elastic Pools & Queries
  13. eDTUs and Elastic Pool, per DB Settings
  14. Elastic Scaling with Azure SQL Databases

Module 4: AZURE SQL DATABASE TUNING

  1. Azure SQL Server Level Tuning Options
  2. Azure SQL Database Level Tuning Options
  3. Automated Tuning Options and Peak-Loads
  4. Force Plan, Create Index and Drop Index
  5. Query Performance Insight, Recommendations
  6. IO Metrics, CPU Metrics & Query Statistics
  7. Data File IO, Log File IO, Custom Reports
  8. Query Level Recommendations
  9. Azure Search Service
  10. Azure Search
  11. Suggester and Analyzer Index Modes for Tuning
  12. Retrievable, Filterable Indexes
  13. Facetable and Searchable Indexes for Tuning
  14. Change Tracking Options, Watermark Columns

Module 5: XEL GRAPHS, STRETCH DATABASES

  1. SQL Traces Creation
  2. SQL Traces: Event Class, Category, Filter, Conditions
  3. Extended Events Package, Target, Action, Session
  4. TSQL and SP Debug Events with Global Fields
  5. XE Objects: Catalog & Dynamic Management Views
  6. XE Profiler – Templates for Event Profiling
  7. Comparing XE Profiler with SQL Profiler Tool
  8. Stretch Databases in Azure SQL Databases
  9. Stretch Databases
  10. Table Level Migrations
  11. Performance Levels and DSU Pricing
  12. Data Storage and Snapshots
  13. Geo Backup Of Tables and Hybrid Cloud Settings
  14. Remote Data Archive Configuration in Azure
  15. Database Master Key [DMK], Cold Data Migration
  16. Real-time Advantages of Stretch Databases

Module 6: ALERTS, AZURE BACKUPS & RESTORES

  1. Azure SQL Server Activity Log and Options
  2. Events, Operations, and Event Categories
  3. Quick Insights from Events and Filters
  4. Events Exports to Event Hub, Log Analytics
  5. Log Analytics Workspace, Alert Rules
  6. Email / SMS Notifications and Schedules
  7. Log Analytics Settings and Azure Storage
  8. Activity Logs and Audit Reports, Insights
  9. Automated Backups; Long Term & Automated Backup Retentions (bacpac)
  10. Backups – Retentions, Audits. LTR Policy
  11. Restore Points, Database Recovery
  12. Geo-Redundant Backups in Azure
  13. Azure Storage Explorer For Backups
  14. Disaster Recovery (DR) Advantages in Azure

Module 7: HA – DR: Geo-Replication, DB Sync

  1. Failover Groups and Active Geo-Replication
  2. Read-Write Failover Policy, Automated Failover
  3. Geo-Replication Configurations – Azure Locations
  4. Primary-Secondary and Read / Write Modes
  5. Geo-Replication: Monitoring and Forced Failover
  6. Azure Server Failover Process, Strategies
  7. Automated SQL Data Sync Service and Sync Groups
  8. HUB, MEMBER and SYNC DATABASE
  9. Sync Direction, Sync Schema and Sync Interval
  10. bi-directional Load Balancing and Failover
  11. Conflict Resolution Policy

Module 8: SECURITY MANAGEMENT, RLS

  1. Firewall and Virtual Network Configurations
  2. Server-level Firewall & Database Firewall Rules
  3. System Stored Procedures for Firewall Settings
  4. Logins, Users, Roles and Permissions using T-SQL
  5. Creating Logins without Logins. Containment Users
  6. GRANT, DENY, REVOKE, WITH GRANT Permissions
  7. Threat Detection, Transparent Database Encryption
  8. Vulnerability Assessment, Dynamic Data Masking
  9. Implementing RLS – Row-Level Security
  10. Creating Users with & without Logins
  11. Using SECURITY Schema for RLS Functions
  12. Creating Security Predicates and Filters
  13. Security Policies for Row Level Security
  14. EXECUTE AS options for RLS. STATE ON/OFF

Module 9: POWERSHELL, AZURE VMs

  1. Azure Virtual Machines: Deploy, Configure
  2. Configure Windows Server, Redhat Linux
  3. Azure Storage Blades and Pricing Options
  4. Azure VM – Settings, Access & DB Creation
  5. On-Premise & Azure VMs: Similarities
  6. SQL Server Instance, Agent in Azure VM
  7. Azure SQL Database in VM to SQL Cloud
  8. Azure SQL Database in VM to OnPrem
  9. Deployment Automation Scripts in Azure
  10. Azure Cloud Shell – PowerShellGet
  11. Power Shell Scripts for Configurations
  12. Power Shell Scripts for Job Schedules
  13. Power Shell Scripts for Firewall, ARM
  14. Azure CLI – Purpose, Real- time Use

Module 10: Windows Clusters with Azure VM

  1. Windows Clusters For HA and DR
  2. Virtual Networks, Subnets, and IPs
  3. Availability Sets and Availability Zones
  4. Fault Domains and Update Domains
  5. DC Deployment & Configurations
  6. Active Directory Domain Services
  7. SAN [Storage Area Network] and LUN
  8. DNS Server, DSRM and Private IP
  9. Windows Level Clusters, MSCS Service
  10. Active-Active, Active-Passive Clusters
  11. DNS, AA Hosts
  12. SQL Clustering & RAID Levels
  13. SQL Cluster Groups, Domain Accounts
  14. Quorum and MSDTC Disks. LUN Grows

Module 11: Always-On with SQL Server Clusters

  1. SQL Server VMs and File Share Witness (FSW)
  2. Joining Machines to Domain Network (AD)
  3. Adding Install Accounts to Active Directory
  4. Install Failover Cluster (FCI) Features
  5. Firewall Configurations and Port Exceptions
  6. FSW File Shares and Usability Options
  7. Need for Always – On Availability (AAG)
  8. Always On Availability Group [AOAG]
  9. Multi-Database Replication Options
  10. Backup Preferences, Location Options
  11. Synchronous and Asynchronous Modes
  12. Synchronization, Automated Seeding
  13. Data Synchronization for AOAG
  14. AOAG Dashboards & Automated Failover
  15. Failover Connection Tests

Module 12: MCSA 70-765 certification guidance, Materials, and Sample Questions

Student Feedback

4.6

Total 5 Ratings

5
3 ratings
4
2 ratings
3
0 rating
2
0 rating
1
0 rating
PU

SQL Server DBAs analyze an organization's data management, input, and security needs, and help develop tools that support data access and information security, so to have knowledge in Azure - SQL database I prefer Myra’s Academy as they are the best at teaching from A-Z .It helped me learn about the suitability for rational database, configuration for Azure SQL database, it also introduced me to the virtual machines and stretch database. I also came to know about the process of using Azure Cloud Shell and Security Management. I’m pleased to work at Myra’s Academy.

SA

I had done the course of a Azure - SQL - DBA Advanced Course at Myra's academy. Faculty is very experienced. Their explanations is cool and fine. The class was done in a highly interactive and collaborative format with elements of lecture, classroom discussion, exercises, games, and simulations, smoothly blended throughout the class.Through the course, I gained organizational skills, soft skills, leadership and conflict facilitation skills, which helped me better deal with people and climb up ranks in the work environment. The journey with Myra was a once-in-a-time experience for me. Iam sure that you will also feel good experience in myra academy.

BV

Azure-SQL-DBA Advanced course has well designed and totally focused for SQL Server Database
Administrators and to make me comfortably experts in Microsoft Azure.

Thanks to myra’s academy for providing this course and we can learn directly from the experts from the company. It was a great experience.

AB

Database advance course have so many benefits. From that the main benefits are helps to speed in decision making process in any work condition, it enhances collaboration in the company, It increase in sales buy predicting customers behaviour. These are the main courses or benefits that I learned about and it is very helpful for me to know about DBA. Learning at Myra’s Academy was a delightful experience I ever had in my life.

I can strongly say that I became a skilful person in digital marketing all because of Myra’s Academy as they are the great company to work with and we had our sessions virtually which were very helpful.


( ! ) Warning: Attempt to read property "tutor_profile_photo" on null in /home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-content/plugins/tutor/classes/Utils.php on line 2882
Call Stack
#TimeMemoryFunctionLocation
10.0006365176{main}( ).../index.php:0
20.0007365856require( '/home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-blog-header.php ).../index.php:17
30.315311200800require_once( '/home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-includes/template-loader.php ).../wp-blog-header.php:19
40.333211671008include( '/home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-content/plugins/tutor/templates/single-course.php ).../template-loader.php:106
50.650218216720tutor_course_target_reviews_html( $echo = ??? ).../single-course.php:29
60.650218233232tutor_load_template( $template = 'single.course.reviews', $variables = ???, $tutor_pro = ??? ).../tutor-template-functions.php:838
70.650518234192include( '/home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-content/plugins/tutor/templates/single/course/reviews.php ).../tutor-template-functions.php:114
80.655318242976TUTOR\Utils->get_tutor_avatar( $user_id = '58', $size = ??? ).../reviews.php:87
( ! ) Warning: Attempt to read property "display_name" on null in /home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-content/plugins/tutor/classes/Utils.php on line 2886
Call Stack
#TimeMemoryFunctionLocation
10.0006365176{main}( ).../index.php:0
20.0007365856require( '/home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-blog-header.php ).../index.php:17
30.315311200800require_once( '/home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-includes/template-loader.php ).../wp-blog-header.php:19
40.333211671008include( '/home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-content/plugins/tutor/templates/single-course.php ).../template-loader.php:106
50.650218216720tutor_course_target_reviews_html( $echo = ??? ).../single-course.php:29
60.650218233232tutor_load_template( $template = 'single.course.reviews', $variables = ???, $tutor_pro = ??? ).../tutor-template-functions.php:838
70.650518234192include( '/home/1162278.cloudwaysapps.com/hxyxvqjfuu/public_html/wp-content/plugins/tutor/templates/single/course/reviews.php ).../tutor-template-functions.php:114
80.655318242976TUTOR\Utils->get_tutor_avatar( $user_id = '58', $size = ??? ).../reviews.php:87

The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built with Microsoft SQL Server and Microsoft Azure Data Services. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes .

I spent time on Myra’s Academy it give me a lot information , knowledge in and want enter the world of investment .

a creative logo for the Azure SQL Basic course on Myra's Academy with SQL written on a cylindrical shape
₹12,000

Enrolment validity: Lifetime

Courses
Info
Support
Site Links

© 2023 Myras Academy Private Limited. All Rights Reserved. Made With ❤️ By NPS

Facebook Linkedin Youtube Instagram
×