SQLDBA Video Trainings Online
 

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: 40 Videos (Duration: 85 mins per video)
Course Fee: INR 18000/- (USD 300) payable in 3 installments

This Video Course includes one Real-time Project. Download Brochure
Program Highlights & Trainer Profile

  • Completely Real-time and Practical
  • Video wise Lab Work, Tasks, Solutions
  • One Mini Project + 3rd Party Tools
  • One Real-time Project + Ticketting Tools
  • Certifications & Interview Guidance
  • Interview FAQs & Resume Guidance
  • 24x7 LIVE Server with Lab, Support
Trainer: Mr Sai Phanindra T (11+ Yrs Exp, MCT)

 

Module I: SQL Server & T-SQL

No. Of Videos: 11    Cost: INR 6000/-
Module II: Basic SQL DBA

No. Of Videos: 12    Cost: INR 6000/-
Module III: Advanced SQL DBA

No. Of Videos: 17    Cost: INR 6000/-

VIDEO 0: SQL SERVER INSTALLATION

  • SQL Server 2016 Installation, Tools
  • SQL Server 2014, 2012 Installation, Tools
  • Components: WMI,MSXML,MDAC,Firewall
  • Roles, Responsibilities, Levels - SQL DBA
  • How to install SQL Server - Step by Step
  • Common Installation Errors, Solutions
  • Windows Updates, XML Errors, SETUP
  • SQL Server Management Studio (SSMS)
  • DBA Checklist - Routine DBA Activities
  • DBA Checklist - Maintenance Activities
  • DBA Checklist - Emergency Activities
  • Online Lab Access (24x7 LIVE Server)
  • Mini Project @ Course: L1 DBA Activities
  • Real-time Project: L2, L3 DBA Prod Roles
  • Video wise Course Plan, Server Access

VIDEO 1: SQL SERVER DATABASE DESIGN

  • SQL Server Databases - Design Concepts
  • Database Logical and Physical Design
  • Database Architecture - Files, Filegroups
  • Database Properties and Storage Options
  • Data Files : Pages, Extents and Sizing
  • Filegroups : Purpose, Usage and Options
  • Log files : Size Planning and Placement
  • Database Creation Options using GUI
  • Database Creation using T-SQL Scripts
  • Data File Locations and Sizing Options
  • File / Autogrowth and MAXSIZE Options
  • Planning Very Large Databases (VLDB)
  • Database Structure Modifications, ALTER
  • Adding New Database Files & Filegroups

VIDEO 2: TABLE DESIGN and QUERIES

  • Table Design - Creating Tables, Options
  • Routing Tables to Database FileGroups
  • Schemas - Purpose, Usage in Tables
  • Table Design @ T-SQL Scripts, Variants
  • Table Design @ GUI (SSMS) - Usage
  • Naming Conventions - Table Columns
  • Single Row Inserts - Multi-Row Inserts
  • Table Aliases, Column Aliases, Usage
  • INSERT, UPDATE, DELETE, TRUNCATE
  • SELECT Queries with Schema References
  • T-SQL Data Types, NULL Comparison
  • Database Log Files for DML Operations
  • DML UPDATES and Design Limitations
  • DELETE Versus TRUNCATE Statements

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

VIDEO 4: VIEWS, JOINS, TUNING OPTIONS

  • Views in SQL Server - Purpose, Security
  • SELECT Query Types, Variants in Views
  • WHERE, IN, EXISTS and BETWEEN
  • SCHEMABINDING, ENCRYPTION Options
  • Views with ALTER TABLE, TOP Clause
  • Issues with Views For Data Validations
  • Preventing Orphan Objects with Views
  • Database Diagrams and Entity Relations
  • Views for Enforcing Data Level Security
  • Common System Views For Audits
  • Cross Join, Inner Joins - Comparisons
  • LEFT and RIGT Outer Joins - Usage
  • Joins with multiple tables, Basic Reports
  • Using JOINS with Cascaded Views
  • Views on Multi Table Joined Queries

VIDEO 5: INDEXES & QUERY TUNING

  • Indexes Architecture, Types and Purpose
  • Clustered Indexes - Architecture, Usage
  • Non Clustered Indexes - Architecture
  • Execution Plans & Query Optimizations
  • Table Scan, Index Scan, Index Seek Plans
  • SORT_IN_TEMPDB, Primary Key Indexes
  • Fragmentation: FILLFACTOR, PAD_INDEX
  • INCLUDED and COLUMN STORE Indexes
  • FILTERED, ONLINE/OFFLINE Indexes
  • Indexes & JOINS, Merge, Loop Options
  • STATISTICS - Types and Tuning Options
  • STATISTICS with Indexes, Query Columns
  • Materialized Views (Indexed Views)
  • Query Tuning and Query Optimizer (QO)

VIDEO 6: FUNCTIONS & SUB QUERIES

  • Functions - Types, Purpose, Options
  • Scalar Value Functions - Purpose, Usage
  • Inline Table Value Functions & Usage
  • Multi-line Functions - Scope, Usage
  • CROSSAPPLY and CONVERT, CAST Options
  • SCHEMABINDING, ENCRYPTION Options
  • Embedding Functions in SELECT Queries
  • System Functions and Metadata Audits
  • Date-Time, String, Aggregate Functions
  • RowNumber,Rank,DenseRank, Grouping
  • Date Functions and CONVERT() Styles
  • Using CROSSAPPLY, ROLLUP, GROUP BY
  • Comparing HAVING & WHERE in SELECT

VIDEO 7: STORED PROCEDURES - BASICS

  • Stored Procedures - Purpose and Usage
  • Variables - Usage in Stored Procedures
  • Parameters - Usage in Stored Procedures
  • Stored Procedures for Data Validations
  • Stored Procedures for Dynamic Queries
  • Stored Procedures for Data Reporting
  • System Procedures For Metadata Access
  • Extended Procedures For App Access
  • IF.. ELSE, IF .. ELSE IF, IIF Conditions
  • Error Handling: TRY, CATCH, THROW
  • Dynamic SQL Parameters and Variables
  • Default Parameter Values, Usage Types
  • Stored Procedures with System Views, DB Audits

VIDEO 8: STORED PROCs, CTE, TUNING

  • Stored Procs for Dynamic Sub Queries
  • Stored Procedures for Recursive Queries
  • OUTPUT Parameters, Nested Sub Queries
  • Common Table Expressions (CTE) & Uses
  • CTE & Data Retrieval in Stored Procs
  • CTE & Conditional DML in Stored Procs
  • Using Recursive CTEs with Procedures
  • Recursive CTEs and Query Performance
  • Tuning Operations with CTE Queries
  • CTE with Sub Queries and Row Updates
  • CTE Limitations and Self Join Options
  • Dynamic Parameters and Variables in SPs
  • Cached Plans & Memory for Stored Procs
  • RECOMPILE Option. ENCRYPTION Option

VIDEO 9: CURSORS, JOINS, QUERY TUNING

  • Working with Cursors, Stored Procedures
  • Cursor Types - Benefits, Purpos, Options
  • FORWARD_ONLY, SCROLL Cursors Types
  • STATIC, DYNAMIC Cursors and Queries
  • LOCAL and GLOBAL Cursor and Queries
  • KEYSET DRIVEN Cursor & Performance
  • Embedding Cursors in Procedures, UDFs
  • SPs with Cursors For Dynamic Data Loads
  • Query Tuning and Optimization Options
  • HASH JOIN - Example, Scenario, Usage
  • MERGE JOIN - Example, Scenario, Usage
  • LOOP JOIN - Example, Scenario, Usage
  • Sub Queries and Joins. Alternate Syntax
  • End User Access to Queries - Options

VIDEO 10: TRANSACTIONS & TRIGGERS

  • Use of Triggers - Purpose and Scope
  • DML Triggers and Performance Impact
  • FOR / AFTER Triggers: Usage, Importance
  • INSTEAD OF Triggers: Usage, Importance
  • INSERTED and DELETED Memory Tables
  • Triggers for DML Audits, Data Sampling
  • Database Level, Server Level Triggers
  • Bulk Operations and Updatable Views
  • Triggers for Data Distribution & JOINS
  • ACID Properties and Transaction Types
  • EXPLICIT, IMPLICIT, AUTOCOMMIT Types
  • IMPLICIT Transaction Usage, DB Settings
  • AUTOCOMMIT Transactions, Advantages
  • Open Transactions and Query Blocking
  • Nested Transactions, Save Points and Use
  • Transactions Levels, Performance, LOCK HINTS

VIDEO 11: SQL SERVER ARCHITECTURE

  • SQL Server Architecture - Client/Server
  • Encrypted Data Communication & TDS
  • Data Provider and SQL Connection Types
  • 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 and Lazy Writer
  • Memory Manager and SQL Server Manager
  • Query Optimizer (QO) and Execution Plans
  • Catalogs & CLR / PowerShell Integrations
  • SQL Database Architecture - RAID Levels
  • SQL DB Architecture - Files and Filegroups
  • Log File Architecture - Virtual Log Files
  • Log File Architecture - Mini LSN & DOP

VIDEO 12: LOCKS, DEADLOCKS, LIVELOCKS

  • Locks: Types, Importance, Management
  • SP_WHO2, SP_WHO, SP_LOCK Monitors
  • Lock Types, Resources, Scope, File & Page
  • Lock Monitor Concepts, Lock Escalations
  • Avoiding LOCK WAITS on PAGE and TABLE
  • Isolation Levels - Types and Purpose
  • READ COMMITED, SERIALIZABLE: Issues
  • READ UNCOMMITED, REPEATABLE: Issues
  • SNAPSHOT, READCOMITTED SNAPSHOT
  • Isolation Levels, Hints For OLTP Databases
  • Statement Locks and Transaction Locks
  • TempDB Issues with Isolation Options
  • Locking Hints to Avoid Query Blocking
  • A DEADLOCK Scenario and DML Audits
  • A LIVELOCK Scenario and DML Audits
  • Lock Detections, Avoidance, Precautions

VIDEO 13: BACKUPS - TYPES, STRATEGIES

  • Backups Concept - Purpose, Mechanism
  • Data Backups: Syntax, Types, Precautions
  • File Backups, Filegroup Backups, STATS
  • Log Backups: Syntax, Types, Precautions
  • CHECKPOINT and Log TRUNCATE Options
  • COMPRESSION, CHECKSUM, Validations
  • COPY_ONLY, CONTINUE_AFTER_ERROR
  • Partial Backups & ReadOnly Filegroups
  • Mirrored Backups, Split Backups, Files
  • Backup Devices: Disk/Tape and Usage
  • VERIFYONLY, Appended Backups, File IDs
  • HEADERONLY, FILELISTONLY Options
  • MSDB History Tables and Audit Types
  • Useful Queries for Backup Audits
  • Backup Sets, MediaSets, MediaFamily
  • Backup Types and Protection, Reliability
  • Local, Network and Disk Tape Backups
  • STATS, PASSWORDS, UNLOAD, SKIP, INIT
  • Tuning Database, Log Backup Operations

VIDEO 14: RESTORES & DATABASE RECOVERY

  • Backup Verification Options, Precautions
  • Recovery Paths and Restores - Strategies
  • Database Restores - RECOVERY, STANDBY
  • File Restores and Filegroup Restores
  • FILELISTONLY and VERIFYONLY Options
  • MOVE and REPLACE Options For Restores
  • Metadata Restores and PRIMARY Restores
  • PARTIAL Restore & Piecemeal Restores
  • Tail Log Backups and Database States
  • Re-Restoring REDO Log Backups, Purpose
  • Preparing Databases for Pending Restores
  • Compressed Tail Log Backup Restores
  • Restores for Partial Online Databases
  • RESTRICTED USER, UNLOAD, STANDBY
  • Restore Chains and LSN, CHECKPOINT
  • Restores with GUI - Database & Log
  • MOVE,STANDBY options with UI, Scripting
  • Point-In-Time Restores & Scenarios
  • Point-In-Time Restores, Log Transactions
  • Backup - Restore Errors #3169, 1834, 3119, 4320, 3013, 3702, 8653, etc - Solutions

VIDEO 15: JOBS - NOTIFICATIONS - EMAILS

  • SQL Server Agent Service - Purpose
  • Job Creation Precautions, Process
  • Job Steps, Job Schedules, Other Entities
  • Job Step - Scripts, Parse Option, Verify
  • Job Schedules - Frequency, Reusability
  • Job Notification - Windows Event Logs
  • Routine Backups with SQL Server Jobs
  • Planning Backup Jobs at Off-Peak Hours
  • Job Status Monitor, History Check @ MSDB
  • Job Activity Monitor - Multi Job Status
  • History Purge Options, Cleanup Strategy
  • Job Edits, Disabling / Enabling Jobs
  • Job Scripting Options, Database (DB) Mail
  • Agent Profile and SMTP Account Creation
  • Public, Default Profiles. Email Settings
  • Linking Agent to DB Mail. Operators & Ports
  • Job Notification using DB Mail & Operators

VIDEO 16: REPLICATION For HA DR - I

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

VIDEO 17: REPLICATION For HA DR - II

  • 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 Versus 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 Errors @ DB Engine, Solutions
  • Replication for HA and DR - Strategies
  • Replication Limitations and Precautions

VIDEO 18: LOG SHIPPING - HA & DR

  • Log Shipping Topology, Opeation 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: Recovery Options
  • 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
  • Errors and Solutions @ LS Copy, Restore

VIDEO 19: DATABASE MIRORRING - HA & DR

  • DB Mirroring Architecture for HA,DR
  • DB Mirroring Configuration Scenarios
  • Backups and Restores for DB Mirrors
  • TCP Endpoints, Ports for Network Security
  • Heartbeat & Polling Concepts in Mirroring
  • Service Accounts Configurations, Usage
  • Automatic Fail-Over Procedures, Tests
  • Manual Failover Options and Scenarios
  • PARTNER OFFLINE Conditions & Options
  • DB Mirroring Monitors, Commit Loads
  • SYNCHRONOUS, ASYNCHRONOUS Modes
  • Automated Failover and Partner Roles
  • Mirroring Monitor, Stop / Resume Options
  • Real-World Considerations & DR Options
  • DR & HA with DB Mirroring Advantages
  • Need for Always-On & Higher Availability
  • Database Mirroring Errors and Solutions

VIDEO 20: SECURITY MANAGEMENT - I

  • Authentication Types - WINDOWS, SQL
  • Windows Logins, Registry Settings
  • SQL Server Logins, POLICIES, EXPIRY
  • Default Databases, Keys, Language
  • LOGINS: Server Level Security, Options
  • USERS: Database Level Security, Options
  • SCHEMAS: Object Level Security, Options
  • System Server Roles, Database Roles
  • User Server Level Roles and 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
  • Server Principals, Database Principals
  • Security Audits @ GUI Tools Vs Queries

VIDEO 21: SECURITY MANAGEMENT - II

  • A Real-world Security Scenario (complete)
  • Symmetric Key Passwords: Data Security
  • CERTIFICATES with 3-DES Algorithm
  • Master Passwords, DB Level Encryption
  • Testing Database Encryption Levels
  • Master Passwords and Certificate IDs
  • Basic Job Level Security and Options
  • SQL Server Credentials and User Mapping
  • Proxies - Purpose, Usage and Options
  • Server Credentials for Agent Proxies
  • SSIS Proxies for Job Level Sub Systems
  • Scripting Logins, Users, Roles, Schemas
  • Scripting Login - User Mapping, Securables
  • Scripting User and Role Permissions
  • Login Errors – Audits and Server Logs
  • Management Error Logs, 18456 Error
  • Possible Logon Failure Errors, Scenarios
  • Password Resets and Disabling Logins

VIDEO 22: DATABASE AUDITS, SERVER 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
  • Comparing Profiler Trace Files and Tables
  • Database Health Check: DBCC Commands
  • Allocation Errors and Consistency Errors
  • ESTIMATEONLY, NO_INFOMSGS, Tempdb
  • Log Space Usage Audits with DMVs/DMFs
  • Tempdb Usage Audits with DMVs/DMFs
  • Memory Usage & Disk Usage Audit DMVs
  • Audit Long Running Queries - DMV/DMF
  • Audit Frequent Running Queries - DMF
  • Query Audits and DMVs / DMFs with Joins
  • Storage Allocation Issues (Page, Extent)
  • DBCC Usage in Real-world - Precautions
  • Deadlock Graphs with SQL Profiler Tool
  • Considerations Using SQL Profiler Tool

VIDEO 23: DATA IMPORTS, EXPORTS, DB MAIL

  • Import and Export (SSIS) Wizard - Usage
  • OLE-DB, SQLNCLI, Microsoft Jet Drivers
  • SQL Server and Other Database Sources
  • Database / Non-Database Destinations
  • Choosing Correct Data Providers For SSIS
  • Encrypting SSIS Package Connections
  • File System and MSDB Package Store
  • MSDB System Tables for SSIS Packages
  • Scheduling SSIS Packages (dtsx) @ Jobs
  • Credentials for SSIS Proxies, Win Auth
  • SSIS Proxies - MSDB SSIS Job History
  • Database Scripting & Encryption Options
  • Database Cloning Procedures & Cautions
  • Linked Servers: Configurations, Purpose
  • Linked Servers: Remote Servers, Logins
  • Database (DB) Mail Configurations & Use
  • Securing DB Profiles : SMTP Accounts
  • Operators in SQL Agent and and Emails
  • Warnings and Emails with DB Mail Issues
  • SQL Job Failures and Email Notifications
Mini Project for SQL DBA (Jnr. DBA)
   Banking Domain: HR,DR,Security,
   Audits, Monitoring, Capacity Planning

VIDEO 24: QUERY TUNING - SQL SERVER 2016

  • New Tools, Techniques: SQL Server 2016
  • Memory Optimized Tables - Performance
  • Temporal Tables & SYSTEM_VERSIONING
  • Dynamic Data Masking(DDM) Advantages
  • Dynamic Data Masking Use, Precautions
  • Secured Column Access - DDM Functions
  • Managed Backups & Performance Issues
  • Index Management Options - SQL 2016
  • Distributed Replay Controller Tool, SCOM
  • Data Migration Assistant (DMA) Tool
  • Using DMA Tool for DB Analysis, Upgrades
  • Server and Database Analysis, SSIS
  • PSSDIAG Tool - Performance Monitoring
  • SQL Browser Server - TCP IP, Trace Flags
  • CPU, Threads, Windows Fibres, Priority
  • Performance Tuning - Checklist Activities
  • Backup Encryptions: SQL 2014 Vs 2016
  • Stretch Databases - Cloud Integration

VIDEO 25: QUERY TUNING: SESSION 2

  • Big Data - Performance Considerations
  • Table Partitions & Query Tuning Options
  • Partition Functions For Tuning - Usage
  • Partition Schemes, Reusability Options
  • Partition Ranges, Values and Sort Orders
  • Partitioned Data, Long Running Queries
  • Partitioning Un-partitioned Structures
  • Aligned Partitioning and Performance
  • Fill Factor, Pad Index and Query Tuning
  • Partitions for Query Tuning Operations
  • Statistics with Table & Index Partitions
  • Statistics for Query Conditions, Purpose
  • Stats Audits, Metadata, Manual Updates
  • Data Compression Types and Options
  • ROW & PAGE Compressions. Differences
  • Performance Issues - Data Compressions
  • Partition Numbers, Filtered Compressions
  • Managing Partitions and Tuning Options

VIDEO 26: QUERY TUNING - SESSION 3

  • LIKE Operator - Limitations & Wild-cards
  • Full Text Search (FTS) Configuration
  • Full Text Search Service and Importance
  • Filter Daemon Launcher Server - Options
  • Database Catalogs (FTC) and Storage
  • Full Text (FT) Indexes for Query Tuning
  • Full Text Columns and Primary Index
  • Full Text Index and Searching Queries
  • Full Population, Incremental Population
  • CONTAINS() and FREETEXT() Functions
  • Token Search, Inflectional Forms Search
  • Manual Data Populations, Index Loads
  • Backups, Restores with FT Catalog Files
  • CHANGE_TRACKING Options, Limitations
  • Securing FT Catalogs and FT Indexes
  • Performance Tuning with FT Indexes

VIDEO 27: QUERY TUNING: SESSION 4

  • Index Internals and Execution Plans
  • Index Fragmentation - Issues, Solutions
  • SAMPLED & DETAILED Query Scans
  • Index Rebuilds, Query Tuning Options
  • Table Rebuild Options - CI, NCI 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
  • Understanding Workload Tables in Profiler
  • SQL Profiler Tuning and Lock Templates
  • Index Selectivity Options and Statistics
  • Database Tuning Advisor (DTA) - Usage
  • Understanding PDS Options with Indexes
  • Choosing Correct Option (PDS) for Tuning
  • GAM, SGAM Pages, Metadata Header Info
  • Filtered Indexes and Size Limitations
  • Analyzing Work Load Tables and Scans
  • Table Statistics & Query Tuning Options
  • Statistics Role in Query Tuning Process

VIDEO 28: MAINTENANCE PLANS (DMP, SSIS)

  • Database Maintenance Plans (SSIS)
  • DB Maintenance Strategies & Schedules
  • MSDB History Management Options
  • Backup Files and Space Management
  • Reorganizing Indexes with Maint. Plans
  • Modifying SSIS DB Maintenance Plans
  • Scheduling and Maintaining SSIS Plans
  • Log File Issues and Shrinking Operations
  • SQL DB Engine Properties & Guidelines
  • SQL Service Configuration Properties
  • Distributed Transactions & Connections
  • Query Governor Usage and DOP Options
  • Policy Based Management (PBM) & Facets
  • SQL Database Properties and Conditions
  • Scheduling Policies & Event Management
  • Considerations for Policy Management

VIDEO 29: ALERTS, ISSUES and SOLUTIONS

  • LOG File Issues, Usage and Solutions
  • TEMPDB Space Issues with Solutions
  • MEMORY Management Issues - Solutions
  • OS Level Memory Clerks and Monitoring
  • Memory Leaks, Cache Hits and Solutions
  • Logical and Physical Memory Architecture
  • Procedure Cache Issues and Solutions
  • DB State Events, Issues and Solutions
  • Network Usage, Monitoring, Optimization
  • Performance Monitor PERFMON Counters
  • Replication Threshold Values & Agents
  • Database Settings and Downtime Plans
  • Database States Alerts and DB Events
  • DBCC Commands and Database Repairs
  • Rebuild Operations and Considerations
  • Important DMVs and DMFs for Audits

VIDEO 30: PATCH, SP, 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: WINDOWS CLUSTERS INSTALLATION

  • 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: ACTIVE DIRECTORY (AD), MSDTC

  • Need for Centralized Authentication
  • Domain Controller (DC) Configuration
  • Active Directory Settings and Usage
  • DCPROMO Settings for Active Directory
  • Server Configuration Manager, Options
  • Configuration Manager Features, Users
  • Configuration Manager, Adding Groups
  • Working with Active Directory (AD) Edits
  • Network Configurations and Precautions
  • PING Configurations and DTC Options
  • QUORUM settings and SAN Options

VIDEO 33,34,35: ALWAYS-ON AVAILABILITY(AAG)

  • Need for Always - On Availability (AAG)
  • Always-On Prerequisites, Node Config
  • SQL Server Cluster Installation
  • Verifying Cluster Node 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
  • Cluster Connection Issues and Drains
  • Network Security Issues with Solutions
  • RAID, Storage Issues with Solutions
  • Installing Patch Updates in SQL Clusters
  • QUORUM, Storage Issues: SAN / NAS
  • SQL Server Cluster Utilities and Usage
  • Cluster Working and Operative Modes
  • Configuration Settings - AAG Monitors
  • Always-On Availability Groups (AAG)
  • Prerequisites for Always-On for HA/DR
  • Primary and Secondary Configurations
  • DB Synchronizations, Always-On Options
  • Replica Recommendations for Always-On
  • Backup Storage and Types - Strategies
  • Port Settings and Replica Config in AAG
  • Active-Passive Cluster Configurations
  • Flexible Failover Policy, HA/DR Process
  • Availability Replica - Readable Secondary
  • Active Secondary, SYNC, ASYNC (AAG)
  • IP Configurations and WSFC Settings
  • Node Majority, Disk & File Share Majority
  • Routine DBA Challenges for AAG (HA-DR)
  • Temporal Tables - AAG : SQL 2016

VIDEO 36: DB MIGRATION, MANAGEMENT

  • 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
  • Memory Dashboard and Buffer Cache
  • Server Dashboard, Connection Audits
  • Policy Management Options and Agent
  • Facets and Conditions : On Demand
  • Facets and Conditions : On Change
  • Policy Based Management (PBM) Reports
  • AAG - Insight with SQL Server Clusters

VIDEO 37: CHANGE DATA CAPTURE, ALIASES

  • Need for CDC - Table Audits, CT Tables
  • CDC Enable Databases, Tables, Columns
  • CDC Audits, Capture Job, Cleanup Job
  • ChangeTracking (CT) Tables - DML Events
  • ChangeTracking (CT) Tables - DDL Events
  • LSN Mapping, Time, State Value Changes
  • Performance Impact with CDC, Truncates
  • Limitations and Precautions with CDC
  • SQL Server Configuration Tool & Usage
  • SQL Configuration Management Options
  • XML and BLOB Data - OPENROWSET
  • BLOB Data Store: Performance Issues
  • Server Aliases, Use and Protocols, Ports
  • Services & Minimal Configuration Modes
  • DAC - Dedicated Administration Console
  • DAC - Precautions, Usage and Scenarios
  • Contained Databases - Purpose, Usage
  • Contained Databases - Considerations

VIDEO 38: DB MANAGEMENT, 3rd PARTY TOOLS

  • Transparent Data Encryption (TDE)
  • Master Key Encryptions For Security
  • Server Certificates @ TDE Implementation
  • Database Key Encryptions & File Security
  • Certificate Backups, Key Backups, Usage
  • DB Migrations: Encrypted File Structures
  • Database Scripting Tools & Data Scripts
  • Backups: SQLCMD & SSMS Comparisons
  • 3rd Party Tools Purpose,Recommendations
  • Tools Installation & Server Registrations
  • Backups with 3rd Party Tools, Advantages
  • Reading SQL Server Log Files, Audits
  • REDO, UNDO, ROLLFORWARD @ Log Files
  • Multi Database Backups, HA & DR Process
  • Ticketing Tools - REMEDY, CornerStone
  • Understanding SLA and OLA Process
  • Ticket Allocations, Escalations, Process
  • Real-world Knowledge Base (KB) Articles
  • Notifier Tools, SLA Reports, PRI Tickets
  • Server Dashboards and Database Audits
VIDEOS 39, 40: Real-time Project

   ECommerce Domain: Always-On,
   HR, DR, PSSDIAG, Tuning, Errors,
   Solutions, 3rd Party Tools, SLA-OLA,
   DBA Checklist Activities, Events, Errors

PS: Above curriculum applicable for registrations from Feb 19th, 2017. Brochure Download

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

Training Reviews

Register Now

 

Every video is completely practial, real-time. Session wise notes and lab work for each video. Trainers availble for doubts clarifications.

 

SQL DBA Video Training - Highlights

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Projects, Support
  • Certification & Interview Guidance
  • Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Stretch Databases
  • Routine DBA Activities, Emergency DBA Activites
  • High Availability, Disaster Recovery, Always-On

 

Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Register Today For Free Demo