SQL DBA Online Training (LIVE, Instructor-Led)

Real-time Practical SQL DBA LIVE Online Training for any Production DBA : Capacity Planning, Query Tuning, Index Management, Database Maintenance, High Availability, Disaster Recovery, Memory Optimization, DB Repairs, Always-On in SQL Cluster and SQL / Windows Azure. Course includes Study Material, 24x7 Online Lab, Certification, Job Support with One Realtime Project. Versions: SQL Server 2012, SQL Server 2014 & 2016.

Schedules for SQL DBA Online Training (LIVE, Interactive)

 
Timings (IST) Free Demo Start Date  
1 6:30 AM to 8 AM Nov 1st Nov 3rd Register
2 10 AM to 11:30 AM Oct 13th Oct 16th Register
3 6:30 PM to 8 PM Oct 23rd Oct 25th Register
 
None of the above schedules work for you? Register @ 24 x 7 Video Training
 

Trainer : Mr Sai Phanindra T (11+ Yrs Exp)

Dur : 6 - 7 Weeks
Course Fee : INR 18000/- (USD 300)
COURSE HIGHLIGHTS
Daily Tasks & Lab Real-time Examples
Always-On and HA/DR Performance Tuning
AZURE Cloud @ DBA MCSA Certification
Trainer : Mr. Sai phanindra T (11+ Yrs EXP). Profile
 

SQL DBA (with Server, T-SQL) Course Contents:

Module I: SQL Server & Design, Queries

Duration: 2 Weeks

Module II: Basic SQL DBA

Duration: 2 - 2.5 Weeks

Module III: Advanced SQL DBA, Cloud

Duration: 2 - 2.5 Weeks

DAY 1: SQL SERVER INSTALLATION

  • What is Database? Need for DB Admins
  • Editions and Versions Of SQL Server
  • Roles and Responsibilities For SQL DBA
  • How to install SQL Server - Step by Step
  • SQL Server 2016, 2014, 2012 Installation
  • SQL Server Management Studio (SSMS)
  • SSMS and SQLCMD Tool Configurations
  • DBA Checklist - Routine DBA Activities
  • DBA Checklist - Maintenance Activities
  • DBA Checklist - Emergency Activities
  • Course Plan and Free Takeaways
  • MCSA Certification Pattern - Course Plan
  • Online Lab Access (24x7 LIVE Server)

DAY 2: SQL SERVER ARCHITECTURE

  • Client - Server Architecture of SQL Server
  • TCP / IP, Named Pipes, Shared Memory
  • SQL Native Client, OLE DB Drivers
  • Query Processor Architecture, SNAC
  • TDS Packets and Storage Engine
  • Parser, Optimizer and File System
  • SQL Engine, MDAC and SQL Buffers
  • Write Ahead Log,Lazy Writer,Checkpoints
  • Query Optimizer (QO) & Execution Plans
  • Query Processing and Optimizer (QO)
  • Log File Architecture - Virtual Log Files
  • Log File Architecture - Mini LSN, Usage
  • DB Catalogs, CLR Integration, MDAC
  • LSN Timestamps, Background Threads
  • SQL OS Components, Thread Scheduler
  • Buffer Manager, IO Manager and CLR
  • SQL Server with External Protocols

DAY 3: DATABASE & TABLE ARCH

  • SQL Server Database Architecture
  • Data Files : Purpose, Sizing, Options
  • Filegroups : Placement, Usage & Options
  • Log files : Sizing, Placement, Growth
  • Database Creation - GUI & SQL Scripts
  • Filegrowth, Autogrowth and MAXSIZE
  • Planning, Designing Large Databases
  • Capacity Advantages - Filegroups, Files
  • Database Structure - Modifications
  • Adding New Filegroups, Files to DB
  • Capacity Planning, Dedicated Log Store
  • Data File Architecture - Pages, Extents
  • Log File Architecture - VLF, Mini LSN
  • Routing Tables to File Groups, Usage
  • Schemas - Purpose, Usage with Tables
  • CHAR versus VARCHAR Differences
  • DB Log Files - Logged and NonLogged
  • Default Schema, Aliases for Table Design

DAY 4: CONSTRAINTS and KEYS

  • Constraints and Keys - Purpose, Usage
  • Normal Forms, Relational DB Design
  • OLTP DB Models, BCNF - Relations
  • NULLABILITY Property and Importance
  • UNIQUE KEY Constraints, Importance
  • PRIMARY KEY Constraints, Limitations
  • FOREIGN KEY References, Relations
  • FOREIGN KEY Constraints - Limitations
  • Schema Level and Table Level Relations
  • CHECK Constraints - Usage, Limitations
  • DEFAULT Column Constraints, Usage
  • Identity Property with PRIMARY KEY
  • Constraint Priority and DB Properties
  • Data Types and Aliases with Schemas

DAY 5: JOINS & SUB QUERIES

  • Need for Joins and Use Case Scenarios
  • JOIN - Types, Queries & Usage Options
  • CROSS JOIN - Examples and Scenarios
  • INNER JOIN - Examples and Scenarios
  • OUTER JOINS - Types and Scenarios
  • SELF JOINS with Self References, Types
  • Joins with / without SCHEMA References
  • Joining Multiple Tables and Join Types
  • Aggregations in Joins. Table Aliasing
  • Comparing Inner Join and Outer Joins
  • Sub Queries and Joins. Alternate Syntax
  • Sub Queries with UNION, UNION ALL
  • Aggregations on Joined Sub Queries

DAYS 6: VIEWS

  • Views on Tables, Security Advantages
  • Views as Stored SELECT Statements
  • SCHEMABINDING and ENCRYPTION
  • Cascaded Views, WITH CHECK OPTION
  • Orphan Views - Scenarios in Realworld
  • Common System Views, Metadata Access
  • sys.databases, sys.tables, sys.views
  • INFORMATION SCHEMA, Definitions
  • Views with Multi Level Tables - Joins
  • Views on UNION ALL, Sub Queries
  • Views on Nested Queries, Aliases

DAYS 7: FUNCTIONS, QUERIES

  • Functions: Types, Purpose and Usage
  • Scalar Value Returning Functions - Usage
  • Table Value Returning Functions
  • RETURNS and RETURN Values. Options
  • BEGIN..END and IIF Functions, CASE
  • Variables and Function Parameters
  • Static Variables and Dynamic variables
  • System Functions and Metadata Access
  • Queries - GROUP BY, HAVING Conditions
  • Queries with GROUPING() and HAVING
  • HAVING Vs WHERE - Performance
  • Query Execution Order @ ROLLUP, CUBE

DAY 8: STORED PROCEDURES - Level 1

  • Stored Procedures - Purpose and Usage
  • Execution Options and Variants, Batch
  • Variables, Parameters in Stored Procs
  • Stored Procedures For Data Validations
  • Stored Procedures For Dynamic Queries
  • Important System Procedures, Metadata
  • Extended Procedures For App. Access
  • IF.. ELSE, ELSE IF, IIF, IS Conditions
  • Error Handling: TRY, CATCH, THROW
  • Usage of THROW - Performance Issues
  • Precompilation of Stored Procedures
  • Cached Plans, Compiled Plans, PC Cache

DAY 9: STORED PROCEDURES - Level 2

  • Stored Procedures for Dynamic Queries
  • Recursive Queries: OUTPUT Parameters
  • Using Stored Procedures with Cursors
  • FORWARD_ONLY and SCROLL Cursors
  • STATIC, DYNAMIC Cursors. ABSOLUTE
  • LOCAL and GLOBAL Cursor. Reusability
  • KEYSET Cursor & Performance Options
  • Embedding Cursors in Procedures
  • Memory Limitations with Cursors, SPs
  • WHILE Loops, System Global Variables
  • Need for Recompilations, Outdated Plans
  • Dynamic SQL Parameters and Variables
  • OUTPUT Parameters, RECOMPILE Option

DAY 10: TRIGGERS

  • Use of Triggers - Use, Performance
  • FOR / AFTER Triggers - Importance
  • INSTEAD OF Triggers - Importance
  • INSERTED, DELETED Memory Tables
  • Triggers for DML Audits, Data Sampling
  • Database Level, Server Level Triggers
  • Bulk Operations & Updatable Views
  • Table Audits and Linked Servers
  • Data Replication using Triggers
  • DDL Triggers : Database Scoped
  • DDL Triggers : Server Scoped
  • Performance Impact of Triggers

DAY 11: TRANSACTIONS

  • ACID Properties and Transaction Types
  • EXPLICIT Transactions - Advantages
  • IMPLICIT Transactions - Advantages
  • Open Transactions - Query Blocking
  • AUTOCOMMIT Transactions - Advantages
  • Nesting Transactions and Save Points
  • @@TRANCOUNT and @@ERROR
  • DBCC OPENTRAN and SP_WHO2
  • LOCK HINTS: READPAST, NOLOCK
  • Transactions with SET Options, Cautions
  • Transactions with Triggers, SPs, Views

DAY 12: QUERY TUNING (INDEXES)

  • Indexes Types - B Tree Architecture
  • Clustered Indexes - Architecture
  • NonClustered Indexes - Architecture
  • Execution Plans & Query Optimization
  • Table Scan, Index Scan, Index Seek
  • SORT_IN_TEMPDB and Index Memory
  • FILLFACTOR and PAD_INDEX Options
  • INCLUDED Indexes, HEAP Performance
  • COLUMN STORE Indexes - Advantages
  • FILTERED Indexes - Query Performance
  • ONLINE Indexes and OFFLINE Indexes
  • Materialized Views (Indexed Views) Usage
  • Unique Clustered, NonClustered Indexes
  • Estimated Execution Plans and Usage
  • Actual Execution Plans - Precautions
  • Client Statistics and Perf. Metrics

DAY 13: BACKUPS - OPTIONS

  • Backups - Background Threads, MSDB
  • Backups - Types, Importance, Options
  • Data Backups, Checkpoints, Page Level
  • File Backups, Filegroup Backups - Extents
  • Log Backup Mechanism, Data Truncates
  • Partial Backups with ReadOnly Filegroups
  • Mirrored Backups, FORMAT, SKIP, STATS
  • Tape Backups - LOAD, UNLOAD, ERRORS
  • COMPRESSION, CHECKSUM, VERIFY
  • ContinueOnError, Backup Validation
  • Backup History - Media Set, Media Family
  • Compatibility, Recovery Model Options
  • COPY_ONLY Backups and Importance
  • Backup Devices and Verification
  • Backups using GUI and T-SQL Scripts
  • Real-time Errors, Solutions @ Day 35,36

DAY 14: RESTORES & DB RECOVERY

  • Restore Phases - COPY, REDO, UNDO
  • File Restores and Filegroup Restores
  • FILELISTONLY, VERIFYONLY, REPLACE
  • PARTIAL, PIECEMEAL Restores - Tuning
  • Tail Log Backups & DB Recovery Options
  • REDO Phase in T-Log Backups, Purpose
  • Tail Log Backup Restores, UNDO Phase
  • Partial Backups - STATS, VERIFY Options
  • Strategies: Piecemeal/Piecemeal Restores
  • SQL Server 2012 to 2014,2016 Restores
  • Choosing correct DB Recovery Model
  • Point-In-Time Restores and Log Recovery
  • Restores From Backup Devices & Mirrors
  • Restores using GUI & T-SQL Scripts
  • Restore Audits and Standby Databases
  • Checkpoint LSN and Restore Positions
  • Real-time Errors, Solutions @ DAY 35.36

DAY 15: JOBS, SQL SERVER AGENT

  • SQL Server Agent Service, Agent XPs
  • SQL Agent Jobs - GUI Options, MSDB
  • Job Steps: T-SQL, SSIS, Replication
  • Job Schedules and Email Notifications
  • Job Executions, Disable/Enable Options
  • Job History and Job Activity Monitor
  • Import & Export (SSIS) Operations
  • SSIS Packages for Data Import/Export
  • SSIS Package Store - File System, MSDB
  • SSIS Jobs - Scheduling SSIS Packages
  • Backup Strategies For Minimal Data Loss
  • Backup Jobs & Recovery Modes : Usage
  • FULL, SIMPLE, BULKLOGGED Modes
  • Backup Limitations with Recovery Modes
  • Startup Jobs, Onetime, Recurring Jobs
  • Job Activity Monitor and Agent Threads

DAY 16: PERFORMANCE TUNING - 1

  • Identifying Long Running Queries
  • Dynamic Management Objects: DMV, DMF
  • Audit Long Running Queries - DMV/DMF
  • Query Statistics & LIVE Execution Plans
  • CROSSAPPLY with Dynamic Views
  • Avoding Sub Queries and Conditions
  • Comparing Sub Queries and Query Joins
  • Query Tuning and Resource Optimization
  • Common Table Expressions (CTE) & Uses
  • Using CTE, Data Retrieval in Stored Procs
  • CTEs for Avoiding Self Joins, Scenarios
  • CTE Advantages and Memory Limitations
  • HASH JOIN Examples and Precautions
  • MERGE JOIN Examples and Precautions
  • LOOP JOIN Examples and Precautions
  • OUTER APPLY and Multi - Level Joins

DAY 17: PERFORMANCE TUNING - 2

  • Table Partitions and Query Tuning Options
  • Partition Functions and Partition Schemes
  • Partition Ranges, Values and Sort Orders
  • Partition Un-partitioned Tables: Indexes
  • Aligned / Indexed Partitions - Importance
  • Data Compression - ROW & PAGE Levels
  • Partition Numbers & Filtered Compression
  • Managing Partitions and Tuning Options
  • Partition Management @ SPLIT, MERGE
  • Partition Elements, Concolation Options
  • STATISTICS - Purpose and Tuning Options
  • Column Statistics and Index Statistics
  • Manual Update of Column Statistics
  • Statistics in Query Tuning Process
  • STATISTICS in Indexes, Query Conditions
  • LIVE Query Statistics, Table Statistics

DAY 18: PERFORMANCE TUNING - 3

  • LIKE Operator - Using Wild Cards
  • Full Text Search Architecture
  • StopWords, Stemmer and Thesaurus
  • Full Text Search Service Configuration
  • Database Catalogs (FTC) and FDHost.exe
  • Full Text (FT) Indexes for Query Tuning
  • Full Text Columns and Primary Key Index
  • Full Population, Incremental Population
  • CONTAINS() and FREETEXT() Functions
  • Token Search and Inflectional Forms
  • Performance Tuning @ Full Text Indexes
  • CONTAINSTABLE and FREETEXTTABLE
  • Real-world Considerations with FTS
  • FT Index Management Options, Statistics
  • Stop Words Management, Tuning Options
  • New Tuning Options @ SQL 2017

DAY 19: PERFORMANCE TUNING - 4

  • Index Internals and Index Management
  • Execution Plans, Statistics, Query Cost
  • Index Fragmentation Issues, Performance
  • SAMPLED & DETAILED Scans. FillFactor
  • Index Rebuilds (Online/Offline), Tuning
  • Index Reorganization and Advantages
  • Page, Row Compressions with Indexes
  • Filtered & Online Indexes, Indexes Views
  • GAM, SGAM Pages, Table Statistics
  • Heaps, Clustered, Nonclustered Indexes
  • Fill Factor, Pad Index and Query Tuning
  • DTA: Sequential / Parallel Query Tuning
  • DTA Tool with Profiler, Trace Tables, Cache
  • Workload Files & Tables in Profiler
  • SQL Profiler Tuning and Tuning Templates
  • Database Tuning Advisor (DTA) - Usage
  • DTA for Procedure Cache, Recent Queries
  • Understanding PDS Options with Indexes
  • MORE TUNING CONCEPTS: DAY 33,34

DAY 20: REPLICATION For HA - LEVEL 1

  • Replication Architecture and Entities
  • Replication Topology, Plan, Connections
  • Distributor Server Configurations, Options
  • Distribution DB Configuration, Snapshots
  • Publication Types - Purpose, Importance
  • DB Articles, Publications, Subscriptions
  • PULL Subscription Options and Types
  • Snapshot Replication and Repl Agents
  • Configure, Secure, Schedule Snapshots
  • Transactional Replication Configuration
  • Log Reader Agent - Configuration, Keys
  • Tracer Tokens - Latency and Ranking
  • Replication Monitor - Usage and Options
  • Replication Jobs and Load Balancing
  • Adding Articles to Existing (LIVE) Replica
  • Stopping, Starting Replication Agents
  • Scripting Replication Jobs, Publications
  • Disable/Enable Replication, Agent Stops
  • Real-time Errors, Solutions @ DAY 35

DAY 21: REPLICATION For HA - LEVEL 2

  • Transactional Replication, Tracer Tokens
  • Merge Replication and Merge Agent Job
  • Replication Conflicts and ROWGUIDCOL
  • Peer-Peer Replication Connections, Nodes
  • Adding Peer Nodes, Node ID Conflicts
  • Replication Conflicts: Options, sp_MSRepl
  • IDENTITY Property & Schema Replication
  • PUSH and PULL Subscriptions - Options
  • Domain Account Security in Replication
  • Merge, Snapshot Replication Limitations
  • Replica Initialization with Backups, Issues
  • Peer-Peer Vs Merge Replication For HA
  • Load Balancing Options with Replication
  • Replica Server @ Appl Connection Strings
  • Replication Conflicts, Errors and Solutions
  • Replication Warnings and Agent Alerts
  • Replication for HA and DR - Strategies
  • Replication Errors, Solutions @ DAY 35

DAY 22,23: HA & DR STRATEGIES

  • Log Shipping Topology, Operation Modes
  • Primary and Secondary: Recovery Plan
  • Log Shipping Monitor Settings, Alerts
  • NORECOVERY Configuration and Usage
  • STANDBY Mode Configuration, Purpose
  • Log Shipping Jobs & Restore Schedules
  • Manual Failover Process and Recovery
  • Log Shipping Jobs - Errors and Solutions
  • DB Mirroring Architecture For HA,DR
  • TCP Endpoints and TCP Network Security
  • Heartbeat and Polling Concepts in DM
  • Automatic Fail-Over Procedures, Tests
  • PARTNER OFFLINE Conditions & Options
  • DB Mirroring Monitors and Commit Loads
  • SYNCHRONOUS & ASYNCHRONOUS
  • Mirroring Monitor, Stop/Resume Options
  • Need for Always-On & Higher Availability
  • DB Recovery without Witness. Failover
  • DB Mirroring Errors, Solutions @ DAY 35

DAY 24: DB HEALTH CHECKS, AUDITS

  • Query Resources - CPU, IO and Memory
  • Activity Monitor (AM) Tool - CPU, Memory
  • SQL Profiler Tool Usage, Audit Trace Files
  • SQL Profiler Templates: Standard, Tuning
  • Event Extraction Settings, Filter Columns
  • Profile Trace File Rollover, Size Settings
  • Database Health Check: DBCC Commands
  • Allocation Errors and Consistency Errors
  • ESTIMATEONLY, NOINFOMSGS, Tempdb
  • Log Space Audits and Tempdb Audits
  • Memory Usage & Disk Usage Audit DMVs
  • Storage Allocation Issues (Page, Extent)
  • LOCKS - Types, Impact, Monitoring
  • Shared Locks, Exclusive Locks, WAITS
  • Deadlock Graphs with SQL Profiler, XDL
  • DEADLOCKS - Avoidance, Prevention
  • LIVELOCKS - Avoidance, Prevention
  • Isolation Levels For OLTP - TempDB

DAY 25: SECURITY MANAGEMENT

  • Authentication Types - WINDOWS, SQL
  • Windows Logins and REGEIDT Settings
  • SQL Server Logins, POLICIES, EXPIRY
  • LOGINS: Server Level Security, Options
  • USERS: Database Level Security, Options
  • SCHEMAS: Object Level Security, Options
  • System Server Roles, Database Roles
  • GRANT, WITH GRANT, DENY, REVOKE
  • CONTROL, OWNERSHIP, Authorization
  • DMVs for Server and DB Security Audits
  • KEYS, Passwords - Data Level Encryption
  • CERTIFICATES & Data Encryption
  • SQL Server Credentials, Job Security
  • Proxies - Purpose, Usage and Options
  • SSIS Proxies for Job Level Subsytems
  • Password Resets and Disabling Logins
  • Scripting Logins, Users, Roles, Schemas
  • Security Audits, Role Membership
  • Containment Databases and Purpose
  • Contained Database Users and Roles

DAY 26: MAINTENANCE PLANS, REPAIRS

  • Database Maintenance Plans (SSIS)
  • DB Maintenance Strategies & Schedules
  • MSDB History Management Options
  • Backup Files and Space Management
  • Reorganizing Indexes with Maint. Plans
  • Stats Updates (Automatic) and Jobs
  • Modifying SSIS DB Maintenance Plans
  • Scheduling and Maintaining SSIS Plans
  • Log File Issues & Shrinking Operations
  • SQL DB Engine Properties & Guidelines
  • Service Configuration Manager Options
  • PAGE REPAIRS - suspect pages @ MSDB
  • FILE REPAIRS, FILEGROUP REPAIRS
  • DATABASE REPAIRS - DB Consistency
  • DATABASE REPAIRS - Data Allocation
  • DB Modes, Emergency, NOWAIT Options
  • Managed DB Backups @ SQL 2016

DAY 27: DB MIGRATIONS, DMA TOOL

  • Database Migration Options with SSIS
  • DB Design Audits @ File System Store
  • Database Detach Options and Downtime
  • Database Attach Options and Scripting
  • Scripting: Schemas, Object, Keys, Data
  • Scripting Security Logins, Permissions
  • Copy Database Wizard (SSIS) Tool Usage
  • File System, SQL Server Package Store
  • Migration Schedules, Jobs, Alerts, Logs
  • Log Repairs, FORATTACH, REBUILDS
  • Linked Server Security, Management
  • Server Dashboard, Connection Audits
  • Data Migration Assistant (DMA) Tool
  • Using DMA Tool for DB Analysis, Upgrades
  • DMA Tool: DB Assessment, Migration

DAY 28: PATCHES, SERVER UPGRADES

  • Establishing Downtime For Maintenance
  • Precautions for Maintenance Activities
  • Service Packs and Patch/hotfix Activities
  • Instance Selectivity for Updates, Cautions
  • Pre & Post Patch Operations. Process
  • Verifications, SmokeTest and Rollbacks
  • Upgrade Advisor Tool - Analysis Reports
  • Upgrade Advisor Issues and Warnings
  • Server Upgrades and Precautions
  • Planning for Maintenance Activities
  • Rebuilding System Databases & DAC
  • Pre Database Maintenance Activities
  • Post Database Maintenance Activities
  • Real-world Management Considerations

DAY 29: CLUSTERING CONFIGURATION

  • Understanding SQL Clustering Service
  • SQL Server Clustering Architecture
  • Windows and SQL Server Licensing
  • Windows Server Installation Options
  • Service Pack and Patch Installations
  • QUORUM Options for Windows Clusters
  • SQL Server Cluster Plan - Licensing
  • Installing Windows MSCS Service, Tests
  • Ping Tests and Heart-beat Checks, DC
  • Domain Configurations, Precautions
  • MSCS - Microsoft Cluster Services, Nodes
  • MSCS Service Startup Options, Issues
  • Verifying SQL Server Cluster Installation

DAY 30: CLUSTERS: ACTIVE DIRECTORY

  • Need for Centralized Authentication
  • Domain Controller (DC) Configuration
  • Active Directory Settings and Usage
  • DCPROMO Settings for Active Directory
  • Server Configuration Manager, Options
  • Configuration Manager - Users & Groups
  • Working with Active Directory (AD) Edits
  • Network Configurations and Precautions
  • PING Configurations and DTC Options
  • QUORUM settings and SAN Options
  • SQL Server Cluster Installation
  • Cluster Configurations - Active/Active
  • Cluster Configurations - Active/Passive
  • MS DTC Configurations (Local/Remote)

DAY 31,32: SQL CLUSTERS, ALWAYS-ON

  • Install SQL Server Clusters
  • Clustering Nodes : Install, Update
  • Need for Always - On Availability
  • Always-On Prerequisites, Node Config
  • SQL Group & AD Syncup Operations
  • SAN System for Shared Data Storage
  • Smoke Test Procedures in Real-time
  • Fail-Over Disk & RAID Implementation
  • Cluster Connection Issues and Drains
  • Installing Updates - SQL Server Clusters
  • Add Nodes to SQL Cluster - Active/Active
  • SQL Server Cluster Utilities & Quorum
  • Cluster Working and Operative Modes
  • Configuration Settings, SQL Monitors
  • Always-On Availability Groups (AAG)
  • Prerequisites for Always-On for HA/DR
  • Primary & Secondary Configurations
  • Synchronization Settings, HA Options
  • Port Settings, Backup Strategies in AAG
  • IP Configurations & WSFC Settings
  • Node Majority, Disk & File Share Majority
  • Active-Passive Cluster Configurations
  • Network Security Issues with Solutions
  • RAID, Storage Issues with Solutions
  • Availability Replica - Readable Secondary
  • Active Secondary, SYNC, ASYNC (AAG)
  • Replica Recommendations for Always-On
  • Routine DBA Challenges for AAG - HA/DR
  • SLA/OLA Challenges, Tickets in Always-On
  • Temporal Tables - AAG : SQL 2016
  • Stretch Databases @ SQL 2016

DAY 33: PERF. TUNING - LEVEL 5

  • Memory Optimized Tables and Filegroups
  • Memory Snapshot Settings in Real-world
  • Temporal Tables, SYSTEM_VERSIONING
  • Temporal Tables For Audits, Performance
  • In-Memory Tables and Index Options
  • Extended Events & Performance Impact
  • LIVE Query Statistics - Monitoring, Metrics
  • LIVE Query Statistics - Tracing, Baselining
  • Performance Baseline Methodologies
  • Optimize configuration of your databases
  • Use DMVs and DB Performance Metrics
  • Memory Tables Versus Temp Tables/Tables
  • LIVE Execution Statistics, Hash Plans
  • System Versioned Temporal Tables
  • Querying, Modifications to Temporal Tables
  • Tuning For Bulk Inserts - Recovery Models
  • Cached Plans and Memory Store for SPs
  • Performance Tuning - Checklist Activities

DAY 34: PERFORMANCE TUNING - 6

  • PERFMON Counters and MSDTC Service
  • Memory, IO Resources : Performance
  • MEMORY LEAKS and PAGE WAITS
  • LATCH WAITS and Query Performance
  • CPU, Thread Management, Windows Fibres
  • Working with Machine Code @ SQL Server
  • Resource Governor - Resource Pools
  • Resource Workload Groups, Settings
  • LOW, HIGH, MEDIUM Priority Queries
  • Classifier Function, Cost Based Optimize
  • Query Priority, CPU / Memory / IO Limits
  • Windows Fibres and Priority Boost
  • Degree Of Parallelism (DOP) Settings
  • Processor Settings, Counter Thresholds

DAY 35,36: ERRORS, SOLUTIONS

Routine DBA & Emergency DBA Activities ROOT CAUSE ANALYSIS STRATEGIES Common Backup Errors, Solutions Restore Errors and DB Offline Errors Replication Errors and Solutions Log Shipping Errors and Solutions Trace Flags and Usage. DBCC PAGE DB Suspect Errors and Solutions Dynamic Data Masking (DDM) Security Scenarios with DDM Feature 3rd Party Tools (Litespeed) and Usage Ticketting Tools and SLA / OLA Database Support Levels, Escalations Descalations and KB Articles

DAY 37: Azure Integration

Deployments to SQL Azure Azure Database Integration SQL Azure and Cloud Access Administering Databases using Cloud SQL Database Access in HD Insight Azure Security and Backups Azure in VM - LINUX, Windows PowerShell Scripting with Azure HA-DR with Windows Azure DB Access in Azure Market Place Configuration, Deployment Options SSD and Storage Management in Cloud Real-time DBA Activities in Cloud

Above course curriculum applicable for registrations from Oct 15th, 2017

24x7 LIVE Online Server (Lab) with Real-time Databases. 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 24x7 LIVE Server.

 
 

SQL DBA Online Training- Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
  • Detailed SQL Server Architecture, DB Repairs, Migrations
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • SQL Profiler, SQLDIAG, DTA and Litespeed Tools
  • High Availability, Disaster Recovery, Always-On
Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses