Azure SQL DBA Online Training (LIVE, Instructor-Led)

This Azure 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 and Security Management.

This SQL DBA Online Training also practical implementation of Always-On Availability Groups [AOAG] in Windows Clusters as well as in LINUX Clusters. Additionally, this SQL DBA Training Course extents to Microsoft (Cloud) SQL Azure Migrations, Geo Replication, Azure DB Sync, Azure Database Tuning and Security Management. Study Material, MCSA SQL DBA Certification (DP 300) with Real-time Projects for your Resume as also a part of this SQL DBA Training Course. Versions: SQL Server 2014, 2016, 2017 and 2019.

Azure SQL DBA Training Plans

	PLAN A	PLAN B	PLAN C
SQL DBA Job Profile	Azure DBA	Core DBA + Azure DBA	Core DBA + Azure DBA + Power BI
SQL DBA Course Duration	3 Weeks	9 Weeks	13 Weeks
Course Contents	Ch 28 to Ch 39	Ch 1 to Ch 39	Ch 1 to Ch 57
Azure SQL Database Migration	✔	✔	✔
Azure SQL DB Security, HA-DR	✔	✔	✔
Azure Always-On, PowerShell	✔	✔	✔
Azure Virtual Machines (VM)	✔	✔	✔
DP 300 Exam : Guidance	✔	✔	✔
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	✖	✔	✔
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 9,000 USD 122	INR 27,000 USD 365	INR 35,000 USD 473

Trainer : Mr. Sai Phanindra T

S No	Timings (IST)	Start Date
Schedules for Azure DBA [Chapters 28 to 39]
	Weekend Schedules [Sat & Sun]
1	6 AM - 8 AM	July 9th	Register
2	8 PM - 10 PM	July 2nd	Register

S No	Timings (IST)	Start Date
Schedules for SQL DBA [Chapters 1 to 27]
Regular Schedules [Mon - Fri]
1	6 AM - 7 AM	July 4th	Register
2	8 PM - 9 PM	July 18th	Register

Azure 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

All Trainings are completely Practical and Real-Time. Curriculum Download

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

Azure SQL DBA Training (with SQL Server) Contents:

Brochure

Register Today

Course 1: SQL DBA Training Content For Plan B, C

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

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

Course 2: Azure DBA Training ContentFor Plan A, B, C

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

Course 3: Power BI Training Content [For Plans C]

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

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 Dec 2nd, 2020

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
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