Azure SQL DBA (Including with Performance Tunning + Powershell )

We provide best SQL Azure Online Training by Real-Time Cloud Architect, our highly professional trainers. In this course you will learn how to implement SQL Server databases in Azure cloud platform. You will learn how to create and deploy SQL Databases into Azure platform. Implementing SQL databases in both IaaS and PaaS environments. We will discuss database migrations, security, automation, implementing High Availability and DR features in Azure.

Azure SQL Database is Microsoft's Database as a Service offering. This course will help you take advantage of your existing SQL Server skills and learn about managing, high availability, and performance of this cloud first solution.

This is100%hands-on course; You will learn about running SQL Server in Azure.

Helps to prepare DP- 300 Microsoft exams ((Administering Relational Databases on Microsoft Azure)

Trainer LinkedIn profile:
https://www.linkedin.com/in/ashoksqldba/
Pre-requisites:

Basic SQL knowledge, SQL DBAs, SQL Developers
Course Duration: 3 Week
Total Course Fee: 8000 INR

Course Contents:

1. What is Infrastructure as model?
2. What is PASS model?
3. What is SAAS model?
4. What is Azure SQL Database?
5. What is single database?
6. Security (logins& users& Roles)
7. AVG, MIN and MAX DTU usage?
8. what is elastic databases?
9. Difference Between Azure SQL and SQL Server
10. Cost saving in elastic databases?
11. Backup retention?
12. Restore DB's from backups
13. Restore DB's from deleted databases
14. Long term backups
15. Refresh non- prod's
16. Performance Tuning in Azure DB's
17. DTU vs vCore model
18. vCore model types
19. Server less Db's
20. Read-scale out option
21. Azure Hybrid Benefit
22. Reservations
23. Azure Calculator
24. DTU Calculator
25. HA/DR (Geo-Replication/ Availability Groups)
26. Data sync
27. Automation (how many ways)
28. Windows Scheduler
29. On premise SQL Agent
30. Runbooks
31. Elastic Jobs
32. Difference between Infrastructure vs passmodel?
33. Difference among single vs elastic vs managed instance?
34. Infrastructure as a model
35. Managed Instance
36. Storage account creation
37. Storage keys importance
38. Azure Storage Explorer
39. Online/URL backup example
40. How many ways we can Migrate
41. Data migration tool (Assessment mainly)
42. Data Migration Service (Offline & Online)
43. Backpack migration
44. Transactional Replication
45. Manual migration (schema script+ Import and export /Linked Server)
46. Ticket raising with Microsoft
47. Deadlocks in Azure
48. Data scoped settings (MAXDOP)
49. Locks
50. Alerts
51. Recovery services vault
52. Cost Analysis
53. Roles in azure portal
54. Mock Interview
55. Resume Preparation

Below is the Course Content Details
Service Scope & Activities
Microsoft Azure SQL Database Primer
  • Introduction
  • The Azure SQL Database Architecture
  • Provisioning an Azure SQL Database
  • Connecting to and Querying the SQL Database from Server Management Studio
  • Creating Resources
  • Differences between Azure SQL Database and SQL Server
  • Unsupported Features
Migrating a SQL Server Database to an Azure
SQL Database
  • Introduction  
  • Finding the Migration Benefits  
  • Finding the Blockers 
  • Selecting a Service Tier  
  • Selecting a Migration Tool  
  • DTU and Vcore Pricing Models  
  • Scaling up the Azure SQL Database Service Tier  
  • Choosing Between a vCore Pricing Model and DTU-based
  • Recommendation Based on CPU/IOPS/Log Utilization
  • Introducing Elastic Pools  
  • When Should You Consider Elastic Pools?  
Backing Up an Azure SQL Database
  • Introduction  
  • Automatic Backups  
  • Backup Storage  
  • Backup Retention Period  
  • Configuring Long-Term Backup Retention for Azure SQL Database  
  • Manual Backups  
  • Backing up an Azure SQL Database Using SQL Server
Restoring an Azure SQL Database
  • Introduction  
  • Restore Types  
  • Point-In-Time Restore  
  • Long-Term Database Restore  
  • Restoring Deleted Databases  
  • Geo-Restore Database  
  • Importing a Database  
Securing an Azure SQL Database
  • Introduction  
  • Firewall Rules  
  • Managing Server-Level Firewall Rules Using the Azure Portal  
  • Authentication  
  • SQL Authentication Azure Active Directory Authentication 
  • Server-Level and DB level Roles  
High Availability and Disaster Recovery
  • High Availability & Disaster Recovery Introduction 
  • Configuring Active Geo-Replication and Performing
  • Best Practices on HA & DA
Monitoring and Tuning Azure SQL Database 
  • Introduction 
  • Monitoring an Azure SQL Database Using the Azure Portal  
  • Query Performance Insight  
  • Monitoring Queries Using the Query Performance
  • Monitoring an Azure SQL Database Using DMVs  
  • Monitoring Database Metrics  
  • Monitoring Connections  
  • Monitoring Query Performance  
  • Monitoring Blocking  
  • Extended Events  
  • Automatic Tuning  
Resume Preparation and interview Tips 
  • Resume Preparation and interview Tips