SQL DBA Online Training (LIVE, Instructor-Led)

This SQL DBA Online Training from Real-time, Certified Trainers includes Basic to Advanced Database Administration activities : Capacity Planning, Query Tuning, Index Management, Database Maintenance, High Availability (HA), Disaster Recovery (DR), Query Store, In-Memory Tables, Database Repairs, Page Repairs, Jobs, Alerts, Resource Management, Security Management including Azure SQL DBA Activities like Azure Sync, Azure Server Failover, Azure Virtual Machines and Azure DB Migrations.

This SQL DBA Online Training also includes practical implementation of Always-On Availability Groups [AOAG] in Windows Clusters, LINUX Clusters and Real-time Azure SQL DBA activities. Additionally, this SQL DBA Training Course includes complete guidance for your Job Profile, Study Material, MCSA SQL DBA Certification (DP 300) and Real-time Projects for your Resume. Versions: SQL Server 2014, 2016, 2017 and 2019. Download SQL DBA Curriculum Here

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

  PLAN A PLAN B PLAN C
SQL DBA Job Profile Core DBA Core DBA +
Azure DBA 		 Core DBA +
Azure DBA +
Power BI
SQL DBA Course Duration 6 Weeks 9 Weeks 13 Weeks
Course Contents Ch 1 to Ch 27 Ch 1 to Ch 39 Ch 1 to Ch 57
Completely Practical, Real-time ✔ ✔ ✔
Routine SQL DBA Activities ✔ ✔ ✔
Emergency SQL DBA Activities ✔ ✔ ✔
SQL Server, DB Maintenance ✔ ✔ ✔
DB Repairs, Security Management ✔ ✔ ✔
Migrations, Patches, Upgrades ✔ ✔ ✔
HA-DR : Replication, Log Shipping ✔ ✔ ✔
HA-DR : Mirroring, Common Errors ✔ ✔ ✔
Clustering, Always-On Availability ✔ ✔ ✔
Tuning Tools, Execution Plans ✔ ✔ ✔
Ticketing Tools, 3rd Party Tools ✔ ✔ ✔
SLA-OLA, Incident Management ✔ ✔ ✔
Azure SQL Database Migration ✖ ✔ ✔
Azure SQL DB Security, HA-DR ✖ ✔ ✔
Azure Always-On, PowerShell ✖ ✔ ✔
Azure Virtual Machines (VM) ✖ ✔ ✔
DP 300 Exam : Guidance ✖ ✔ ✔
70-764, 70-765 Exams : Guidance ✖ ✔ ✔
Power BI: Report Design, Visuals ✖ ✖ ✔
Power BI: M Lang, DX for ETL ✖ ✖ ✔
Power BI: Report Server, Admin ✖ ✖ ✔
Power BI: Data Modelling with DAX ✖ ✖ ✔
Power BI: DA 100 Exam Guidance ✖ ✖ ✔
Total Course Fee
* Payable in Installments		 INR 18,000
USD 244		 INR 27,000
USD 365		 INR 35,000
USD 473

Trainer : Mr. Sai Phanindra T

Schedules for SQL DBA [Chapters 1 to 27]
S No Timings (IST) Start Date  
Regular Schedules [Mon - Fri]
1 6 AM - 7 AM July 4th Register
2 8 PM - 9 PM July 18th Register
Schedules for Azure DBA [Chapters 28 to 39]
S No Timings (IST) Start Date  
  Weekend Schedules [Sat & Sun]
3 6 AM - 8 AM July 9th Register
4 8 PM - 10 PM July 2nd Register
Schedules for Power BI [Chapters 40 to 57]
S No Timings (IST) Start Date  
  Regular Schedules [Mon - Fri]
1 8 AM - 9 AM June 10th Register
2 6 PM - 7 PM Jul 25th Register
3 9 PM - 10 PM Jul 11th Register

SQL DBA TRAINING HIGHLIGHTS :

✔ In-depth Tuning ✔ HA - DR Issues
✔ Azure Migrations ✔ XEL Graphs
✔ DAC, PBM ✔ Stretch Databases
✔ DB Migrations ✔ Licensing Plans
✔ Azure HA - DR ✔ In-Memory Tables
✔ DMA Tool ✔ POCs, RCA
✔ Ticketing Tool ✔ Tuning Tools
✔ Updates, Rollbacks ✔ Always-On
✔ SLA / OLA ✔ Upgrades, Rollbacks
✔ Lite Speed ✔ Windows Clusters
✔ Managed Instance ✔ Realtime Errors
✔ Linux (RHEL) ✔ Virtual Machines
✔ Capacity Planning ✔ Power Shell
✔ Service Startups ✔ Shard Keys
✔ BLOB Storage ✔ Azure Storage Keys
✔ DBA Checklists ✔ Azure RM, eDTU
✔ MCSA Guidance ✔ Rebuilds, Repairs
✔ Managed Instances ✔ Foglight, Automations

Chapter wise FAQs with Answers, Real-time Project are part of this SQL DBA Online Training Course Register

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

Course Curriculum

Register Today

 

Module I: SQL Server & T-SQL

Installation, Architecture, DB Basics

Module II: Basic SQL DBA

Backup-Restores, Jobs, Performance Tuning, Security

Module III: Advanced SQL DBA

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

Ch 1: JOB ROLES, INSTALLATION

  • Introduction to Databases, DBMS
  • Microsoft SQL Server : Advantages, Use
  • Versions and Editions of SQL Server
  • SQL DBA Job Roles, Responsibilities
  • Routine Maintenance DBA Activities
  • Emergency SQL DBA Activities
  • SQL Server Pre-requisites : S/W, H/W
  • SQL Server 2019/2017/2016 Installation
  • Default Instance, Named Instances
  • Port Numbers, Instance Differences
  • Service and Service Account Use
  • Authentication Modes and Logins
  • Firewall Configuration in Real-time
  • SQLServr.exe and SQLBrowser.exe

Ch 10: BACKUPS - DB, Filegroup, File

  • Database Backups, Filegroup Backups
  • Log File Backups and Log Truncations
  • COPY_ONLY Backups and Real-time Use
  • Mirror Backups and Split Backups
  • Partial Backups - ReadOnly Filegroups
  • Format, Compression and Checksum
  • Backup Verification, RetainDays, Stats
  • ContinueOnError and Backup Scripts
  • GUI and Script Backups: Differences
  • Backup History Tables in MSDB - Joins
  • Backup Audits. HOT and COLD Backups
  • Backup Devices - Creation and Usage
  • Using Backup Devices - Advantages
  • Common Errors and Solutions

Ch 19: 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, PULL Subscriptions. N/W Shares
  • Transactional Replication Configuration
  • Log Reader Agent - Configuration, Keys
  • Replication Monitor - Tracer Tokens
  • Replication Monitor - Warnings, Alerts
  • Replication Monitor - Usage and Options
  • Replication Scripts, Adding Articles
  • Replication Warnings and Agent Alerts

Ch 2: SSMS Tool, SQL BASICS - 1

  • SSMS Tool Installation, Connections
  • SQL Server Management Studio
  • Single Server, Multi Server Connections
  • System Databases: Master and Model
  • MSDB, TempDB, Resource Databases
  • SQL and T-SQL : Basic Differences
  • DDL, DML, SELECT Statements
  • Using GUI and SQL Scripts in SSMS
  • Creating Databases : Files [MDF, LDF]
  • Creating Tables in SQL Server
  • Data Storage in Tables : Inserts
  • SELECT : Data Retrieval Statement
  • Table Scans. LIVE QUERY STATISTICS
  • Limitations with SSMS GUI Options

Ch 11: RESTORES & DB RECOVERY

  • Restore Phases - COPY, REDO, UNDO
  • RECOVERY, NORECOVERY Options
  • STANDBY and REPLACE in Restores
  • File, File Group & Metadata Restores
  • Backup Verifications using GUI, Scripts
  • VERIFYONLY : Backup Verification
  • STATS, UNLOAD, STOPAT and INIT
  • PARTIAL / PIECEMEAL Restores - Use
  • Tail Log Backup Usage in Real-time
  • Restores using GUI and T-SQL Scripts
  • MOVE Options for File Level Restores
  • Point-In-Time Restore, Checkpoint LSN
  • Standby Restores and Read-Only State
  • Common Errors and Solutions

Ch 20: REPLICATION For HA - Level 2

  • Merge Replication and Merge Agent Job
  • Replication Conflicts and ROWGUIDCOL
  • Subscription Reinitialization, Expiry Setting
  • Server Subscription & Client Subscription
  • Peer-Peer Replication Connections, Nodes
  • NodeID and Conflict Detection Options
  • Replication Conflicts and sp_MSRepl
  • sp_changedbowner, backup initialization
  • Replication Conflicts and Priority Settings
  • Replication Verify - Rowcount, Checksum
  • Disabling, Cleaning Replication Topology
  • Replication Strategies for HA and DR Plan
  • Replication for Load Balancing Topologies
  • Common Errors and Solutions

Ch 3: SQL BASICS For DBAs - 2

  • Creating Databases in SQL Server
  • Database Connections and Usage
  • Creating Tables and Data Storage
  • Data Inserts and SELECT Statement
  • WHERE Conditions and Keywords
  • IN Operator and NOT IN Operator
  • Between, Not Between Operators
  • LIKE and NOT LIKE Operators
  • UPDATE Statement & Conditions
  • DELETE & TRUNCATE Statements
  • Logged and Non-Logged Operations
  • Table Structure Modifications
  • ADD, ALTER and DROP Columns
  • Aliases and Batch Statements

Ch 12: JOBS, MAINTENENCE PLANS

  • SQL Server Agent Service & Agent XPs
  • SQL Agent Jobs - GUI, Script Creations
  • Job Steps - Creation, Edits and Parse
  • Job Executions, Disable/Enable Options
  • Job History Purge. Job Activity Monitor
  • Database Maintenance - Backup Jobs
  • Scheduling Database Maintenance Plans
  • Automated Job Creations using DMPs
  • Backup Cleanup & History Cleanup Jobs
  • Backup Strategies For Minimal Data Loss
  • Backup Options: Block Size, Transfer Size
  • DB Mail Configurations and Alert System
  • DB Mail Profiles, SMTP Email Accounts
  • Operators : Creation, Job Notifications

Ch 21: LOG SHIPPING (HA - DR)

  • Log Shipping Topology for HA and DR
  • Primary and Secondary: Recovery Plan
  • Log Shipping Monitor, Jobs and Alerts
  • NORECOVERY Mode - Configuration
  • STANDBY Mode Configuration & Jobs
  • Log Shipping Jobs and Manual Failover
  • Disconnections and Delay in Restores
  • Log Shipping Mode Changes - cautions
  • Re-Restoring Log Backups for Recovery
  • LSBackup, LSCopy & LSRestore Jobs
  • LS Job Audits, Dashboards (Reports)
  • TUF Files and Standby Options in LS
  • Broken Log Shipping Chains & Issues
  • Common Errors and Solutions

Ch 4: SCHEMAS, TEMP TABLES

  • Schemas : Group Tables in Database
  • Schemas : Security Management Object
  • Creating Schemas & Batch Concept
  • Using Schemas for Table Creation
  • Data Storage in Tables with Schemas
  • Data Retrieval, Usage with Schemas
  • Table Migrations across Schemas
  • Import and Export Wizard in SSMS
  • Data Imports with Excel File Data
  • Performing Bulk Operations in SSMS
  • Temporary Tables : Real-time Use
  • Local and Global Temporary Tables
  • # and ## Prefix, Scope of Usage
  • Session Level, Connection Level Use

Ch 13: SECURITY MANAGEMENT - 1

  • Authentication Types & Modifications
  • Windows Logins & SQL Server Logins
  • Logins - Users Mapping, DB Access
  • Server Roles & Database Roles - Usage
  • Object, Column and Schema Security
  • GRANT, WITH GRANT, DENY, REVOKE
  • CONTROL, OWNERSHIP, Authorization
  • Data Encryption: Keys and Certificates
  • Data Encryption with Stored Procedures
  • Job Security : Credentials and Proxies
  • Using Proxies for SSIS Jobs, Repl Jobs
  • Security Scripts and Documentation
  • DMVs for Security Audits, Orphan Users
  • Login, User, Server Principal Audits

Ch 22: 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
  • DB Mirroring and Port Configurations
  • Mirroring Monitor, Stop/Resume Options
  • Need for Always-On & Higher Availability
  • DB Recovery without Witness. Failover
  • Mirroring Monitor Jobs - Real-time Usage
  • Common Errors and Solutions

Ch 5: CONSTRAINTS, INDEX Basics

  • Constraints and Keys - Data Integrity
  • NULL, NOT NULL Property on Tables
  • UNIQUE KEY Constraints: Importance
  • PRIMARY KEY Constraint: Importance
  • FOREIGN KEY Constraint: Importance
  • REFERENCES, CHECK and DEFAULT
  • Candidate Keys and Identity Property
  • Database Diagrams and ER Models
  • Relationships Verification and Links
  • Indexes : Basic Types and Creation
  • Index Sort Options, Search Advantages
  • Clustered and NonClustered Indexes
  • Primary Key and Unique Key Indexes
  • Need for Indexes - working with Keys

Ch 14: MIGRATIONS & SECURITY - 2

  • Database Migration Precautions
  • Migration Methods & Comparisons
  • CDW: Copy Database Wizard @ SSMS
  • Database Detach and Attach Options
  • SMO Method and Database Scripting
  • Creating and Using Credentials
  • Creating and Using Agent Proxies
  • SSIS Job Subsystem with Proxies
  • Copy Database Wizard: SSIS Packages
  • Scheduling Database Migration Jobs
  • Transfer of Logins & Server Objects
  • Detecting and Resolving Orphan Users
  • Containment Databases Authentication
  • Login Failure Audits & Server Logs

Ch 23: Health Checks, Issues, Solutions

  • Alerts : Creation and Notifications
  • DB Suspect Event Alerts (023)
  • Important Perfmon Counters, Alerts
  • Log Space, Memory, Tempdb Alerts
  • DBCC CHECKDB : DB Health Checks
  • Allocation Errors, Consistency Errors
  • DBCC ShowContig, Extent Fragmentation
  • Trace Flags and EstimateOnly
  • DBCC Page: GAM, SGAM and PFS
  • Consistency Errors : Cause & Solutions
  • Allocation Errors : Cause and Solutions
  • Log Space Issues and Log Rebuilds
  • Memory & TempDB Issues, Solutions
  • DBCC ShrinkDB and Page Restores

Ch 6: JOINS & AUDITS

  • JOINS - Table Comparisons Queries
  • INNER JOINS For Matching Data
  • OUTER JOINS For (non) Match Data
  • Left Outer Joins with Example Queries
  • Right Outer Joins with Example Queries
  • FULL Outer Joins - Realtime Scenarios
  • Join Queries with "ON" Conditions
  • Join Unrelated Tables in SQL Server
  • NULL, IS NULL Operators in Joins
  • CROSS JOIN and CROSS APPLY
  • CROSS JOIN Versus CROSS APPLY
  • One-way, Two Way Data Comparisons
  • Important Join Queries in T-SQL
  • Join Options: Merge, Loop, Hash

Ch 15: Tuning 1 - Audits, Indexes

  • Audit Long Running Queries : DMV, DMF
  • Activity Monitor Tool, Server Dashboards
  • Logical I/O, Physical I/O, Database I/O
  • Recent Expensive Queries, Wait Time
  • Active Expensive Queries, Statistics
  • Plan Handle, Execution Time - Audits
  • CPU, IO, Memory Consumption Reports
  • Indexes: Architecture and Index Types
  • B Tree Structure, IAM Page [Root]
  • Clustered & NonClustered Indexes
  • Included, Columnstore, Online
  • Filtered, Covering, Indexed Views
  • Fill Factor and Pad Index Options
  • Query Store - Settings and Advantages

Ch 24: PATCHES, UPGRADES, CUs

  • Establishing Downtime For Maintenance
  • Precautions for Maintenance Activities
  • DB Backups, Scripting and Services
  • Service Packs and Patch/Hotfix Activities
  • Cumulative Updates (CU), Hotfix Process
  • Instance Selectivity for Updates, Cautions
  • Verifications, Smoke Test and Rollbacks
  • Multi Instance Updates & Port Changes
  • SERVER Upgrades & VERSION Changes
  • System Database REBUILDs using CMD
  • Silent Installation & Installation Repairs
  • SQLCMD Tool and Instance Connections
  • DAC : Dedicated Administration Console
  • Service Startup Issues and Solutions

Ch 7: View, Procedures, UDF Basics

  • Views : Types, Usage in Real-time
  • System Predefined Views and Audits
  • Listing Databases, Tables, Schemas
  • Functions : Types, Usage in Real-time
  • Scalar, Inline and Multi-Line Functions
  • System Predefined Functions, Audits
  • DBId, DBName, ObjectID, ObjectName
  • Date and Time Functions : Getdate()
  • Variables & Parameters in SQL Server
  • Procedures : Types, Usage in Real-time
  • User & System Predefined Procedures
  • Parameters and Dynamic SQL Queries
  • Sp_help, Sp_helpdb and sp_helptext
  • sp_pkeys, sp_rename and sp_help
  • sp_recompile, Perrformance Benefits
  • System Objects for Metadata Access

Ch 16: Tuning 2 - INDEX MANAGEMENT

  • PARTITIONS : Advantages, Performance
  • Partition Functions & Partition Schemes
  • Partitioning Un-partitioned Tables: GUI
  • Partition Compression : ROW and PAGE
  • Auditing Table Partitioned Structures
  • Statistics : Purpose, Auto Creation
  • Statistics : Audits and Updates
  • Working with Indexes and Partitions
  • Internal and External Fragmentation
  • Index Rebuilding Process and Audits
  • Database Maintenance Plans Jobs
  • Last Used, Page Count, Fragmentation
  • Index Page Count and Index Condition
  • Degree Of Parallelism [DOP] Settings
  • Resumable Indexes: ONLINE, RESUME
  • PAUSE & RESUME in Index Rebuilds

Ch 25: ALWAYS ON AVAILABILITY

  • Always-On: Non-Clustered Environment
  • Multi Database Replication with AOAG
  • Synchronous and Asynchronous Modes
  • Policy Based Management for AOAG
  • Facets and Conditions for Policies
  • Backup Preferences, Location Options
  • Synchronization, Automated Seeding
  • Data Synchronization for AOAG
  • Port Settings, Backup Strategies: AAG
  • AOAG Verifications and Dashboards
  • Adding Availability Replica, Database
  • Adding Availability Listeners and DNS
  • Automated Failovers, Manual Failovers
  • Always-On Availability Groups Health
  • NonClustered Environment Limitations
  • Clustering with Always-On in Ch 37,38

Ch 8: Triggers & Transactions

  • Triggers - Purpose, Real-world Usage
  • FOR/AFTER Triggers - Real time Use
  • INSTEAD OF Triggers - Real time Use
  • INSERTED, DELETED Memory Tables
  • Using Triggers for Data Replication
  • Enable Triggers and Disable Triggers
  • Database Level, Server Level Triggers
  • Auditing Triggers and Real World Use
  • Transactions : Types, ACID Properties
  • Transaction Types and AutoCommit
  • EXPLICIT & IMPLICIT Transactions
  • COMMIT and ROLLBACK Statements
  • Open Transaction Scenarios & Cause
  • Query Blocking Scenarios @ Real-time
  • NOLOCK and READPAST Lock Hints

Ch 17: Tuning 3 - Tuning Tools

  • Tuning Tools: Workload Files, .trc Files
  • Profiler Tuning Template, SP Events
  • DTA, Profiler Trace : Recommendations
  • PDS: Physical Design Structures
  • Index, Stats, Partition Recommendations
  • DTA with Query Execution Cache
  • Perfmon Tool : Usage, Permon Counters
  • Real-time Tracking: CPU, Memory, IO
  • Execution Plan Analysis and Internals
  • Query Costs: IO Cost and CPU Cost
  • Query Costs: SubTree & Operator Cost
  • NUMA Nodes, Processor, IO Affinity
  • Thread Count, Degree of Parallelism
  • Stored Procedure Recompilations
  • Table Scan, Index Scan, Index Seek

Ch 26: SQL DBA PROJECT - Level 1

  • Audit Login Failures : Server Logs
  • Monitoring Connectivity Issues
  • Database Refresh and MSDTC
  • Adhoc Memory Dump Files
  • PLE (Page Life Expectancy) Issues
  • Object Refresh and Recompilations
  • Server Registrations and Operations
  • Lock Monitoring Operations
  • Index Management Options
  • Open Transactions, Blocking
  • Metadata Sync-up Issues
  • Stored Procedure Recompilations
  • Backup and HA-DR Strategies
  • Db Restores and DB Repairs
  • Health Checks, Issues, Solutions

Ch 9: Server, DB Architecture

  • Server Architecture and Protocols
  • Database Engine and Query Processor
  • Parser, Optimizer, SQL & DB Manager
  • Storage Engine Components, SQL OS
  • File Manager and Database Files
  • Transaction Services, Buffer Manager
  • Lock Manager, IO Manager, MDAC
  • CLR, WAL, Lazy Writer, Checkpoint
  • Database Architecture - Data Files
  • Primary (mdf), Secondary Files (ndf)
  • Filegroups; File Size, Location
  • Pages, Extents. Uniform, Mixed Extents
  • Transaction Log File [LDF], LSN, VLF
  • Linked Servers and Remote DB Access
  • RPC, RPC Out and Remote Data Access

Ch 18: Tuning 4 - Lock Management

  • LOCKS : Types and Isolation Levels
  • S, X, IX,U, MD, Sch-M and Sch-S
  • Lock Audits : SP_WHO2 & SP_LOCK
  • sysprocesses and Lock Waits : Audits
  • Open Transactions, Query Blocking
  • Lock Hints and Isolation Levels
  • Read Committed, Read Uncommitted
  • Serializable and Repeatable Read
  • Snapshot Isolation, Page Versioning
  • Read Committed Snapshot Row Version
  • Choosing Correct Isolation Level
  • Profiler Tool and Lock Templates
  • Profiler Filters, Column Selections
  • Deadlock Audits and Deadlock Graphs
  • XDL Files and Deadlocks Prevention

Ch 27: SQL DBA PROJECT - Level 2

  • Server Down Issues and Solutions
  • Database Down Issues and Solutions
  • Data Missing Issues and Solutions
  • Hot CPU and Resource Allocations
  • Port Level Issues and Solutions
  • Online & Offline Backups, Certificates
  • Ticketing Tools : SLA & OLA Concepts
  • Incident Management and Ticketing
  • Immediate, High and Medium Priority
  • Levels of Support for Production DBA
  • 3rd Party Tools and Real-time Use
  • Automated Backups, Log File Readers
  • Licensing and Pricing Options, CALs
  • Device CALs and User CALs
  • Multiplexing with Server Licenses

Ch 28: CLOUD INTRO, AZURE CONFIG

  • Introduction to Cloud & Advantages
  • Cloud Architecture: IaaS, PasS and SaaS
  • Microsoft Cloud Advantages, Azure Platform
  • Azure Products and Services - MarketPlace
  • Database Implementations in Azure Platform
  • Comparing PaaS and IaaS Implmentations
  • Paas Implementations For SQL Server
  • IaaS Implementations For SQL Server
  • Logical, Virtual Machine, Managed Instance
  • Installing SSMS and Azure Data Studio
  • Azure Account and Free Subscription
  • Azure Resources: Resource Groups Usage
  • Azure Active Directory: User & Groups
  • Azure Active Directory Authentication

Ch 32: XEL, STRETCH DATABASES

  • SQL Traces : Creation and Audits
  • Event Class, Category, Filter, Conditions
  • Extended Events, Target, Action, Session
  • TSQL, SP Debug Events with Global Fields
  • Catalog & Dynamic Management Views
  • XE Profiler - Templates for Event Profiling
  • Comparing XE Profiler with SQL Profiler
  • Azure SQL Database with On-Premise
  • Stretch Databases Tuning Benefits, Cautions
  • Table Migrations with Azure SQL Databases
  • Compute Performance Levels, DSU Pricing
  • Data Storage, Azure Database Snapshots
  • Remote Data Archive Configuration in Azure
  • Database Master Key, Cold Data Migration

Ch 36: POWERSHELL, AZURE VMs

  • Azure Virtual Machines : Deploy, Configure
  • Configure Windows Server, Redhat Linux
  • Azure Storage Blades and Pricing Options
  • Azure VM - Settings, Access & DB Creation
  • On-Premise & Azure VMs: Similarities
  • SQL Server Instance, Agent in Azure VM
  • Azure SQL Database in VM to SQL Cloud
  • Azure SQL Database in VM to on-Prem
  • Deployment Automation Scripts in Azure
  • Azure Cloud Shell - PowerShellGet
  • Power Shell Scripts for Configurations
  • Power Shell Scripts for Job Schedules
  • Power Shell Scripts for Firewall, ARM
  • Azure CLI - Purpose, Real-time Use

Ch 29: AZURE SQL SERVER CONFIG

  • Installing SSMS and Azure Data Studio
  • Azure Account and Free Subscriptions
  • Azure SQL Server (Logical Server)
  • Azure SQL Server Logical Server Firewall
  • Firewall Rules - IP for Remote Access
  • Server Properties and Status Format
  • Password Resets in Azure SQL Server
  • Azure SQL Databases & Pricing Tiers
  • Azure SQL Database Access from SSMS
  • Elastic Scaling with Azure Databases
  • General Purpose and Business Critical
  • Basic, Standard and Premium Plans
  • vCore Based Purchasing : Gen 4, Gen 5
  • Resource Groups For Azure SQL Server

Ch 33: ALERTS, BACKUPS / RESTORES

  • Azure SQL Server Activity Log and Options
  • Events, Operations and Event Categories
  • Quick Insights from Events and Filters
  • Events Exports to Event Hub, Log Analytics
  • Log Analytics Workspace, Alert Rules
  • Email / SMS Notifications and Schedules
  • Log Analytics Settings and Azure Storage
  • Activity Logs and Audit Reports, Insights
  • Azure SaaS Notifications System Options
  • Automated Backups in Azure SQL Database
  • Long Term, Automated Backup Retentions
  • Backups - Retentions, Audits. LTR Policy
  • Restore Points and Database Recovery
  • Geo-Redundant Backups and Restores

Ch 37: Windows Clusters with Azure VM

  • Windows Clusters For HA and DR
  • Virtual Networks, Subnets and Ips
  • Availability Sets and Availability Zones
  • Fault Domains and Update Domains
  • DC Deployment & Configurations
  • Active Directory Domain Services
  • SAN [Storage Area Network] and LUN
  • DNS Server, DSRM and Private IP
  • Windows Level Clusters, MSCS Service
  • Active-Active, Active-Passive Clusters
  • DNS Tools, Actions & Adding AA Hosts
  • SQL Clustering Service & RAID Levels
  • SQL Cluster Groups, Domain Accounts
  • Quorum and MSDTC Disks. LUN Grows

Ch 30: ELASTIC DTUs, MIGRATION

  • Azure Storage: Creation & Containers
  • LRS, GRS and RA-GRS Storage Accounts
  • Storage Containers, Storage Explorer Tool
  • Data and Database Migration in Azure
  • Data Migration Assistant (DMA) Tool
  • DB Migrations To Azure SQL Databases
  • Database Exports and Imports in Azure
  • Migration Scopes: Schema and Data
  • Schema Generation, Migration Compatibility
  • Data Migration Verification and Row Counts
  • DTU: Data Transaction Unit and Resources
  • Bounding Box Model, Elastic Pool Queries
  • eDTUs, Elastic Pool. Per Database Settings
  • Performance Recommendations in Azure

Ch 34: HA - DR : Geo Replication, DB Sync

  • Failover Groups, Active Geo-Replication
  • Read-Write Policy & Automated Failover
  • Geo Replication Configuration in Azure
  • Primary-Secondary and Read / Write Modes
  • GeoReplication Monitoring, Forced Failover
  • Azure Server Failover Process, Strategies
  • Automated, Manual and Forced Failover
  • Backup Errors, Geo Replication Errors
  • SQL Data Sync Service and Sync Groups
  • HUB, MEMBER and SYNC DATABASE
  • Sync Direction, Sync Schema, Sync Interval
  • bi-directional Load Balancing and Failover
  • Conflict Resolutions with HUB, MEMBER
  • Cloud to Cloud, OnPremise Synchronization

Ch 38: Always-On in SQL Server Clusters

  • SQL Server VMs and File Share Witness
  • Joining Machines to Domain Network
  • Install Accounts to Active Directory
  • Install Failover Cluster (FCI) Features
  • Firewall Configurations, Port Exceptions
  • FSW File Shares and Usability Options
  • Need for Always - On Availability (AAG)
  • Always On Availability Group [AOAG]
  • Multi-Database Replication Options
  • Backup Preferences, Automated Seeding/li>
  • Synchronous and Asynchronous Modes
  • Data Synchronization for AOAG
  • AOAG Dashboards & Automated Failover
  • Need for Azure Managed Instances

Ch 31: AZURE SQL DATABASE TUNING

  • Azure SQL Server Level Tuning Options
  • Azure SQL Database Level Tuning Options
  • Automated Tuning Options and Peak-Loads
  • Force Plan, Create Index and Drop Index
  • Performance Insight and Recommendations
  • IO Metrics, CPU Metrics & Query Statistics
  • Data File IO, Log File IO, Custom Reports
  • Query Audits with Query IDs, Dashboards
  • DTU Usage Reports and Elastic Queries
  • Query Recommendations, Query Costs
  • Azure Search Service and Pricing Tiers
  • Azure Search for Data Import. Indexer
  • Suggester and Analyzer Modes for Tuning
  • Retrievable, Facetable, Facetable Indexes
  • Filterable and Searchable Indexes
  • Change Tracking & Watermark Columns

Ch 35: SECURITY MANAGEMENT, RLS

  • Firewall and Virtual Network Configurations
  • Server Firewall, Database Firewall Rules
  • System Procedures for Firewall Settings
  • Logins, Users, Roles Permissions @ T-SQL
  • Creating Users without Logins. Containment
  • GRANT, DENY, REVOKE, WITH GRANT
  • Role Level and Schema Level Security
  • Threat Detection, Transparent Data Encryption
  • Vulnerability Assessment, Data Masking
  • Implementing RLS - Row Level Security
  • Creating Users with and without Logins
  • Using SECURITY Schema for RLS Functions
  • Creating Security Predicates and Filters
  • Security Policies for Row Level Security
  • EXECUTE AS option & STATE for RLS
  • Dynamic Data Masking with Azure SQL DB

Ch 39: Project Work, DP 300 Exam

Real-time Project

 

DP 300 Certification Guidance

 

Part 1: Power BI Report Design

Part 2: ETL, Data Modeling, DAX

Part 3: Power BI Cloud, Admin

Ch 1 : POWER BI BASICS

  • Power BI Job Roles in Real-time
  • Power BI Data Analyst Job Roles
  • Business Analyst - Job Roles
  • Power BI Developer - Job Roles
  • Power BI for Data Scientists
  • Comparing MSBI and Power BI
  • Comparing Tableau and Power BI
  • MCSA 70-778, MCSA 70-779 Exam
  • Types of Reports in Real-World
  • Interactive & Paginated Reports
  • Analytical & Mobile Reports
  • Data Sources Types in Power BI
  • Power BI Licensing Plans - Types
  • Power BI Training : Lab Plan
  • Power BI Dev & Prod Environments

Ch 7 : POWER QUERY LEVEL 1

  • Power Query M Language Purpose
  • Power Query Architecture and ETL
  • Data Types, Literals and Values
  • Power Query Transformation Types
  • Table & Column Transformations
  • Text & Number Transformations
  • Date, Time and Structured Data
  • List, Record and Table Structures
  • let, source, in statements @ M Lang
  • Power Query Functions, Parameters
  • Invoke Functions, Execution Results
  • Get Data, Table Creations and Edit
  • Merge and Append Transformations
  • Join Kinds, Advanced Editor, Apply
  • ETL Operations with Power Query

Ch 13 : POWER BI CLOUD - 1

  • Power BI Service Architecture
  • Power BI Cloud Components, Use
  • App Workspaces, Report Publish
  • Reports & Related Datasets Cloud
  • Creating New Reports in Cloud
  • Report Publish and Report Uploads
  • Dashboards Creation and Usage
  • Adding Tiles to Dashboards
  • Pining Visuals and Report Pages
  • Visual Pin Actions in Dashboards
  • LIVE Page Interaction in Dashboard
  • Adding Media: Images, Custom Links
  • Adding Chs and Embed Links
  • API Data Sources, Streaming Data
  • Streaming Dataset Tiles (REST API)

Ch 2: BASIC REPORT DESIGN

  • Power BI Desktop Installation
  • Data Sources & Visual Types
  • Canvas, Visualizations and Fields
  • Get Data and Memory Tables
  • In-Memory xvelocity Database
  • Table and Tree Map Visuals
  • Format Button and Data Labels
  • Legend, Category and Grid
  • PBIX and PBIT File Formats
  • Visual Interaction, Data Points
  • Disabling Visual Interactions
  • Edit Interactions - Format Options
  • SPOTLIGHT & FOCUSMODE
  • CSV and PDF Exports. Tooltips
  • Power BI EcoSystem, Architecture

Ch 8 : POWER QUERY LEVEL 2

  • Query Duplicate, Query Reference
  • Group By and Advanced Options
  • Aggregations with Power Query
  • Transpose, Header Row Promotion
  • Reverse Rows and Row Count
  • Data Type Changes & Detection
  • Replace Columns: Text, NonText
  • Replace Nulls: Fill Up, Fill Down
  • PIVOT, UNPIVOT Transformations
  • Move Column and Split Column
  • Extract, Format and Numbers
  • Date & Time Transformations
  • Deriving Year, Quarter, Month, Day
  • Add Column : Query Expressions
  • Query Step Inserts and Step Edits

Ch 14 : POWER BI CLOUD - 2

  • Dashboards Actions,Report Actions
  • DataSet Actions: Create Report
  • Share, Metrics and Exports
  • Mobile View & Dashboard Themes
  • Q & A [Cortana] and Pin Visuals
  • Export, Subscribe, Subscribe
  • Favorite, Insights, Embed Code
  • Featured Dashboards and Refresh
  • Gateways Configuration, PBI Service
  • Gateway Types, Cloud Connections
  • Gateway Clusters, Add Data Sources
  • Data Refresh : Manual, Automatic
  • PBIEngw Service, ODG Logs, Audits
  • DataFlows, Power Query Expressions
  • Adding Entities and JSON Files

Ch 3 : Visual Sync, Grouping

  • Slicer Visual : Real-time Usage
  • Orientation, Selection Properties
  • Single & Multi Select, CTRL Options
  • Slicer : Number, Text and Date Data
  • Slicer List and Slicer Dropdowns
  • Visual Sync Limitations with Slicer
  • Disabling Slicers,Clear Selections
  • Grouping : Real-time Use, Examples
  • List Grouping and Binning Options
  • Grouping Static / Fixed Data Values
  • Grouping Dynamic / Changing Data
  • Bin Size and Bin Limits (Max, Min)
  • Bin Count and Grouping Options
  • Grouping Binned Data, Classification

Ch 9 : POWER QUERY LEVEL 3

  • Creating Parameters in Power Query
  • Parameter Data Types, Default Lists
  • Static/Dynamic Lists For Parameters
  • Removing Columns and Duplicates
  • Convert Tables to List Queries
  • Linking Parameters to Queries
  • Testing Parameters and PBI Canvas
  • Multi-Valued Parameter Lists
  • Creating Lists in Power Query
  • Converting Lists to Table Data
  • Advanced Edits and Parameters
  • Data Type Conversions, Expressions
  • Columns From Examples, Indexes
  • Conditional Columns, Expressions

Ch 15 : EXCEL & RLS

  • Import and Upload Options in Excel
  • Excel Workbooks and Dashboards
  • Datasets in Excel and Dashboards
  • Using Excel Analyzer in Power BI
  • Using Excel Publisher in PBI Cloud
  • Excel Workbooks, PINS in Power BI
  • Excel ODC Connections, Power Pivot
  • Row Level Security (RLS) with DAX
  • Need for RLS in Power BI Cloud
  • Data Modeling in Power BI Desktop
  • DAX Roles Creation and Testing
  • Adding Power BI Users to Roles
  • Custom Visualizations in Cloud
  • Histogram,Gantt Chart,Infographics

Ch 4 : Hierarchies, Filters

  • Creating Hierarchies in Power BI
  • Independent Drill-Down Options
  • Dependant Drill-Down Options
  • Conditional Drilldowns, Data Points
  • Drill Up Buttons and Operations
  • Expand & Show Next Level Options
  • Dynamic Data Drills Limitations
  • Show Data and See Records
  • Filters : Types and Usage in Real-time
  • Visual Filter, Page Filter, Report Filter
  • Basic, Advanced and TOP N Filters
  • Category and Summary Level Filters
  • DrillThru Filters, Drill Thru Reports
  • Keep All Filters" Options in DrillThru
  • CrossReport Filters, Include, Exclude

Ch 10 : DAX Functions - Level 1

  • DAX : Importance in Real-time
  • Real-world usage of Excel, DAX
  • DAX Architecture, Entity Sets
  • DAX Data Types, Syntax Rules
  • DAX Measures and Calculations
  • ROW Context and Filter Context
  • DAX Operators, Special Characters
  • DAX Functions, Types in Real-time
  • Vertipaq Engine, DAX Cheat Sheet
  • Creating, Using Measures with DAX
  • Creating, Using Columns with DAX
  • Quick Measures and Summaries
  • Validation Errors, Runtime Errors
  • SUM, AVERAGEX, KEEPFILTERS
  • Dynamic Expressions, IF in DAX

Ch 16 : Report Server, RDL

  • Need for Report Server in PROD
  • Install, Configure Report Server
  • Report Server DB, Temp Database
  • Webservice URL, Webportal URL
  • Creating Hybrid Cloud with Power BI
  • Using Power BI DesktopRS
  • Uploading Interactive Reports
  • Report Builder For Report Server
  • Report Builder For Power BI Cloud
  • Designing Paginated Reports (RDL)
  • Deploy to Power BI Report Server
  • Data Source Connections, Report
  • Power BI Report Server to Cloud
  • Tenant IDs Generation and Use
  • Mobile Report Publisher, Usage

Ch 5 : Bookmarks, Azure, Modeling

  • Drill-thru Filters, Page Navigations
  • Bookmarks : Real-time Usage
  • Bookmarks for Visual Filters
  • Bookmarks for Page Navigations
  • Selection Pane with Bookmarks
  • Buttons, Images with Actions
  • Buttons, Actions and Text URLs
  • Bookmarks View & Selection Pane
  • OLTP Databases, Big Data Sources
  • Azure Database Access, Reports
  • Import & Direct Query with Power BI
  • SQL Queries and Enter Data
  • Data Modeling : Currency, Relations
  • Summary, Format, Synonyms
  • Web View & Mobile View in PBI

Ch 11 : DAX Functions - Level 2

  • Data Modeling Options in DAX
  • Detecting Relations for DAX
  • Using Calculated Columns in DAX
  • Using Aggregated Measures in DAX
  • Working with Facts & Measures
  • Modeling : Missing Relations
  • Modeling : Relation Management
  • CALCULATE Function Conditions
  • CALCULATE & ALL Member Scope
  • RELATED & COUNTROWS in DAX
  • Entity Sets and Slicing in DAX
  • Dynamic Expressions, RETURN
  • Date, Time and Text Functions
  • Logical, Mathematical Functions
  • Running Total & EARLIER Function

Ch 17: MSBI Integrations

  • Power BI with SQL Server Source
  • Power BI with SQL Data Warehouse
  • Power BI with SSAS OLAP Server
  • Power BI with Azure SQL DB Source
  • Power BI with Azure SQL Warehouse
  • Power BI with Azure Analysis Server
  • Power BI with SSRS (RDL) Reports
  • Power BI Report Builder Tool
  • Installation & Configuration
  • Paginated Reports Design, Use
  • Data Sources, Datasets, RDL
  • Report Publish (RDL) to Cloud
  • Report Verifications, Data Sync
  • Interactive Vs Paginated Reports
  • Creating, Managing Alerts in Cloud

Ch 6 : Visualization Properties

  • Stacked Charts and Clustered Charts
  • Line Charts, Area Charts, Bar Charts
  • 100% Stacked Bar & Column Charts
  • Map Visuals: Tree, Filled, Bubble
  • Cards, Funnel, Table, Matrix
  • Scatter Chart : Play Axis, Labels
  • Series Clusters & Selections
  • Waterfall Chart and ArcGIS Maps
  • Infographics, Icons and Labels
  • Color Saturation, Sentiment Colors
  • Column Series, Column Axis in Lines
  • Join Types : Round, Bevel, Miter
  • Shapes, Markers, Axis, Plot Area
  • Display Units,Data Colors,Shapes
  • Series, Custom Series and Legends

Ch 12 : DAX FUNCTIONS Level 3

  • 1:1, 1:M and M:1 Relations
  • Connection with CSV, MS Access
  • AVERAGEX and AVERAGE in DAX
  • KEEPFILTERS and CALCUALTE
  • COUNTROWS, RELATED, DIVIDE
  • PARALLELPERIOD, DATEDADD
  • CALCULATE & PREVIOUSMONTH
  • USERELATIONSHIP, DAX Variables
  • TOTALYTD , TOTALQTD
  • DIVIDE, CALCULATE, Conditions
  • IF..ELSE..THEN Statement
  • SELECTEDVALUE, FORMAT
  • SUM, DATEDIFF Examples in DAX
  • TODAY, DATE, DAY with DAX
  • Time Intelligence Functions - DAX
Ch 18 : REAL-TIME PROJECT
  • Project Requirement Analysis
  • Implementing SDLC Phases
  • Requirement Gathering, FSA
Phase 1:
  • PBIX Report Design
  • Visualizations, Properties
  • Analytics and Formating
Phase 2:
  • Data Modeling, Power Query
  • Dynamic Connections, Azure DB
  • Parameters and M Lang Scripts
Phase 3:
  • DAX Requriements, Analysis
  • Cloud and Report Server
  • Project FAQs and Solutions

Above course curriculum applicable for registrations from Apr 23rd, 2022

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.

 
Trainer Profile
Reviews
Course Curriculum
Training Details
Free Demo
Register Today
 

SQL DBA Online Training- Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • 100% Realtime and Practical Concepts
  • Chapter Wise Mock Interviews, Solutions
  • 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
  • Azure Virual Machines (VM) and Stretch Databases
  • Azure Power Shell,Azure HA-DR, Security Management
 
Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses