SQL DBA Video Training at SQL School Training Institute

September 16, 2017

SQL DBA Video Training

On demand Training Videos with your comfortable timings and convenient environment. Our SQL DBA Video Training Service (Course Code: VC02) offers complete practical and realtime knowledge transfer services for aspiring SQL Database Administrators. Study and Practice Material along with Realtime Project, Free LIVE Server for Online Lab included in this course. Register for SQL DBA Video Training

SQL Server DBA Video Training - How it works?

Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support. Theory Material to be provided in Advance.

Type:	100% Practical & Example Based, Real-time
No Of Videos:	37 Videos (Duration: 80 mins per video)
Course Fee:	INR 18000/- (USD 300) payable in 3 installments

Trainer : Mr.Sai phanindra T (11+ Yrs Exp,MCT)

Program Highlights & Trainer Profile

Completely Real-time and Practical
Video wise Lab Work, Tasks, Solutions
One Real-time Project + Ticketting Tools
Certifications & Interview Guidance
Interview FAQs & Resume Guidance
24x7 LIVE Server with Lab, Support

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

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

Brouchure Download

Module I: SQL Server & T-SQL Queries

Module II: Basic SQL DBA

Module III: Advanced SQL DBA

DEMO VIDEO: SQL Server 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
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 Takeaways from Course
Weekly Mock Interviews, Resume
Placement Assistance, Course Certificates
MCSA Certification Pattern - Course Plan
Online Lab Access (24x7 LIVE Server)

VIDEO 1: 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 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

VIDEO 2,3: DATABASE & TABLE DESIGN

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 & 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
Routing Tables to File Groups, Advantages
Schemas - Purpose and Usage with Tables
CHAR versus VARCHAR Differences
DB Log Files - Logged, NonLogged Options
Default Schema, Aliases for Table Design
Data Types,Aliased Queries with Schemas

VIDEO 4: CONSTRAINTS and KEYS

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

VIDEO 5: JOINS & VIEWS

Need for Joins and Use Case Scenarios
JOIN - Types, Queries and 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
Joining Tables 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

VIDEO 6: 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, PAD_INDEX, Fragmentation
INCLUDED Indexes, HEAP Performance
COLUMN STORE Indexes - Advantages
FILTERED Indexes - Query Performance
ONLINE Indexes and OFFLINE Indexes
Indexes with Merge and Loop Joins
Primary Key Index, Composite Indexes
Materialized Views (Indexed Views) Usage
Unique Clustered, NonClustered Indexes
Common Table Expressions (CTE) & Uses
Using CTE, Data Retrieval in Stored Procs
CTEs for Avoiding Self Joins, Scenarios

VIDEO 7: FUNCTIONS, SUB QUERIES

Views on Tables, Security Advantages
Views as Stored SELECT Statements
SCHEMABINDING & ENCRYPTION Options
Cascaded Views, WITH CHECK OPTION
Orphan Views - Scenarios in Realworld
Common System Views, Metadata Access
sys.databases, sys.tables, sys.views
INFORMATION SCHEMA views, 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 - Usage, 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, ROW_NUMBER
Views for Sub Queries and Functions
Views for Aggregations and Calculations

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

VIDEO 9: 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 and DYNAMIC Cursors. ABSOLUTE
LOCAL and GLOBAL Cursor. Reusability
KEYSET Cursor & Performance Options
Embedding Cursors in Procedures
Memory Limitations with Cursors, SPs

VIDEO 10: 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
LOCK HINTS: READPAST, NOLOCK, etc..

VIDEO 11: 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) and 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 (SNAC), 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

VIDEO 12: BACKUPS - DB, FILEGROUP, FILE

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, DB VERIFY
CONTINUE_ON_ERROR, 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 and Solutions

VIDEO 13: 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 & 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 and Solutions

VIDEO 14: JOBS, SQL SERVER AGENT, DB MAIL

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
Windows Event Notifications, Operators
DB Mail Configurations, Database Profiles
SMTP Accounts, Email Settings, Ports
Default Public Profiles, DB Mail Security
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
Startup Jobs, Onetime, Recurring Jobs
Job Activity Monitor, Agent Threads

VIDEO 15: 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
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
HASH JOIN Examples and Precautions
MERGE JOIN Examples and Precautions
LOOP JOIN Examples and Precautions
OUTER APPLY and Multi - Level Joins

VIDEO 16: 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
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
New Tuning Options @ SQL 2016

VIDEO 17: PERFORMANCE TUNING - 3

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
Memory Pages and IO Performance
MEMORY LEAKS and PAGE WAITS
LATCH WAITS and Performance Impact

MORE PERFORMANCE TUNING: VIDEOS 34, 35

VIDEO 18: REPLICATION For HA & DR -- LEVEL 1

Replication Architecture and Entities
Replication Topology, Plan, Connections
Distributor Server Configurations, Options
Distribution DB Components and 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
Snapshot Subscriptions and Replica DB
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
Schema Level Replication, DDLs in Repl
Stopping, Starting Replication Agents
Scripting Replication Jobs, Publications
Disable/Enable Replication, Agent Stops
Real-time Errors and Solutions

VIDEO 19: REPLICATION For HA & DR -- LEVEL 2

Transactional Replication, Tracer Tokens
Merge Replication and Merge Agent Job
Replication Conflicts and ROWGUIDCOL
Peer-Peer Replication - Configurations
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 Errors, Events and Solutions
Replication for HA and DR - Strategies
Replication Limitations and Precautions
Replication Errors & Solutions

VIDEO 20: 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
Log Shipping Topology - Limitations
Versioning Issues, Data Traffic. Data Loss
Log Shipping for DB Recovery Procedures
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 and Solutions

VIDEO 21: DATABASE MIRRORING - HA & DR

DB Mirroring Architecture For HA,DR
DB Mirroring Configuration Scenarios
Backups and Restores for DB Mirroring
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 Modes
Manual Failover and HA Partner Roles
Mirroring Monitor, Stop/Resume Options
Real-World Considerations & DR 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 and Solutions

VIDEO 22, 23: 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
User Server Level Roles & Permissions
User Database Level Roles & Permissions
Schemas and DB User Mappings - Usage
GRANT, WITH GRANT, DENY, REVOKE
CONTROL, OWNERSHIP, AUTHORIZATION
Testing Security Operations, Scripting
Common Security Functions & Queries
DMVs for Server and DB Security Audits
Useful Security Audit Queries (DMVs)
KEYS, Passwords - Data Level Encryption
CERTIFICATES & TRIPLE-DES Algorithm
Master Passwords and Data Encryption
SQL Server Credentials, Job Security
Proxies - Purpose, Usage and Options
Server Credentials for Agent Proxies
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

VIDEO 24: DB HEALTH CHECK, AUDIT, LOCKS

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

VIDEO 25: DB MAINTENANCE PLANS, DB 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

VIDEO 26: PERFORMANCE TUNING - LEVEL 4

Memory Optimized Tables & Usage
LIVE QUERY STATS Analysis in SQL 2016
Real-world Considerations for DTA Tool
Workload Groups & Resource Allocation
Query Priority, CPU / Memory / IO Limits
Windows Fibres, Priority Boost and DOP
Processor Settings, Counters & Thresholds
Recommended Thread Counts and Fibres
Query Memory, Memory Leaks, Pagination
Thread Level Architecture - CPU Nodes
Windows Fibres, Priority Boost Options
DOP - Degree Of Parallelism & Options
Temporal Tables, SYSTEM_VERSIONING
Temporal Tables @ DML Audit Performance
In-Memory Tables Creation, Index Options
Extended Events & Performance Impact
LIVE Query Statistics - Monitoring Options
LIVE Query Statistics - Baseline Creation
LIVE Execution Statistics, Hash Plans
Natively Compiled Procedure Performance
System Versioned Temporal Tables
Querying VERSIONS from Temporal Tables

VIDEO 27: PERFORMANCE TUNING - LEVEL 5

PERFMON Counters and PSSDIAG Tools
Dynamic Data Masking DDM Performance
Secured Column Access - DDM Functions
Impersonation with Data Masking (DDM)
Index Management Options - SQL 2016
Distributed Replay Controller Tool, SCOM
Data Migration Assistant (DMA) Tool
PSSDIAG Tool - Performance Monitoring
SQL Browser Server - TCP IP, Trace Flags
CPU Thread Management,Windows Fibres
Priority Boosting and Windows Kernel
Machine Code Usage in Queries
%%COLNAME%% Query Performance
Index Management Options - SQL 2016
New Tuning Options - SQL Server 2016
Performance Tuning - Checklist Activities

VIDEO 28: PERFORMANCE TUNING - LEVEL 6

VIDEO 29: DATABASE 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

VIDEO 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 & Objects
Pre Database Maintenance Activities
Post Database Maintenance Activities
Real-world Management Considerations

VIDEO 31: CLUSTERING CONFIGURATION - HA

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

VIDEO 32: CLUSTERING: 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)

VIDEO 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

VIDEO 34,35: 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

Sign In