SQL DBA Online Training Institute
 
 

SQL DBA Online Training (LIVE, Instructor-Led)

Real-time Practical SQL DBA LIVE Online Training designed to work with all major SQL Database Administration activities including DB Design, Normalized Views, Stored Procedures, Indexes, Joins, DB Maintenance, Query Tuning, HA/DR, AAG and SQL Cluster Issues. Study Material, 24x7 Online Lab, Certification, Job Support with One Realtime Project included in the course. Versions: SQL Server 2012, SQL Server 2014 & 2016.


Schedules for SQL Server DBA LIVE Online Training (Instructor Led)

Timings (IST) Free Demo Start Date Register
   
6:30 AM to 8 AM Jan 18th Jan 18th Register
11 AM to 12:30 PM Jan 26th Jan 30th Register
7 PM to 8:30 PM Feb 9th Feb 13th Register

 

If none of the above LIVE Online Training schedules work for you? click here
If you are currently working on T-SQL / SQL Server and looking for DBA click here
Trainer Profile, Duration, Pricing

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

Duration: 7 Weeks (Mon - Sat)

Total Course Fee: INR 18000 / USD 300 (Installment Pay)

Payments by PayPal

 

Module I: SQL Server & T-SQL Queries

Duration: 13 Sessions
Module II: Basic SQL DBA

Duration: 2.5 Weeks
Module III: Advanced SQL DBA

Duration: 2.5 Weeks

DAY 0: SQL Server (2016, 2014) Installation

  • What is Database? Need for DB Admins
  • SQL Server Advantages,Editions,Versions
  • Roles, Responsibilities, Levels - SQL DBA
  • How to install SQL Server - Step by Step
  • SQL Server 2016,2014,2012 Installation
  • Common Installation Errors, Solutions
  • Windows Updates, XML Errors, REGEDIT
  • SQL Server Management Studio (SSMS)
  • Online Lab Access (24x7 LIVE Server)
  • DAY to DAY Course Plan - Time Table
  • Mini Project @ Course: L1 DBA Activities
  • Real-time Project: L2, L3 DBA   Register

DAY 1: SQL SERVER ARCHITECTURE

  • SSMS Client - SQL Server Architecture
  • SQL Server Eng. Architecture (Detailed)
  • ISO-OSI Model of Encrypted DB Data
  • Query Processing & Query Optimizer(QO)
  • SQL Server Architecture - Protocols
  • Architecture - Query Processor Engine
  • Storage Engine Modes, Data Allocations
  • Parser, Query Optimizer (QO), B Trees
  • SQL Query Engine, SQL Manager, Buffers
  • Write Ahead Log (WAL), Lazy Writer
  • SQLOS Threads and Schedules, CLR
  • Network - MDAC, MSXML Components
  • DOP - Degree Of Parallelism, CPU Nodes
  • Windows Components for DBA Register

DAY 2: BASIC DDL, DML, DCL, TCL, STATS

  • DDL, DML, DCL, TCL Queries. Types
  • Basic Databases, Tables, SQL Concepts
  • Creating Databases (Basic Level) & Tables
  • Data Store, Data INSERT Variants, Rules
  • Data Retreival Query Plans - Table Scan
  • Table UPDATEs, Structure Updates, Plans
  • DELETE Versus TRUNCATE. DROP Options
  • SYSTEM DATABASES & MSDB, TempDB
  • Client Statistics for T-SQL Queries
  • Implementing TDS @ SQL Server Queries
  • Query Execution Stats with TDS Packets
  • Client and Server Processing Time - Stats
  • Query Waits and Performance Factors
  • Register

DAY 3: SQL SERVER DATABASE DESIGN

  • SQL Server Database Architecture
  • SQL Server Database Design Concepts
  • Database Properties, Storage Options
  • Data Files : Sizing, Usage Options
  • Filegroups : Placement, Usage & Options
  • Log files : Sizing, Placement, Growth
  • Database Creation - GUI & T-SQL Scripts
  • Filegrowth, Autogrowth and MAXSIZE
  • Planning, Designing Very Large Databases
  • Database Structure Modifications, ALTER
  • Adding New Filegroups, Files to Database
  • Capacity Planning, Dedicated Log Storage
  • Data File Architecture - Pages, Extents
  • Log File Architecture - VLF, Mini LSN

DAY 4: TABLE DESIGN & SIMPLE QUERIES

  • Table Design - Defining & Creating Tables
  • Routing Tables to Database File Groups
  • Schemas - Purpose, Creation and Usage
  • Table Design using T-SQL Scripts
  • Table Design using GUI - Options
  • Naming Conventions for Table Columns
  • Single Row Inserts & Multi-Row Inserts
  • Table Aliases, Column Aliases and Usage
  • DDL, INSERT, UPDATE, DELETE, SELECT
  • SELECT Queries with Schema References
  • T-SQL Data Types, NULL Comparisons
  • Database Log Files for DML Operations
  • Design Limitations and UPDATES
  • Data Allocation - Pages, Extents, RID

DAY 5: CONSTRAINTS and KEYS

  • Constraints and Keys - Purpose & Usage
  • Normal Forms, Relational DB Design
  • OLTP Database Relations and BCNF
  • NULLABILITY Property and Importance
  • UNIQUE KEY Constraints and Importance
  • PRIMARY KEY Constraints and Limitations
  • FOREIGN KEY References and Relations
  • FOREIGN KEY Constraints - Rules, Usage
  • Schema Level and Table Level Relations
  • CHECK Constraints - Usage & Limitations
  • DEFAULT Column Constraints and Usage
  • Identity Property with PRIMARY KEY
  • Composite Primary Keys and Options
  • Constraints with Naming & Conventions

DAY 6: JOINS & TUNING OPTIONS

  • Need for Joins and Use Case Scenarios
  • JOIN - Types, Queries and Usage
  • CROSS JOIN - Examples and Scenarios
  • INNER JOIN - Examples and Scenarios
  • OUTER JOINS - Types and Scenarios
  • SELF JOINS - Types and Scenarios
  • Query Tuning & Optimization Options
  • HASH JOIN - Example, Scenarios
  • MERGE JOIN - Example, Scenarios
  • LOOP JOIN - Example, Scenarios
  • Sub Queries and Joins. Alternate Syntax
  • End User Access to Queries - Interfaces
  • Use Case - Combining JOIN Types - An Online Medical System

DAY 7: VIEWS and SUB QUERIES

  • Defining Views on Tables and Views
  • Views as Stored SELECT Statements
  • SCHEMABINDING & ENCRYPTION Options
  • Issues with Views For Data Validations
  • Cascaded Views, WITH CHECK OPTION
  • Orphan Views - Scenarios in Realworld
  • Common System Views, Metadata Access
  • Views on Multi Level Tables - Joins
  • Queries - GROUP BY, HAVING Conditions
  • Queries with GROUPING(), HAVING
  • ROLLUP Options & Column Aggregations
  • CUBE on Table Data - Purpose & Usage
  • HAVING Vs WHERE - Differences
  • Query Execution Order with ROLLUP

DAY 8: FUNCTIONS & SUB QUERIES

  • Functions: Types, Purpose and Usage
  • Scalar Value Returning Functions - Usage
  • Inline Table Value Returning Functions
  • Multi-line Table Value Returning Functions
  • Table Variables and Usage with Functions
  • Function Arguments - Usage and Options
  • SCHEMABINDING & ENCRYPTION Options
  • System Functions and Metadata Access
  • Date & Time Formats, Styles, DATEDIFF
  • SOUNDEX, DIFFERENCE, CASE, ISNULL
  • CAST, CONVERT, TRY_PARSE, COALESCE
  • String Functions, ROW_NUMBER, RANK
  • CASE, MERGE, PIVOT, DENSE_RANK
  • Views for Sub Queries & Functions
  • Real-time Case Study on Joins, Functions, Sub Queries

DAY 9: STORED PROCEDURES - BASICS

  • 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 Conditions
  • Error Handling: TRY, CATCH, THROW
  • Dynamic SQL Parameters and Variables
  • Default Parameter Values, Usage Types
  • OUTPUT Parameters and Query Options
  • RECOMPILE Option & ENCRYPTION Option

DAY 10: STORED PROCs @ CURSORS, CTE

  • Cursor Types - Benefits and Options
  • FORWARD_ONLY & SCROLL Cursors
  • STATIC and DYNAMIC Cursors - Memory
  • LOCAL and GLOBAL Cursor Types
  • KEYSET DRIVEN Cursors, Performance
  • SPs with Joins, Temp Tables & Cursors
  • Nested Sub Queries with Stored Procs
  • Common Table Expressions (CTE) & Uses
  • Using CTE, Data Retrieval in Stored Procs
  • CTEs and Query Tuning Options with SPs
  • CTEs with Tuning Options inside SPs

DAY 11: TRIGGERS & LINKED SERVERS

  • 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
  • Triggers for Table Data Distribution
  • Disabling Triggers and Setting Priority
  • Linked Server - Purpose & Connections
  • Linked Server Queries and Triggers
  • A Real-world UseCase For Triggers

DAY 12: TRANSACTIONS & ISOLATION LEVELS

  • ACID Properties and Transaction Types
  • EXPLICIT Transaction Types, Advantages
  • IMPLICIT Transactions Types, Advantages
  • Open Transactions - Query Blocking
  • AUTOCOMMIT Transactions - Advantages
  • Nesting Transactions & SavePoints
  • LOCK HINTS: READPAST, NOLOCK, etc..
  • Isolation Levels - Types and Usage
  • READ COMMITTED Isolation and Blocking
  • READ UNCOMMITED and Dirty Reads
  • SERIALIZABLE and REAPEATABLE
  • SNAPSHOT & READCOMITTED SNAPSHOT
  • Choosing Isolation Levels For OLTP

DAY 13: INDEXES & QUERY TUNING

  • Indexes Types, Purpose, Plans
  • Clustered Indexes - Architecture
  • NonClustered Indexes - Architecture
  • Execution Plans & Query Optimization
  • Table Scan, Index Scan, Index Seek
  • SORT_IN_TEMPDB and Index Memory
  • FILLFACTOR, PAD_INDEX, Fragmentation
  • INCLUDED Indexes and Performance
  • COLUMN STORE Indexes - Advantages
  • FILTERED Indexes - Advantages
  • ONLINE Indexes and OFFLINE Indexes
  • Indexes with JOIN Options in SELECT
  • Indexes with Merge and Loop Joins
  • Primary Key Index, Composite Indexes
  • STATISTICS - Types and Tuning Options
  • STATISTICS with Index Query Conditions
  • Materialized Views (Indexed Views)
  • Unique Clustered, NonClustered Indexes
  • Index Limitations and Precautions
  • Clustered Versus NonClustered Indexes
Register today for Free Demo

DAY 14: BACKUPS - DB, FILEGROUP, FILE

  • Backups Concept and Usage
  • Backups - Types, Syntax and Options
  • Data Backup Options and Levels
  • File Backups and Filegroup Backups
  • Log Backup Mechanism and Truncates
  • Partial Backups with Filegroups
  • Tuning Database Backup Operations
  • Backup Mirrors and FORMAT, SKIP
  • Tape Backups with LOAD, UNLOAD
  • COMPRESSION, CHECKSUM and STATS
  • CHECKSUM and CONTINUE_ON_ERROR
  • 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

DAY 15. RESTORES & DATABASE 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 and PIECEMEAL Restores
  • Tail Log Backups & Database States
  • Re-Restoring (REDO) T-Log Backups
  • Compressed Tail Log Restores, Undo
  • Partial Backups and STATS Options
  • Choosing Right Backups for Restores
  • SQL Server 2012 to 2014,2016 Restores
  • Choosing Correct DB Recovery Models
  • Point-In-Time Restores and 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

DAY 16: JOBS, SQL SERVER AGENT, DB MAIL

  • SQL Server Agent Service, Agent XPs
  • Creating Jobs with GUI Options
  • Job Steps - T-SQL Type, SSIS Type
  • Job Schedules and Frequency Options
  • Job Schedules and Email Notifications
  • Job Executions, Disable/Enable Options
  • Job History and Job Activity Monitor
  • Windows Event Notifications, Operators
  • DB Mail Configurations, Database Profiles
  • SMTP Accounts, Email Settings, Ports
  • Default Public Profiles, DB Mail Security
  • SSIS Packages for Data Import/Export
  • SSIS Package Store - File System, MSDB
  • SSIS Jobs - Scheduling SSIS Packages
  • Backup Strategies For Minimal Data Loss
  • Startup Jobs, Onetime, Recurring Jobs

DAY 17,18: REPLICATION For HA & DR

  • Replication Architecture & Entities
  • Articles, Publications, Subscriptions
  • Distribution Components and Options
  • Distributor DB and Snapshot Folders
  • Distribution Configurations, Options
  • Articles, Filters & Publication Options
  • Article Dependencies & Encryptions
  • Snapshot Replication and Repl Agents
  • Configure, Secure, Schedule Snapshots
  • Transactional Replication & Tokens
  • Merge Replication and Merge Agent Job
  • Replication Conflicts and ROWGUIDCOL
  • Peer-Peer Replication - Configurations
  • Working of Peer-Peer Replication
  • Adding Peer Nodes, Node ID Conflicts
  • Replication Conflicts - Options, SPs
  • IDENTITY Property & Schema Replication
  • PUSH and PULL Subscriptions - Options
  • Replication Monitor - Usage & Options
  • Replication Jobs and Verifications
  • Domain Account Security in Replication
  • Merge & Snapshot Replication Limitations
  • Replica Initialization with DB Backups
  • Replication Conflicts, Errors and Solutions
  • Replication Errors, Events and Solutions
  • Replication Errors @ DB Engine, Solutions
  • Replication for HA and DR - Strategies
  • Replication Limitations and Precautions

DAY 19. LOG SHIPPING - DISASTER RECOVERY

  • Log Shipping Architecture, LS Jobs
  • Choosing Primary, Standby Servers
  • Log Shipping Monitor Configuration
  • NORECOVERY Configuration and Usage
  • STANDBY Mode Configuration & Usage
  • Log Shipping Jobs and Schedules
  • Backup Jobs - Errrors, Solutions
  • Copy & Restore Jobs with Secondary
  • Log Shipping Monitor Status Reports
  • Manual Failover Process - Options
  • Log Shipping Topology - Limitations
  • Versioning Issues and Data Traffic
  • Log Shipping for DR Procedures
  • Log Shipping Reports, Data Recovery

DAY 20: DATABASE MIRRORING - HA & DR

  • DB Mirroring Architecture For HA,DR
  • Mirroring Configuration Scenarios
  • Backups & Restores for Mirrors
  • TCP Endpoints & Network Security
  • Heartbeat and Polling Concepts in DM
  • Service Accounts Configurations, Use
  • Automatic Fail-Over Procedures, Tests
  • Manual Failover Options & Scenarios
  • PARTNER OFFLINE Conditions & Options
  • DB Mirroring Monitors and Commit Loads
  • SYNCHRONOUS, ASYNCHRONOUS Modes
  • DB Mirroring for Faster Txn Commits
  • DB Mirroring for High Availability (Data)
  • Manual Failover and Partner Roles
  • Mirroring Monitor and Scripting Options
  • Stop/Resume, Remove Mirroring Options
  • Real-World Considerations & DR Options
  • DR & HA with DB Mirroring Advantages
  • Need for Always-On & Higher Availability
  • DB Mirroring Errors and Solutions

DAY 21. SECURITY MANAGEMENT - LEVEL 1

  • Authentication Types - WINDOWS, SQL
  • SQL Server Security Authentication
  • LOGINS - Server Level Security, Options
  • USERS - Database Level Security, Options
  • SCHEMAS - Object Level Security, Options
  • Server Roles, Database Roles (Predefined)
  • Schemas and User Mappings - Usage
  • Server Level Roles and Usage
  • Database Level Roles and Usage
  • Testing Security Operations in SQL
  • Login Errors and Password Resets
  • GRANT, DENY & REVOKE Permissions
  • Common Security Functions & Queries
  • Object Level Security and Levels
  • Database Level Roles and Usage
  • Schema Level Ownership - Benefits
  • Database Certificates and Master Keys
  • Data Level Security and Encryptions
  • Testing Database Encryption Levels
  • Basic Job Level Security & Options
  • SQL Server Credentials & Scripting
  • Proxies - Purpose, Usage and Options
  • Using Server Credentials for Proxies
  • Using Proxies for Job Level Subsytems
  • DMVs for Server and DB Security Audits
  • Useful Security Audit Queries (DMVs)

DAY 22. SECURITY MANAGEMENT - LEVEL 2

  • SQL Server Security Authentication
  • Server Level Security and Logins
  • Database Level Security Users
  • Schemas and User Mappings - Usage
  • Server Level Roles and Usage
  • Database Level Roles and Usage
  • Testing Security Operations in SQL
  • Login Errors and Password Resets
  • GRANT, DENY & REVOKE Permissions
  • Common Security Functions & Queries
  • Object Level Security and Levels
  • Database Level Roles and Usage
  • Schema Level Ownership - Benefits
  • Database Certificates and Master Keys
  • Data Level Security and Encryptions
  • Testing Database Encryption Levels
  • Basic Job Level Security & Options
  • SQL Server Credentials & Scripting
  • Proxies - Purpose, Usage and Options
  • Using Server Credentials for Proxies
  • Using Proxies for Job Level Subsytems
  • DMVs for Server and DB Security Audits
  • Useful Security Audit Queries (DMVs)

21. Audits For Database, Server & Queries

  • Query Resources - CPU, IO and Memory
  • Audits - Activity Monitor Usage
  • Audits - SQL Profiler Tool Usage
  • Database Health Check & DBCC
  • Log Space Usage Audits - DMVs/DMFs
  • Tempdb Usage Audits with DMVs/DMFs
  • Memory Usage and Disk Usage Audits
  • Considerations Using SQL Profiler
  • Deadlock Graphs with SQL Profiler
  • Audit Long Running Queries - DMV/DMF
  • Audit Frequent Queries - DMV/DMF
  • Query Audits and DMVs / DMFs, Joins
  • Audits for Storage Allocation Issues

22. Data Imports, Exports (SSIS) and DB Mail

  • Import & Export (SSIS) Operations
  • OLE-DB, SQLNCLI and MS Jet Drivers
  • Scheduling SSIS Packages with Jobs
  • SSIS Proxies and Reading Job History
  • Database Scripting & Encryptions
  • Database Cloning Process and Options
  • Configuring Linked Servers - Custom
  • SQL Server Agent - Alert Properties
  • Database (DB) Mail Configurations
  • Securing DB Profiles : SMTP Accounts
  • Creating Operators and SQL Emails
  • Warnings & Emails with Database Mail
  • Testing Job Failures and Notifications
  • Detach - Attach Procedures (Non-SSIS)
  • DB Scripting and Object Encryptions
  • Linked Servers & Security Options

23. SQL DBA Checklist, SLA Process

  • Online Book Sales Project - Project Arch
  • DBA Checklist - Rotuine DBA Activities
  • DBA Checklist - Maintenance Activities
  • DBA Checklist - Emergency Activities
  • Understanding SLA & OLA Process
  • Knowledge Base (KB) Articles & RCA
  • Ticketting Tools (REMEDY) & Usage
  • Server Configurations & Licensing
  • SQL Server Architecture - Detailed
  • SQL Agent Architecture - Thread Level
  • Downtime & Maintenance Notifications
  • Using SQL Browser Service for TCP/IP
  • Resource Governor & Performance
  • Workload Groups and Tuning Policies
  • New Features of SQL Server 2016
  • Configuration Options in SQL 2016
  • Stretch Databases, Managed Backups

24. Performance Tuning - Partitions & Indexes

  • Big Data - Performance Considerations
  • Table Partitions and Tuning Options
  • Partition Functions and Usage
  • Partition Schemes and Reusability
  • Deciding Partition Ranges & Functions
  • Partitioned Data For Complex Queries
  • Partitioning Un-partitioned Structures
  • Aligned Partitions and Performance
  • Fill Factor Options and Index Tuning
  • Partitions for Query Tuning Operations
  • Statistics with Table & Index Partitions
  • Data Compression with Partitions
  • Page Compression & Row Compression
  • Partitions & Compressions, Performance
  • Managing Partitions and Tuning Options
  • New Tuning Options in SQL 2016

25. Performance Tuning - Full Text Indexes

  • LIKE Operator - Limitations & Wild-cards
  • Full Text Search (FTS) Configurations
  • Full Text Search Service and Options
  • Database Catalogs (FTC) and Storage
  • Full Text Indexes (FTI) for Tuning
  • Full Text Columns and Primary Index
  • Full Text Index and Searching Queries
  • CONTAINS() and FREETEXT() Functions
  • Manual Data Populations, Index Loads
  • CHANGE_TRACKING Options, Limitations
  • Securing FT Catalogs and FT Indexes
  • Performance Advantages @ FT Indexes
  • Implementing FTS @ Partitioned Tables

26. Query Tuning - Index Management & DTA

  • Index Internals and Execution Plans
  • Index Fragmentation - Issues, Solutions
  • SAMPLED & DETAILED Query Scans
  • Database Tuning Advisor (DTA) - Usage
  • PDS Options with Indexes For Tuning
  • Choosing Correct Option (PDS) for Tuning
  • Filtered Indexes and Sizing Options
  • Analyzing Work Load Tables and Scans
  • Statistics Updates & Query Tuning
  • Index Management Options & Statistics
  • Statistics - AUTO CREATE, AUTO UPDATE
  • Stats Updates (Manual) and Issues
  • Index Rebuilds & Tuning Options
  • Table Rebuild Options with Indexes
  • Index Reorganization Process and Uses
  • Page, Row Compressions with Indexes
  • FILLFACTOR, PADINDEX Index Options
  • Filtered Indexes, Online Indexes, Views
  • Understanding Workload Files in Profiler
  • SQL Profiler Workload Tables & Queries
  • SQL Profiler Tuning and Lock Templates
  • Index Selectivity Options and Statistics

27. Management - Database Maintenance Plans

  • 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
  • Distributed Transactions & Connections
  • Query Governor Usage and DOP Options
  • Policy Based Management (PBM), Facets
  • Database Properties and Conditions
  • Scheduling Policies, Event Management
  • Considerations for Policy Management

28. Alerts and Troubleshooting + DAC

  • LOG File Space Issues and Solutions
  • TEMPDB Space Issues with Solutions
  • MEMORY Management Issues, Solutions
  • OS Level Memory Clerks and Montoring
  • Memory Leaks, Hits and Solutions
  • Logical & Physical Memory Architecture
  • Memory Buckets, IO Entires
  • Procedure Cache Issues and Solutions
  • Procedure Cache Size & SQL Buffer Size
  • DB State Events, Issues and Solutions
  • Network Usage Audit and Optimization
  • Performance Monitor (PERFMON)
  • Replication Threshold Values & Agents
  • Database Options and Downtime
  • Database States Alerts and DB Events
  • DBCC Commands and Database Repairs
  • Rebuild Operations and Considerations
  • Important DMVs and DMFs for Audits
  • Server Down Issues & DAC Connections
  • Orphan Users & Contained Databases

29. DB Migrations, Service Packs, Upgrades

  • Establishing Downtime For Maintenance
  • Precautions for Maintenance Activites
  • Detach - Attach (SSIS) - DB Migrations
  • Copy Database Wizard - DB Migrations
  • SMO Connections and Offline Options
  • Service Packs and Patch/hotfix Activites
  • Verifications, SmokeTest and Rollbacks
  • Upgrade Advisor Tool - Analysis Reports
  • Server Upgrades and Precautions
  • Planning for Maintenance Activites
  • Rebuilding System Databases, Objects
  • Pre-Database Maintenance Activities
  • System Database Rebuilds & SQLCMD
  • Contained Databases & Orphan Users
  • DAC - Dedicated Administration Console
  • Data Migration Assistant @ SQL 2016

30. Introduction to SQL Server Clusters

  • Understanding SQL Clustering Need
  • SQL Server Clustering Architecture
  • Understanding Ping Tests & Heartbeat
  • Windows and SQL Server Licensing
  • Windows Server Installation Options
  • SP Installation and Quorum Options
  • Installing Windows MSCS Service
  • Testing MSCS Services and AD Options
  • Verifying SQL Cluster Installation

31. Active Directory and MSDTC

  • Need for Centralized Authentication
  • Domain Controller (DC) Configuration
  • Active Directory Settings and Usage
  • DCPROMO Settings for Active Directory
  • Working with Active Directory (AD) Edits
  • Network Configurations and Usage
  • PING Configurations and DTC Options
  • QUORUM settings and SAN Options

32. SQL Cluster Configuration

  • SQL Server Cluster Installation
  • Verifying Cluster Configurations
  • Add Nodes to SQL Server Cluster
  • SQL Group & AD Syncup Operations
  • SAN System for Shared Data Storage
  • MS DTC Configurations (Local/Remote)
  • Smoke Test Procedures in Real-time
  • Fail-Over Disk & RAID Implementation

33. Cluster Issues & Management

  • Cluster Connection Issues and Drains
  • Network Security Issues with Solutions
  • RAID, Storage Issues with Solutions
  • Installing Updates in SQL Clusters
  • QUORUM Checks, Storage Issues
  • SQL Server Cluster Utilities & Usage
  • Cluster Working and Operative Modes
  • Configuration Settings - Monitors

34. Always-On Availability Groups (AAG)

  • Always-On Availability Groups (AAG)
  • Prerequisites for Always-On for HA/DR
  • IP Configurations & WSFC Settings
  • Primary & Secondary Configurations
  • Syncronization Options Settings, Options
  • Backup Storage and Types - Strategies
  • Port Settings and Replica Config in AAG
  • Active-Passive Cluster Configurations
  • SQL Server 2016 - Whats new @ AAG
  • Routine DBA Challenges for AAG
  • Temporal Tables with AAG : SQL 2016
*Above course curriculum applicable for registrations from Jan 6th, 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.

 

Trainer : Mr. Sai Phanindra T, 11+ Yrs of Experience exclusively on SQL Server, SQL DBA, more..

Training Reviews

Register Now

 

SQL DBA Online Training - Highlights

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • Daily Mock Tests and Weekly Revision
  • TWO Real-time Case Studies, One Project
  • Certification & Interview Guidance
  • Detailed SQL Server Architecture, DB Design
  • 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 Server Training, MSBI Training, SSIS / SSAS / SSRS Training [+] More Courses

Register Today For Free Demo