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, Temporal Tables, Repairs, Stretch DBs, Always-On in SQL Cluster. Course includes Study Material, 24x7 Online Lab, Certification, Job Support with One Realtime Project. Versions: SQL Server 2012, SQL Server 2014 & 2016.

SQL DBA LIVE Online Training Plans

PLAN A PLAN B
Total Number of Sessions 32 Classes 37+ Classes
Performance Tuning 5 Classes 7 Classes
Placement Assistance Yes Yes
Clustering & Always-On (HA-DR) Yes Yes
Mock Interviews & Resume Yes Yes
MCSA Certification Guidance No Yes
Total Course Duration 6 Weeks 7 Weeks
Total Course Fee INR 15000/-
USD 250
INR 18000/-
USD 300

SQL DBA Training Schedules (LIVE)

Timings (IST) Free Demo Start Date
6:30 AM to 8 AM August 10th August 11th Register
10:00 AM to 11:30 AM July 20th July 21st Register
6:30 PM to 8 PM July 31st Aug 2nd Register

None of the above schedules work for you? opt for On-demand, Self Paced Video Training Course

 

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

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
  • Weekly Mock Interviews, Resume
  • Placement Assistance and Certificates
  • MCSA Certification Pattern - Course Plan
  • Online Lab Access (24x7 LIVE Server)

DAY 2,3: BASIC SQL: DDL and DML

  • Testing Installation, Server Connections
  • SSMS Tool (Client) and Object Explorer
  • Defining Query Sessions - Session IDs
  • Basic SQL with Databases and Tables
  • DDL, DML, DCL and TCL Statements
  • Basic Table Creation - Data Types
  • INSERT / Store Data into SQL Tables
  • Single, Multiple Row Inserts @ NULL
  • SELECT Query Operators: IN, AND, OR
  • IS, UNION ALL, NOT and BETWEEN
  • UPDATE and DELETE Statements
  • DELETE Versus TRUNCATE. DROP
  • SYSTEM DATABASES - Importance
  • MSDB, TempDB, Resource and Model
  • Local Temp Tables. Global Temp Tables
  • Wait Times, Client Statistics @ Queries
  • CLIENT - SERVER Architecture (TDS)
  • SQL Native Client (SNAC) Statistics
  • Implementing TDS @ SQL Queries

DAY 4: DATABASE & TABLE ARCH

  • SQL Server Database Architecture
  • SQL Server Database Design Concepts
  • Database Properties, Storage Options
  • 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
  • Data Types and Aliases with Schemas

DAY 5: 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
  • Composite Primary Keys and Usage
  • Constraints with Naming Conventions
  • DB Design with Constraints, Schemas
  • Constraint Priority and DB Properties

DAY 6: 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
  • Table Join across Schemas, Filegroups
  • Basic Aggregations with Joins. Aliasing
  • Comparing Inner Join and Outer Joins
  • Comparing Inner Join and Cross Joins
  • Deciding the best Join Type, Options
  • Sub Queries and Joins. Alternate Syntax
  • End User Access to Queries - Interfaces
  • Sub Queries and Simple Aggregations
  • Sub Queries with UNION, UNION ALL

DAYS 7, 8: VIEWS, FUNCTIONS, SUB QUERIES

  • 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
  • Queries - GROUP BY, HAVING Conditions
  • Queries with GROUPING() and HAVING
  • ROLLUP Options & Column Aggregations
  • CUBE on Table Data - Purpose & Usage
  • HAVING Vs WHERE - Performance
  • Query Execution Order @ ROLLUP, CUBE
  • Functions: Types, Purpose and Usage
  • Scalar Value Returning Functions - Usage
  • Inline Table Value Returning Functions
  • Multi-line Table Value Returning Functions
  • RETURNS and RETURN Values. Options
  • BEGIN..END and IIF Functions, CASE
  • Function Arguments - Usage and Options
  • Variables and Function Parameters
  • Static Variables and Dynamic variables
  • Table Variables, WHILE LOOP Concepts
  • System Functions and Metadata Access
  • Date & Time Formats, Styles, DATEDIFF
  • CAST, CONVERT, RANK, RowNumber
  • Views for Sub Queries and Functions
  • Views for Aggregations and Calculations

DAY 9: 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
  • Need for Recompilations, Outdated Plans
  • Dynamic SQL Parameters and Variables
  • Default Parameter Values, Usage Types
  • OUTPUT Parameters and Query Options
  • RECOMPILE & ENCRYPTION Option

DAY 10: STORED PROCEDURES - Level 2

  • Stored Procedures for Dynamic Queries
  • Recursive Queries: OUTPUT Parameters
  • Common Table Expressions, In-Memory
  • Stored Procedures for CTE (Sub) Queries
  • Using CTE for Table Data Operations
  • CTE for DML & DDL in Stored Procedures
  • 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

DAY 11: TRIGGERS & TRANSACTIONS

  • Use of Triggers - Use and Performance
  • FOR / AFTER Triggers - Importance
  • INSTEAD OF Triggers - Importance
  • INSERTED and DELETED Memory Tables
  • Triggers for DML Audits, Data Sampling
  • Database Level & Server Level Triggers
  • Bulk Operations & Updatable Views
  • ACID Properties and Transaction Types
  • EXPLICIT Transaction Types, Advantages
  • IMPLICIT Transactions Types, Advantages
  • Open Transactions - Query Blocking
  • AUTOCOMMIT Transactions - Advantages
  • Nesting Transactions and Save Points
  • Transactions with SET Options, Cautions
  • Isolation Levels and Purpose.
  • READ COMMITTED, READ UNCOMITTED
  • SNAPSHOT, SERIALIZABLE Isolations
  • READ COMMITTED SNAPSHOT Isolation
  • LOCK HINTS: READPAST, NOLOCK, etc..

DAY 12: SQL SERVER ARCHITECTURE

  • Architecture: Query Processor, Threads
  • Architecture: Storage Engine, File System
  • Architecture: Parser, Optimizer, Mini LSN
  • Architecture: SQL Engine, MDAC, Buffers
  • Architecture: SQLOS Schedules, CLR
  • Write Ahead Log,Lazy Writer,Checkpoints
  • Query Optimizer (QO) & Execution Plans
  • SQL DB Architecture: Files and Filegroups
  • Virtual Log Files & Mini LSN & DOP
  • Query Processing and Optimizer (QO)
  • Client - Server Architecture of SQL Server
  • TCP / IP, Named Pipes, Shared Memory
  • SQL Native Client, OLE DB Drivers
  • SQL Database Architecture - RAID Levels
  • Log Sequence Numbers (LSN), Mapping
  • 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, CLR
  • SQL Server with External Protocols

DAY 13: 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
  • Indexes with Merge and Loop Joins
  • Bitmap Index and Execution Plans
  • Primary Key Index, Composite 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 14: DATABASE 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
  • Tuning Database Backup Operations
  • Mirrored Backups, FORMAT, SKIP, STATS
  • Tape Backups - LOAD, UNLOAD, ERRORS
  • COMPRESSION, CHECKSUM, VERIFY
  • ContinueOnError, Backup Validation
  • Backup History From MSDB Database
  • Backup Audits - Media Set, Media Family
  • Remote Backups and Security Options
  • Compatibility, Recovery Model Options
  • COPY_ONLY Backups and Importance
  • Important Queries for Backup Audits
  • Backup Verification, Security KEYS
  • Backups using GUI and T-SQL Scripts
  • Backup Devices - Purpose, Options
  • Real-time Errors, Solutions @ Day 37

DAY 15: RESTORES AND DB RECOVERY

  • Data Recovery using Backups, Log Files
  • Restore Phases - COPY, REDO, UNDO
  • Database Restores & FILELIST Options
  • File Restores and Filegroup Restores
  • FILELISTONLY, VERIFYONLY, REPLACE
  • PARTIAL & PIECEMEAL Restores - Tuning
  • Tail Log Backups & DB Recovery Options
  • REDO Phase with 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 From existing Databases, Files
  • Restores using SQL Server T-SQL Script
  • Restores using GUI. Data & Log Options
  • Transaction Undo Files (TUF) Purpose
  • Restore Audits and Standby Databases
  • Checkpoint LSN and Restore Positions
  • Real-time Errors, Solutions @ DAY 37

DAY 16: 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 Frequency Options
  • Job Schedules and Email Notifications
  • Job Executions, Disable/Enable Options
  • Job History and Job Activity Monitor
  • Import & Export (SSIS) Operations
  • OLE-DB, SQLNCLI and MS Jet Drivers
  • 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 and Recovery Modes - Usage
  • Backup Limitations with Recoery Modes
  • Startup Jobs, Onetime, Recurring Jobs
  • Job Activity Monitor and Agent Threads

DAY 17: PERFORMANCE TUNING - 1

  • Identifying Long Running Queries
  • Dynamic Management Objects: DMV, DMF
  • Audit Long Running Queries - DMV/DMF
  • Audit Frequent Running Queries - DMF
  • Query Audits and DMVs / DMFs with Joins
  • 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 Limitations
  • Anchor, Recursive Members, Termination
  • HASH JOIN Examples and Precautions
  • MERGE JOIN Examples and Precautions
  • LOOP JOIN Examples and Precautions
  • OUTER APPLY and Multi - Level Joins

DAY 18: 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 - Usage Advantages
  • Index Statistics - Auto Index Creations
  • Manual Update of Column Statistics
  • Statistics in Query Tuning Process
  • STATISTICS in Indexes, Query Conditions
  • LIVE Query Statistics, Table Statistics

DAY 19: PERFORMANCE TUNING - 3

  • LIKE Operator - Using Wild-cards
  • Full Text Search Service Configuration
  • Full Text Search - Database Settings
  • Database Catalogs (FTC) and Storage
  • Full Text (FT) Indexes for Query Tuning
  • Full Text Columns and Primary Key Index
  • Full Text Index - Search Query Issues
  • 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 2016

DAY 20: PERF. TUNING - LEVEL 4

  • Index Internals and Execution Plans
  • Execution Plans, Statistics, Query Cost
  • Index Fragmentation Issues, Performance
  • SAMPLED and 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, Metadata Info
  • Filtered Indexes and Size Limitations
  • Table Statistics, Query Tuning Options
  • 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
  • DTA Tool for Multi-Database Connections
  • Understanding PDS Options with Indexes
  • MORE TUNING CONCEPTS: DAYS 35, 36

DAY 21: 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
  • Read Only Subscribers & Load Balancing
  • Replication Jobs and Verification Options
  • Adding Articles to Existing (LIVE) Replica
  • Adding Subscribers to Existing Replica
  • Stopping, Starting Replication Agents
  • Scripting Replication Jobs, Publications
  • Disable/Enable Replication, Agent Stops
  • Real-time Errors, Solutions @ DAY 37

DAY 22: 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 across Lower/Higher Versions
  • 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
  • Transactional Versus Snapshot Replication
  • 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 37

DAY 23: LOG SHIPPING - DISASTER RECOVERY

  • 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
  • Copy and Restore Jobs with Secondary
  • Log Shipping Monitor Status Reports
  • Manual Failover Process and Recovery
  • Versioning Issues, Data Traffic. Data Loss
  • Log Shipping Jobs - Errors and Solutions
  • Log Shipping Reports and Data Recovery
  • Log Shipping Standby: Delay Restores
  • Scripting Log Shipping Configurations
  • Standby Disconnections, Latency Options
  • Real-time Errors, Solutions @ DAY 37

DAY 24: DATABASE MIRRORING: HA / DR

  • DB Mirroring Architecture For HA,DR
  • DB Mirroring Configuration Scenarios
  • TCP Endpoints and TCP Network Security
  • Heartbeat and Polling Concepts in DM
  • Service Accounts Configurations, Use
  • Automatic Fail-Over Procedures, Tests
  • Manual Failover Options and Scenarios
  • PARTNER OFFLINE Conditions & Options
  • DB Mirroring Monitors and Commit Loads
  • SYNCHRONOUS & ASYNCHRONOUS
  • Manual Failover and HA Partner Roles
  • Mirroring Monitor, Stop/Resume Options
  • DR & HA with DB Mirroring Advantages
  • Need for Always-On & Higher Availability
  • SET PARTNER Options and Db Recovery
  • DB Recovery without Witness. Failover
  • DB Mirroring Errors, Solutions @ DAY 37

DAY 25: DB HEALTH CHECKS, AUDITS

  • Query Resources - CPU, IO and Memory
  • Activity Monitor (AM) Tool - CPU, Memory
  • Database File IO, Processes, Query Stats
  • SQL Profiler Tool Usage, Audit Trace Files
  • SQL Profiler Templates: Standard, Tuning
  • Event Extraction Settings, Filter Columns
  • DB ID Filters, CPU Filters, SSID Filters
  • Profile Trace File Rollover, Size Settings
  • Database Health Check: DBCC Commands
  • Allocation Errors and Consistency Errors
  • ESTIMATEONLY, NO_INFOMSGS, Tempdb
  • Log Space Audits and Tempdb Audits
  • Dynamic Management Views (DMVs)
  • Important Dynamic Management Functions
  • 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 Tool
  • DEADLOCKS - Avoidance, Prevention
  • LIVELOCKS - Avoidance, Prevention
  • Deadlock Graphs @ SQL PROFILER, XDL
  • Isolation Levels For OLTP - TempDB

DAY 26, 27: 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
  • Testing Security Operations, Scripting
  • Common Security Functions & Queries
  • DMVs for Server and DB Security Audits
  • KEYS, Passwords - Data Level Encryption
  • CERTIFICATES & TRIPLE-DES Algorithm
  • Master Passwords and 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 28: 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 29: 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
  • Corrupted Logs, 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 30: 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 31: 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 32: 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 33: CLUSTERS NODES, 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

Applicable for PLAN B Registrations:

DAY 34: SQL CLUSTERS, ALWAYS-ON

  • 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 35: 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 36: PERF. TUNING - LEVEL 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 37: COMMON ERRORS, SOLUTIONS

  • 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 38, 39: Real-time Project for SQL DBA

  • Always-On with HR, DR, PSSDIAG
  • 3rd Party Tools, SLA/OLA
  • Server Aliases, Configuration Manager, Ports
  • Database Migration to SQL Azure
  • SQL DBA Checklist - 1 : Errors, Solutions
  • SQL DBA Checklist - 2 : Errors, Solutions

Above course curriculum applicable for registrations from July 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