SQL DBA Online Training (LIVE, Instructor-Led)

SQL DBA Training is given by Real-time, Certified Trainers. Course includes Capacity Planning, Query Tuning, Index Management, Database Maintenance, High Availability, Disaster Recovery (DR), Temporal Tables, Repairs, Always-On in SQL Cluster, SQL Azure Integration (Cloud), Geo Replication. This SQL DBA Course includes Study Material, MCSA Microsoft Certification, Job Support with One Real-time Project. Versions: SQL Server 2014, 2016, 2017 and 2019.

SQL DBA (with Server, T-SQL, Azure SQL DBA)

  PLAN A PLAN B
Competency Core DBA DBA + Azure
SQL DBA Course Duration 6 Weeks 8 Weeks
Real-time Issues, Solutions Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL Server, DB Architecture Check-Symbol-for-Yes Check-Symbol-for-Yes
Query Tuning and Plan Analysis Check-Symbol-for-Yes Check-Symbol-for-Yes
HA - DR, Issues, Troubleshooting Check-Symbol-for-Yes Check-Symbol-for-Yes
DB Repairs, Security Management Check-Symbol-for-Yes Check-Symbol-for-Yes
Migrations, Updates (CU), Upgrades Check-Symbol-for-Yes Check-Symbol-for-Yes
New Features: SQL 2016,2017,2019 Check-Symbol-for-Yes Check-Symbol-for-Yes
Always-On in Windows Clusters Check-Symbol-for-Yes Check-Symbol-for-Yes
Always-On in LINUX Clusters Check-Symbol-for-Yes Check-Symbol-for-Yes
MCSA 70-764 Certification Croos-symbol-for-Yes Croos-symbol-for-Yes
MCSA 70-765 Certification Croos-symbol-for-No Croos-symbol-for-Yes
MCSA 70-473 Certification Croos-symbol-for-No Croos-symbol-for-Yes
SQL DB Migration to Azure Croos-symbol-for-No Croos-symbol-for-Yes
Azure SQL Database Admin Croos-symbol-for-No Croos-symbol-for-Yes
Azure PowerShell, Azure CLI Croos-symbol-for-No Croos-symbol-for-Yes
Google Cloud and AWS Cloud Croos-symbol-for-No Croos-symbol-for-Yes
Total Course Fee INR 20000/-
USD 300
INR 26000/-
USD 380

SQL DBA Schedules - Trainer : Mr. Sai Phanindra T

Timings (IST) Free Demo Start Date  
Schedules for SQL DBA Training
6:30 AM to 7:30 AM Oct 23rd Oct 25th Register
10:15 AM to 11:15 AM Nov 6th Nov 8th Register
5:30 PM to 6:30 PM Nov 12th Nov 14th Register
Schedules for Azure SQL Training
7:30 AM - 9:30 AM (Wkn) Oct 20th Oct 27th Register

If the above schedules does not work, Then please opt for SQL DBA Video Training. All Trainings are completely Practical and Real-Time.

For One-One / Custom / Weekend Trainings, Register here

 

SQL DBA TRAINING HIGHLIGHTS :

✔ In-depth Tuning ✔ HA-DR Issues ✔ In-Memory Data
✔ Graph Tables ✔ Stretch Databases ✔ DAC, PBM
✔ DB Migrations ✔ Licensing Plans ✔ VN, VPN Config
✔ DMA Tool ✔ SSMA Tool ✔ POCs, RCA
✔ Ticketting Tool ✔ PSSDIAG ✔ LiteSpeed
✔ Always-On ✔ Windows Clusters ✔ Linux Clusters
✔ Storage, VMs ✔ Power Shell ✔ Google, AWS

SQL DBA (with SQL Server, Azure) Course Contents:

Part 1 : SQL DBA with SQL Server, T-SQL [Applicable for Plan A, B]

Module I: SQL Server & T-SQL

Installation, DB Architecture, Indexes, Tuning

Module II: Basic SQL DBA

Backups, Restores, Jobs, Tuning, Alerts, Security, Updates

Module III: Advanced SQL DBA

HA-DR, Errors & Solutions, Upgrades, Always-On

DAY 1: SQL DBA - JOB ROLES (INTRO)

  • Need for Databases & RDBMS Software
  • OLTP, OLAP, DWH and HTAP Databases
  • SQL Server - Technical Advantages
  • SQL Server Components and Use
  • SQL Server Editions and Versions
  • SQL DBA Job Roles and Types
  • Roles & Responsibilities For SQL DBA
  • DBA Checklist - Routine DBA Activities
  • DBA Checklist - Maintenance Activities
  • DBA Checklist - Emergency Activities
  • Course Plan and Mock Interviews
  • MCSA Certifications Curriculum

DAY 2: SQL SERVER INSTALLATION

  • SQL Server 2019 Installation Guidance
  • SQL Server 2017 and 2016 Installation
  • Installation Pre-Requisites and Precautions
  • SQL Server Management Studio (SSMS)
  • SQL Server Versions, Editions Comparisons
  • Instances, Instance Types & Instance IDs
  • Windows Authentication Type and its Use
  • Mixed Mode Authentication Type and Use
  • Default Admin Account in SQL Server : "sa"
  • SQL Server Services and Service Accounts
  • File Stream and Collation in SQL Instances
  • Installation Errors, Config.INI @ DAY 30

DAY 3: BASIC SQL QUERIES - 1

  • DDL, DML, SELECT, DCL and TCL
  • Creating SQL Databases and Tables
  • CREATE, ALTER, DROP Statements
  • INSERT, UPDATE, DELETE Statements
  • Data Inserts, Values and Table Scan
  • INTEGER, CHAR, FLOAT Data Types
  • INSERT and INSERT INTO Statements
  • Single Row Inserts, Multi Row Inserts
  • SELECT Statement for Table Retrieval
  • WHERE Examples : =, !=, <,>, <=, >=
  • AND, OR, NOT, IN, NOT IN Conditions
  • BETWEEN, NOT BETWEEN Conditions

DAY 4: BASIC SQL QUERIES - 2

  • CHAR Versus VARCHAR Data Types
  • VARCHAR & NVARCHAR Data Types
  • GO Statement, SQL BATCH Concept
  • BIGINT, BIT, SQL_Variant Data Types
  • IS NULL, NOT NULL. LIKE, NOT LIKE
  • ORDER BY with ASC, DESC Options
  • DISTINCT, TOP and COUNT() Options
  • FETCH, OFFSET, NEXT ROW Options
  • UNION, UNION ALL and Sub Queries
  • Single Quotes, Double Quotes, Aliases
  • UPDATE : Conditional & Unconditional
  • DELETE and TRUNCATE Commands
  • ALTER Command   DROP Command

DAY 5: SERVER, DB ARCHITECTURE

  • Client Server Architecture, TDS Packets
  • SNAC and OLE DB Command for TDS
  • TDS Packets and SQL Query Processing
  • Protocols, SQL Native Client (SNAC)
  • Query Optimizer (QO) and SQL Manager
  • Storage Engine, File and DB Manager
  • Transaction Manager and Lock Manager
  • Buffer Manager, SQL OS and IO Buffer
  • DB Data Files (mdf) and Log Files (ldf)
  • Primary/Secondary Files (ndf), Filegroups
  • Write Ahead Log (WAL) and Lazy Writer
  • Logs, Checkpoints, Virtual Log File (VLF)
  • Log Sequence Number (LSN), Mini LSN

DAY 6 : CONSTRAINTS & KEYS

  • Constraints, Keys - Table Data Integrity
  • NULL, NOT NULL Property on Tables
  • UNIQUE KEY Constraints: Importance
  • PRIMARY KEY Constraint: Importance
  • FOREIGN KEY Constraint: Importance
  • REFERENCES, OLTP Relational Tables
  • CHECK, DEFAULT & Identity Property
  • Normal Forms : 1 NF, 2 NF and 3 NF
  • BCNF, 4 NF, EKNF and ETNF Designs
  • Schemas - Purpose. Using DBO schema
  • User Defined Schemas & Data Transfer
  • Database Diagrams, PK-FK Base Tables
  • Local Temporary Tables and Sessions
  • Global Temporary Tables & Connections

DAY 7: JOINS AND QUERIES

  • JOINS - Types and Real-time Usage
  • JOIN Types and JOIN Options in T-SQL
  • INNER JOIN - Examples, WHERE, ON
  • OUTER JOIN - LEFT, RIGHT, FULL
  • CROSS JOIN and CROSS APPLY
  • MERGE JOIN - Joining Bigger Tables
  • LOOP JOIN - Joining Smaller Tables
  • HASH JOIN - Joining HEAP Tables
  • GROUP BY Queries and Aggregations
  • GROUP BY Queries with Having Clause
  • ROLLUP, CUBE Queries with Group By
  • Grouping () Functions in Rollup, Cube
  • Replacing Nulls: ISNULL, COALESCE

DAY 8: VIEWS, INDEXES - TUNING 1

  • Indexes: Architecture and Types
  • Clustered and Non Clustered Indexes
  • Included and ColumnStore Indexes
  • FILTERED and COVERING Indexes
  • UNIQUE Indexes, Query Optimizer
  • LIVE Online Indexes in Real-time
  • B Tree Structures and IAM Pages
  • Tuning Joined Queries, Conditions
  • Views on Tables - SCHEMABINDING
  • ENCRYPTION and CHECK OPTION
  • Orphan Views - Real-world Solutions
  • Cascaded Views, Encrypted Views
  • System Views for Metadata Access
  • Indexed Views / Materialized Views

DAY 9: FUNCTIONS, PROCEDURES

  • Scalar Value Returning Functions
  • Inline Table Functions, Dynamic Joins
  • Multi-Line Table Functions Usage
  • Table Variables and Table Data Type
  • Variables & Parameters in SQL Server
  • OBJECTID, OBJECTNAME Functions
  • System Functions & Metadata Access
  • Stored Procedures - Purpose, Usage
  • IF .. ELSE and ELSE IF Conditions
  • Using Procedures with Parameters
  • Recompilation of Stored Procedures
  • Sp_help, Sp_helpdb and sp_helptext
  • Sp_recompile, sp_pkeys System SPs

DAY 10: TRIGGERS, TRANSACTIONS

  • Triggers - Purpose, Types Of Usage
  • FOR/AFTER Triggers - Real time Use
  • INSTEAD OF Triggers - Real time Use
  • INSERTED, DELETED Memory Tables
  • Enable Triggers and Disable Triggers
  • Database Level DDL Triggers - Usage
  • Server Level DDL Triggers - Usage
  • COMMIT and ROLLBACK Statements
  • EXPLICIT & IMPLICIT Transactions
  • Autocommit Transaction, ACID Options
  • Open Transactions and Query Impact
  • Query Blocking Scenarios @ Real-time
  • NOLOCK and READPAST Lock Hints

 

DAY 11: BACKUPS - DB, File, Filegroup

  • Database Backups, Filegroup Backups
  • Log File Backups, COPY_ONLY Backups
  • Mirrored Backups and Split Backups
  • Partial Backups and Backup Media
  • (UN)LOAD, INIT, FORMAT, VERIFY
  • COMPRESSION, CHECKSUM, SKIP
  • ContinueOnError, Backup Validation
  • Backup History Tables in MSDB
  • Backup Audits, HOT & COLD Backups
  • Backup Devices - Creation & Usage
  • Choosing correct DB Recovery Model
  • Backups Errors and Solutions

DAY 12: RESTORES & DB RECOVERY

  • Restore Phases - COPY, REDO, UNDO
  • RECOVERY, NORECOVERY Options
  • STANDBY and REPLACE Options
  • File Restores and Filegroup Restores
  • Backup Verifications for Restores
  • FileListOnly and VerifyOnly Options
  • PARTIAL / PIECEMEAL Restores - Use
  • Tail Log Backups - UNDO / REDO
  • Restores using GUI & T-SQL Scripts
  • Point-In-Time Restore, Checkpoint LSN
  • Standby Restores and Read-Only State
  • Restores from SQL Server 2017 to 2019

DAY 13: JOBS, MAINTENENCE PLANS

  • SQL Server Agent Service, Agent XPs
  • SQL Agent Jobs - GUI Options, MSDB
  • Job Steps - Creation, Edits, Parse
  • Job Schedules and Email Notifications
  • Job Executions, Disable/Enable Options
  • Job History and Job Activity Monitor
  • Database Maintenance Plans, Backups
  • Scheduling DB Maintenance Plans
  • Backup Cleanup and History CleanUp
  • Backup Strategies - Minimal Data Loss
  • DB Mail Configurations, Alert System
  • Mail Profiles, SMTP Agent Operators

DAY 14: QUERY TUNING 2 - INDEXES, PARTITIONS

  • Audit Long Running Queries - DMV / DMF
  • Activity Monitor Tool and Query Statistics
  • Working with Plan Handle and Execution Time
  • Index Creation Options: SORT_IN_TEMPDB
  • FILL FACTOR and PAD INDEX Options
  • IAM Pages, GAM, SGAM and PFS Bit Maps
  • Resumable Indexes in SQL Server 2019
  • Table Partitions : Advantages, Performance
  • Database Filegroups and Partition Ranges
  • Partition Functions and Partition Schemes
  • Partition Un-partitioned Tables: Indexes
  • Aligned / Indexed Partitions - Importance
  • Partition Management - SPLIT & MERGE

DAY 15: QUERY TUNING 3 - STATISTICS, FTS

  • Execution Plans : Table Scan, Index Scan
  • Execution Plans : Index Seek, Query Cost
  • IO Cost and CPU Cost for Query Analysis
  • Operator Cost and Sub Tree Cost Analysis
  • Spooling, Temp DB Role for Query Prefetch
  • Statistics Creation and Usage in Real-time
  • Full Text Search (FTS) Architecture - Tuning
  • Stop Words, Stemmer and Thesaurus For Queries
  • Indexer Program and Query Processor Usage
  • Database Catalogs (FTC) and FDHost.exe
  • Full Text (FT) Indexes for Query Tuning
  • CONTAINS() and FREETEXT() Functions
  • Data Compression - ROW & PAGE Levels

DAY 16: QUERY TUNING 3 - INDEX MANAGEMENT

  • Index Management and Fragmentation
  • Index Rebuilds, Index Reorganization
  • Database Maintenance Plans (DMP) and Jobs
  • Query Execution Plans, Stats Updates
  • SAMPLED, DETAILED Scans. FillFactor
  • Index Management Options : Page Count
  • Index Usage and Degree of Parallelism [DOP]
  • SQL Profiler Tuning, Tuning Templates
  • Workload Files, Trace Tables in Profiler
  • DTA Tool with Profiler, Trace Tables, PDS
  • DTA with Query Cache, Extended Events
  • Memory Optimized Tables & FileStream
  • Memory Elevated Snapshots at DB Level
  • UPDATE STATS with RECOMPUTE Options

DAY 17: QUERY TUNING 4 - PERFMON, ISOLATIONS

  • Perfmon Counters and Real-time Tracking
  • Processor, Disk and Memory Counters
  • TPS Counters and Log Space Counters
  • TempDb Data Space Counters, Thread Count
  • NUMA Nodes, Boosting SQL Priority
  • Processor and IO Affinity - TDS Packets
  • Query Memory and Index Memory Settings
  • LOCKS : Mechanism, Types, Concurrency
  • X, S, IS, IX, U, Sch-M and Sch-S Locks
  • Lock Escalations, Deadlock Graphs, LIVE Locks
  • Isolation Levels - ReadCommitted, Uncommitted
  • Serializable, Snapshot, Repeatable Read
  • Read Committed Snapshot Isolation Level

DAY 18: SECURITY MANAGEMENT

  • Authentication Types - WINDOWS, SQL
  • Windows Logins and REGEDIT Settings
  • SQL Server Logins, POLICIES, EXPIRY
  • Logins, Users, Roles and Schemas
  • Server Roles and Database Roles
  • Password Resets and Security Scripts
  • Object Level, Column Level Security
  • Login Failures and Server Logs
  • Grant, With Grant, Deny and Revoke
  • CONTROL, OWNERSHIP, Authorization
  • Keys and Certifications - Encryption
  • Credentials, Proxies - Job Security
  • DMVs for Security Audits, Orphan Users
  • Containment Databases - Users, Roles

DAY 19: HEALTH CHECK, REPAIRS

  • DB Health Check: DBCC Commands
  • Allocation Errors and Consistency Errors
  • EstmateOnly, NoInfoMsgs with Tempdb
  • Log Space Audits and Tempdb Audits
  • Memory Usage, Disk Usage Audit DMVs
  • Alerts - Events, Email Notifications
  • DBCC Page and Trace Flags Usage
  • DB Suspect Errors and DB States
  • Log File Issues and REBUILD LOG
  • Tempdb File Issues and Shrink File
  • Memory Issues and DBCC Commands
  • MEMORY LEAKS and LATCH WAITS
  • Page Repairs, Suspect Pages @ MSDB

DAY 20: DB MIGRATIONS, DMA TOOL

  • Database Migration Options with SSIS
  • CDW : Copy Database Wizard @ SSMS
  • Database Detach and Attach Options
  • FORATTACH and sp_single_file_db
  • SMO Method and Database Scripting
  • CDW SSIS Packages, SSIS Proxies Use
  • Scheduling Database Migration Jobs
  • Migration Reports, Fixing Orphan Users
  • Data Migration Assistant (DMA) Tool
  • DMA Tool for DB Analysis, Upgrades
  • DMA Tool: DB Assessment, Migration
  • Security Logins Transfer - Options
  • Fixing Orphan Users, sp_resolve_login

DAY 21: REPLICATION For HA - LEVEL 1

  • Replication Architecture and Topology
  • Publication Types - Purpose, Importance
  • DB Articles, Publications, Subscriptions
  • Distribution DB Configuration, Snapshots
  • Snapshot Replication and Repl Agents
  • Adding Articles to Existing (LIVE) Replica
  • PUSH and PULL Subscription Types
  • Transactional Replication Configuration
  • Log Reader Agent - Configuration, Keys
  • Tracer Tokens - Latency and Ranking
  • Replication Monitor - Usage and Options
  • Replication Warnings and Agent Alerts

DAY 22: REPLICATION For HA - LEVEL 2

  • Merge Replication and Merge Agent Job
  • Replication Conflicts and ROWGUIDCOL
  • Replication Reinitialization Options
  • Server & Client Subscription Types
  • Peer-Peer Replication Connections, Nodes
  • Replication Conflicts: Options, sp_MSRepl
  • MSSQL_ENGXXXXX Errors & Solutions
  • sp_changedbowner, backup initialization
  • Replication Conflicts and Precautions
  • Replication Verify - Rowcount, Checksum
  • Disabling and Cleaning Replication
  • Replication for HA and DR - Strategies

DAY 23: LOG SHIPPING (ha - dr)

  • Log Shipping Topology, Operation Modes
  • Primary and Secondary: Recovery Plan
  • Log Shipping Monitor Settings, Alerts
  • NORECOVERY Mode - Configuration
  • STANDBY Mode Configuration, Use
  • Log Shipping Jobs & Manual Failover
  • Manual Failover with Log Shipping
  • Mode Changes with Log Shipping
  • Broken Log Shipping Chains & Issues
  • Re-Restoring the Log Backups
  • LSBackup, LSCopy, LSRestore Jobs
  • Log Shipping Jobs - Errors & Solutions

DAY 24: DB MIRRORING (ha - dr)

  • DB Mirroring Architecture For HA, DR
  • Log Shipping Versus Database Mirroring
  • TCP Endpoints, TCP Network Security
  • Heartbeat and Polling Concepts in DM
  • Automatic Fail-Over Procedures, Tests
  • PARTNER OFFLINE Conditions, Options
  • DB Mirroring Monitors and Commit Loads
  • SYNCHRONOUS & ASYNCHRONOUS
  • Mirroring Monitor, Stop/Resume Options
  • Need for Always-On & Higher Availability
  • DB Recovery without Witness. Failover
  • Mirroring Jobs and Real-time Usage
  • Database Mirroring - Errors & Solutions

DAY 25: PATCHES, UPGRADES, CUs

  • Establishing Downtime For Maintenance
  • Precautions for Maintenance Activities
  • Service Packs and Patch/hotfix Activities
  • Cumulative Updates (CU), Hotfix Process
  • Instance Selectivity for Updates, Cautions
  • Verifications, Smoke Test and Rollbacks
  • Server Upgrades and Precautions
  • Planning for Maintenance Activities
  • System Database REBUILD Options
  • Silent Installations and Services
  • SQLCMD Tool : Instance Connections
  • DAC : Dedicated Administration Console
  • Verifications, Smoke Test and Rollbacks

DAY 26: CLUSTER CONFIGURATION

  • Introduction to Windows Clusters
  • Domain Controller (DC) Configuration
  • Active Directory (AD) Accounts, Use
  • SAN [Storage Area Network] and LUN
  • Public IP Address, Private IP Address
  • Windows Level Clusters & RAID Levels
  • SQL Clustering Service & RAID Levels
  • SQL Cluster Groups and Domain Accounts
  • Active-Active, Active-Passive Clusters
  • Quorom Disk, MSDTC Disk & LUN Grows
  • MSCS Service Startup Options, Drains
  • Need for Always - On Availability (AAG)

DAY 27: ALWAYS-ON AVAILABILITY - 1

  • Availability Replica - Readable Secondary
  • Active Secondary, SYNC, ASYNC (AAG)
  • Replica Recommendations for Always-On
  • DB Recovery Models for Always - ON
  • Backup Preferences For AAG - Types
  • Port Settings, Backup Strategies in AAG
  • Synchronization & Automated Seeding
  • Always On Groups Dashboards
  • Adding AG Replicas and Databases
  • Availability Database and Failover
  • Data Movement Suspend and Quorum
  • Synchronous, Asynchronous Modes

DAY 28: ALWAYS-ON AVAILABILITY - 2

  • AAG Health Events, Important DMVs
  • Availability Group Listeners, VNN
  • Server Manager, DNS, New Hosts
  • Failover Mode and Node Majority
  • Reloads and Cache Clear Options
  • Listener Ports and Port Communication
  • Always-On in LINUX Clusters
  • AD Accounts and Doman Settings
  • Security Options and Dashboards
  • WSFC Warnings and Errors - Solutions
  • Video Classes For Windows Clusters
  • POCs For LINUX Clusters

DAY 29: SQL DBA Checklist - 1

  • Routine SQL DBA Activities
  • Emergency DBA Activities - Solutions
  • Logon Failures - Audits, Solutions
  • MSDTC & Distributed Transactions
  • Policy Based Management for AAG
  • Facets, Condition, Policies Evaluation
  • Memory Dump Files and Agent Logs
  • Linked Servers - Creation and Tests
  • Replication Options in Linked Servers
  • Linked Server Security - Remote Logins
  • RPC, RPC Out. Data Access Modes
  • Database Refresh Strategies

DAY 30: SQL DBA Checklist - 2

  • Command Line Installation. Config Files
  • Installation and Upgradation Errors
  • Service Startups - Minimal Logged Mode
  • Encrypted Backups, Managed Backups
  • Transparent Data Encryption (TDE)
  • Certificate Backups, File Encryptions
  • New Features in SQL Server 2016
  • New Features in SQL Server 2017
  • New Features in SQL Server 2019
  • SLA and OLA Process For SQL DBA
  • Ticketing Tools & 3rd Party Tools
  • 200 Point Error Checklist, Solutions

This SQL DBA Online Training Course includes one Real-time Project

Our SQL DBA Online Training Course includes one Real-time Project on E-Commerce Database. This project involves Real-time DBA Issues and Solutions including the u sage of Ticketing Tools, 3rd Party Tools. We deal with Routine SQL DBA Activities, Emergency DBA Activities and Maintenance Activities with Solutions. Also include 200+ Errors and Solutions, Database Migrations, Upgrades, Always-On Availability Groups Implementation in a Clustered Environment. This Real-time Project gives greater in-depth insight on Real-world SQL DBA Job Work and can also be used in your Resumes. Very much helpful to clear your Interviews and MCSA Certifications.

Part 2: Azure SQL DBA [Applicable for Plan B]

Module I: AZURE SQL DATABASE

Module II: AZURE SQL DBA

DAY 31: AZURE CLOUD INTRO

  • Introduction to Cloud. Need for Cloud, Advantages
  • Cloud Architecture Basics - Iaas, PasS and SaaS
  • Operational Advantages of Cloud, Cloud Providers
  • Advantages of Microsoft Cloud - Azure Platform
  • Service Models, Private & Public Clouds
  • SQL Databases in Microsoft Azure and Advantages
  • Azure SQL & Databases - Need, Importance
  • Azure Sources - Types, Microsoft Market Place
  • Azure SQL Database, Azure SQL Data Warehouse
  • Azure Analysis Services, BLOB and TABLE Storage
  • Azure Cosmos DB, Data Lake, DH Insight, Spark
  • Virtual Machines and Apps, Programs in Azure
  • Azure SQL Variants and Service Tiers
  • Advantages of Azure SQL Databases & Tools
  • Comparing Azure with AWS and Google Cloud
  • Microsoft Azure Price Tiers & Subscription

DAY 37: AUTOMATED DB RECOVERY, GEO REPLICATION

  • Automated Backups in Azure SQL Database
  • Long Term Backup Retentions. Backup cost, Frequency
  • Recovery Service Vaults, Policies with RA-GRS
  • Automated Backups - Retentions, Audits. LTR Policy
  • Restore Points and Azure SQL Database Recovery
  • Failover Groups and Active Geo-Replication
  • Read-Write Failover Policy, Automated Failover
  • Geo Replication Configurations - Azure Locations
  • Primary-Secondary and Read / Write Modes
  • Upgrading / Downgrading Primary Database
  • Perform Disaster Recovery (DR) Drills
  • Power Shell For Geo Replication and Failback Options
  • Manage SQL database failover using Transact-SQL
  • Manage SQL database failover using Power Shell
  • Manage SQL database failover using the REST API
  • Backup Errors, Geo Replication Errors - Solutions

DAY 32: AZURE CLOUD CONFIGURATIONS

  • Azure Cloud Subscription, Azure Portal Options
  • Azure Resources, Marketplace and Dashboards
  • Azure SQL Database Architecture Components - in detail
  • Price Tiers: Basic, Standard, Premium, PremiumRS
  • Isolated Price Trier - Advantages, Performance
  • Creating SQL Servers in Azure and in Virtual Machines
  • Elastic Pools and Configuration Options - Advantages
  • DTU : Data Transaction Units : Architecture, Pools
  • eDTUs and Elastic Pool, per Database Settings
  • EDTU Cost, eDTU max/min Limits and Performance
  • Resource Groups and Resource Pools in Azure SQL
  • Azure SQL Databases : Technical Features, Benefits
  • Built-In Intelligence and Scalability, Tools For Usage
  • Advanced Security Compliance, ARM and ASM Topologies
  • Need for OSM Workspace - Operations Management Suite

DAY 38: SECURITY MANAGEMENT - AZURE SQL DB

  • Firewall and Virtual Network Configurations
  • Server-level Firewall Rules in the Azure portal
  • Database-level Firewall Rule using SSMS
  • Connection strings and Security Options
  • Logins, Users, Roles and Permissions using T-SQL
  • GRANT, DENY, REVOKE and WITH GRANT using T-SQL
  • SQL Database Auditing and SQL Database Threat Detection
  • Transparent Database Encryptions (TDE) & Security
  • Service Keys and TDE for Security, AD Authentication
  • Row Level Security (RLS), Security Roles
  • Impacted Databases and Security Options
  • Azure IAM Controls, Manage SMB File Shares in Azure
  • Dynamic Data Masking (DDM) and Encryption Functions
  • T-SQL Scripts & Portal to Implement Data Mask Functions
  • Power Shell Scripts to Implement DDM - MASK / UNMASK

DAY 33: AZURE SQL DATABASE CONFIGURATION

  • Creating Azure SQL Server Instances
  • Creating Azure SQL Databases, Price Tiers
  • SQL Database – Cloud Database as a Service
  • Subscription Options and Database Sources
  • Elastic Pools & Tier Selection - Recommendations
  • Database Name Identifiers, Naming rules & restrictions
  • Server Names - Locations, Admin Users, Passwords
  • S1/S2/S3 DTU bands and Performance, Storage
  • Add-On Storage Options. Database Provisioning
  • Firewall Rules, IP Configuration Ranges
  • Azure Dashboard - Metrics, Notification Options
  • Azure SQL Database Collation, Connection Options, Tools
  • SQL Server Management Studio (SSMS) & Visual Studio
  • SQL Server Data Explorer Tool in Azure Cloud
  • .NET, PHP, Node.js, Java, Ruby, Python
  • Creating Azure SQL Databases in SSMS Tool
  • T-SQL Scripts for Azure SQL Database

DAY 39: AUDITS and THREAT DETECTION

  • Activity Logs and OMS Server Configuration
  • OMS Workspace and Log Analytics. Operational Logs
  • Instance Audits and Threat Detection Process
  • Audit Storage Configuration, Service Tiers with Azure
  • LRS, GRS, and "RA - GRS" Storage Modes in Azure
  • Azure Resource Manager (ARM) Scripts with Power Shell
  • Threat Detection Types : SQL Injection & Vulnerability
  • Audit Types: Server Audits and Database Audits
  • Events, Principals, Types and Action Parameters
  • DMVs and DMFs for Audits (T-SQL). Power Shell Scripts
  • Merging and Reading Audit Files. Analyzing Audit Reports
  • Vulnerability Assessment (VA) Reports, Notifications
  • Security Risk Reports and Summaries : HIGH/MEDIUM/LOW
  • Azure SQL Database Recovery from Availability Groups
  • Azure SQL Database Recovery from Deleted Databases
  • Manage SQL database auditing using Azure Power Shell
  • Manage SQL database auditing using REST API

DAY 34: DEVELOP AZURE SQL DATABASE

  • Executing T-SQL Scripts in Azure
  • Creating Tables and Defining Constraints
  • Cascades, Constraint Rules and Index Rules
  • Clustered Indexes in Azure SQL Database Tables
  • Programming Objects: Stored Procedures in Cloud
  • Automated Recompilations, Complex Stored Procedures
  • Triggers and Memory Tables Architecture in Cloud
  • CTE : Common Table Expressions and Performance
  • User Defined Functions and Views for Data Reporting
  • Differences between On-Premise and Cloud SQL Databases
  • Executing T-SQL Scripts in Azure SQL Database
  • Linked Servers with On-Premise and Cloud
  • SSMS "Generate Script" Options, Advanced Options
  • Azure SQL Database JSON Features, Data Imports
  • Azure SQL Database In-Memory Tables - Advantages
  • Temporal Tables, In-Memory OLTP Tables with Azure SQL DB
  • Excel Reporting Options from Azure SQL Database
  • Data Explorer Options with Azure SQL Databases
  • XML Data Storage & Reports. BLOB Data Storage

DAY 40: PERFORMANCE TUNING in AZURE SQL DB

  • Manage database workload in SQL Server
  • Elastic Scale for Azure SQL Database
  • Service Tier and Edition Selection
  • Scaling Options - Horizontal, Vertical
  • Sharding Technique for Performance Tuning
  • SaaS approach with single / multi user tenants
  • Shard Maps & Shardlets: List Mapping, Range Mapping
  • Shard Map Manager and Data Dependent Routing
  • Query Routing and Shard Querying. Elastic Tools
  • Using DMVs and DMFs in Azure Databases
  • Monitor Azure SQL Database Query Plans
  • Moving data between scaled-out cloud databases
  • Split-Merge Tool and Split Merge Service
  • Performance Monitoring Counters For Azure SQL DB
  • CPU, DTU Limits. Data IO and Size Factors
  • In-Memory OLTP Tables and Performance Impact
  • Active Recommendations, Tuning History. Resource Governor
  • FORCE PLAN, CREATE / DROP INDEX. ON / OFF INHERITS
  • Automated Tuning Options in Azure Database Cloud

DAY 35: AZURE SQL DATABASE MIGRATIONS

  • Database Scripting Wizard in SSMS
  • Scripting On-Premise Databases in T-SQL
  • Data Migration Assistant (DMA) Tool
  • Schema Generation and Compatability Issues
  • Generating Data Scripts, Assessment, Schema Options
  • Prepare and Deploy Fixes. Database Snapshots
  • Resolving Database Migration Compatibility Issues
  • Partially Supported and Unsupported Functions
  • non SQL Server Database Migrations : MS Access, Oracle
  • SQL Server Migration Assistant (SSMA) Tool
  • Import from a BACPAC file using Azure portal
  • Import from a BACPAC file using SQLPackage
  • Import from a BACPAC file using PowerShell
  • Migrate Stored Procedures, In-Memory Tables

DAY 41: DATABASE SYNCHRONIZATION

  • SYNCHRONIZATION with Azure SQL Databases
  • SQL Data Sync Service and Sync Groups
  • bi-directional data transfer with Azure SQL DBs
  • Sync Schema, Sync Direction and Sync Interval
  • Conflict Resolution Policy with HUB and MEMBER
  • Metadata Database and Synchronization Topologies
  • Real-time Advantages of Azure DB Synchronization
  • LOAD BALANCING & Automated FAILOVER with DB Sync
  • Cloud to Cloud and Cloud to On-Premise Synchronization
  • HA - DR with Geo Replication & Database Synchronization
  • Update Triggers and Delete Triggers - Azure Instance
  • Azure Database Integration. Elastic Query Plans
  • Requirements and Limitations with Database Synchronization
  • Azure Dashboards and Report Pins. Server Health Reports

DAY 36: INTEGRATING with AZURE SQL DATABASE

  • Azure SQL Database Tables, Views in Excel
  • Excel Pivot Tables and Chart Reports with Azure SQL DB
  • Azure & Excel ODC Connections. Pivot Reports
  • ADO.NET, JDBC and ODBC Connections. Data Mashups
  • Connection Drivers in Azure Cloud - Options
  • Azure Portal Email Configurations, Triggers
  • Azure SQL Database Query Batching - Advantages
  • Azure Cloud Shell - Concepts, Architecture
  • Azure Power Shell - Install and Configure
  • Installing and Scripting with Power Shell
  • PowerShellGet and Version Paths
  • Cloud Shell to run the Azure Power Shell
  • Linux Virtual Machines with Power Shell
  • Windows Virtual Machines with Power Shell

DAY 42: AZURE VIRTUAL MACHINE, OTHER CLOUDS

  • Plan for IaaS, Azure VM. Install Azure Virtual Machines
  • Install/Configure Windows Server, Readhat, Ubuntu
  • SQL Server on Azure VM - Config Settings, Elasitc Pools
  • Resource Groups, Resource Pools and eDTUs
  • Verify SQL Instances in Azure VM. sysadmin Account
  • Azure SQL Database in VM to SQL Cloud
  • Azure SQL Database in VM to on-Prem
  • Deployment Automation Process, Automation Scripts
  • SQL Database in AWS and Google Cloud
  • Real-time Considerations and Bacpac File Security
  • Azure HD Insight Configuration and Power Shell
  • Azure DataLake and Integration with Azure SQL Database
  • Power BI Workspace with Azure SQL Database
Guidance and Mock Certification for MCSA 70-473 (Azure SQL)

Guidance and Mock Certification for MCSA 70-473 (Azure SQL)

This AZURE DBA Training Course includes one Real-time Project

Deployments to SQL Azure Azure Database Integration Azure Cloud Versus AWS Cloud Azure Cloud Versus Google Cloud Pricing and Server Tiers Elastic Pools and Config Elastic Query Plans Geo Replication Issues Azure Interview FAQs Resume Preparation Mock Interviews Beneficial For MCSA 70-765 and 70-473 Exams

Above course curriculum applicable for registrations from September 28th, 2018.

24x7 Suport with Real-time Database Training. Course includes ONE Real-time Project. Register Today

All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and Mock Tests.

 
 

SQL DBA Online 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 SQL Server Architecture, DB Repairs, Migrations
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • SQL Profiler, SQLDIAG, DTA, DMA, SSMA Tools
  • SQL Clusters, Always-On. SQL DBA in Azure Cloud
Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses