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: 38 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 and Tasks
  • Two Real-time Case Studies
  • One Realtime Project
  • Certifications & Interview Guidance
  • Interview FAQs & Resume Guidance
  • 24x7 LIVE Server with Lab, Support
Trainer: Mr Sai Phanindra T (10+ 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: 15    Cost: INR 6000/-

Video 1: SQL Server Installation & Config

  • SQL Server 2012 Installation
  • SQL Server 2014 Installation
  • SQL Server 2016 Installation
  • Pre-requisites: WMI, MSXML, DTC
  • Possible Errors & Solutions - Level 1
  • Possible Errors & Solutions - Level 2
  • Firewall Warnings & Port Configuration
  • Services and Service Accounts, Usage
  • Authentication Modes & Logins
  • Tempdb Location, UserDB Location
  • Collation Settings and Controller
  • Testing Instances and Services
  • Configuration Manager &Server Aliases
  • SQLCMD, Management Studio (SSMS)

Video 2: SQL Server Database Design

  • SQL Database Architecture
  • DB Catalog and Storage Options
  • Data Files : Purpose and Storage
  • Filegroups : Purpose and Usage
  • Log files : Purpose and Audits
  • Transaction Log Files - Considerations
  • Sizing and Placement - Data Files
  • Sizing and Placement - Log Files
  • Locations and Sizing Recommendations
  • Filegrowth and MAXSIZE Options
  • Scripting Database Structures
  • Database ALTERs and Considerations
  • Designing Very Large Databases (VLDB)
  • Placement of Files and Filegroups
  • DB Design Parameters and Limitations

Video 3: Table Design and Queries

  • Tables Design Concepts & Normal Forms
  • Table Creation Process and Options
  • File Groups and Table Design
  • Role of Schemas and Table Design
  • DML, DDL and SELECT Operations
  • Single Row and Multi-Row Inserts
  • Table Aliases, Column Aliases & Usage
  • INSERT & SELECT Variants in T-SQL
  • Data Types and Column Usage
  • Row size Computations and NULLs
  • Basic INSERT, UPDATE, DELETE
  • Multi-Row Inserts & SELECT
  • SELECT Queries with Schema References
  • Basic Data Types and NULL Values
  • Design Limitations with UPDATES
  • Role of Log Files for DML Operations
  • DELETE versus TRUNCATE Statements

Video 4: Normalization & Constraints

  • Normalization & Constraints
  • Normal Forms in Table Design
  • OLTP Database Model and BCNF
  • NULL Property and Importance
  • UNIQUE KEY Columns and Usage
  • PRIMARY KEY - Usage & Limitations
  • Use of FOREIGN KEY References
  • CHECK and DEFAULT Constraints
  • Composite Primary Keys & Use
  • Identity Property & Duplicate Keys
  • Identity Property with PRIMARY KEY
  • Managing Keys and Constraints
  • Recommendations, Naming Conventions

Video 5: Views & Joins - Queries

  • Views in SQL Server and Usage
  • SELECT Query 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
  • Using JOINS with Cascaded Views
  • Views on Multi Table Joined Queries

Video 6: Indexes & Joins

  • Indexes : Need, Types and Usage
  • Index : Architecture & Placement
  • Index Pages : Design and References
  • Query Optimizer and Query Executions
  • Index SCAN and Index SEEK Plans
  • Clustered & NonClustered Indexes
  • SORT_IN_TEMPDB Options for Indexes
  • FILLFACTOR and PAD_INDEX Options
  • INCLUDED Column Indexes & Types
  • Using Indexes with Table Constraints
  • Unique Indexes and Performance
  • Indexed Views, Query Plans & Tuning

Video 7: Stored Procedures & Joins

  • Stored Procedures - Benefits & Parsing
  • Stored Procedures Types & Exec Plans
  • Use of Variables and Parameters
  • Using SPs for SQL Data Validations
  • Using SPs for Data Reporting Operations
  • Using SPs for Joined Data Sets
  • System Stored Procedures and Usage
  • Dynamic SQL Queries - Execution
  • RECOMPILE Options and Advantages
  • Using SPs with Cursors - Querying
  • Procedures with Temporary Tables

Video 8: Functions & Sub Queries

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

Video 9: Procedures with Triggers, Cursors

  • Triggers - Types and Usage
  • Understanding Trigger Executions
  • DML Triggers & Performance Impact
  • INSERTED and DELETED Memory Tables
  • FOR Triggers - Importance and Usage
  • Instead Of Triggers - Importance
  • BULK Operations with DML Triggers
  • Using Triggers for Audit Operations
  • Triggers for Data Sampling Operations
  • Database Level Triggers - Usage
  • Server Level Triggers - Usage
  • Triggers for Updatable Views (Cascade)
  • Cursor Variables - Types and Usage
  • STATIC versus DYNAMIC Cursors
  • SCROLL Versus FORWARD_ONLY Cursors
  • LOCAL, GLOBAL and KEYSET Cursors
  • Cursors For Dynamic SQL Queries
  • Embedding Cursors in Stored Procedures
  • Using Temporary Tables with Procedures
  • Temp Tables versus Table Variables

Video 10: Transaction Concepts & Blocking

  • Understanding ACID Properties, Scope
  • Explicit and Implicit Transactions
  • Comparing Autocommit and Explicit
  • Comparing Autocommit and Implicit
  • Nesting Of Transactions - Benefits
  • Savepoints and working with Batches
  • Object Blocking Issues & Solutions
  • Query Blocking Issues & Solutions
  • Nested Transactions and Savepoints
  • Lock Hints in Queries & Performance

Video 11: SQL Server Architecture

  • SQL Server Architecture - Client/Server
  • Encrypted Data Communication
  • Data Provider and Connection Types
  • SQL Architecture - TDS Packet Sizing
  • SQL Architecture - Batch & Client Stats
  • SQL Architecture - Protocols, DB Engine
  • Memory Manager and SQL Manager
  • Query Optimizer (QO) and Executions
  • 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: Lock Issues & Deadlocks

  • Understanding Locks, Types & Usage
  • SP_WHO2 and SP_LOCK Outputs
  • Lock Types, Resources and Lock Hints
  • Lock Manager Concepts & Escalations
  • Avoiding WAITS on PAGE and TABLE
  • Isolation Levels - Types and Usage
  • READ COMMITED and SERIALIZABLE
  • READ UNCOMMITED and REPEATABLE
  • SNAPSHOT & READCOMITTED SNAPSHOT
  • Choosing Isolation Levels For OLTP
  • Statement Locks & Transaction Locks
  • TempDB Issues with Isolation Options
  • Locking Hints to Avoid Blockings
  • A DEADLOCK Scenario and DML Audits
  • Deadlock Detections and Avoidance

Video 13: Logins, Users & Roles

  • Understanding Security Architecture
  • 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
  • Simulating SQL Security Logins
  • Login Errors and Password Resets
  • GRANT, DENY & REVOKE Permissions
  • Common Security Functions & Queries
  • Scripting Procedures For Securables

Video 14: Object Level Security & Proxies

  • A Realtime Security Scenario
  • Object Level Security & Levels
  • Securable Types and Options
  • Database Level Roles & Usage
  • Need for Schema Level Security
  • Schema Level Ownership - Benefits
  • DB Certificates and Master Keys
  • Data Level Security & 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 Security Audits
  • DMVs for Database Security Audits
  • Useful Security Audit Queries (DMVs)

Video 15: Backups with T-SQL Scripts

  • Backups Concept and Mechanism
  • Backups Usage and Limitations
  • Data Backups - Syntax and Types
  • Log Backup Mechanism and Use
  • CHECKPOINT and TRUNCATE Options
  • Tuning Database Backup Operations
  • File Backups and Filegroup Backups
  • COMPRESSION, CHECKSUM and STATS
  • Partial Backups with Filegroups
  • Remote Backups and Security Options
  • Backup Jobs and SQL Agent Service
  • Scheduling Backups & Strategies
  • MSDB History Tables and Audits
  • Important Queries for Backup Audits

Video 16: Backups & Restores - I

  • Backup Verification Procedures
  • Recovery Paths and FILELIST Options
  • Database Restores & RECOVERY Options
  • File Restores and Filegroup Restores
  • FILELISTONLY and VERIFYONLY Options
  • MOVE and REPLACE Options For Restores
  • PARTIAL and Piecemeal Restores
  • Tail Log Backups & Database States
  • Re-Restoring (REDO) Log Backups
  • Compressed Tail Log Restores
  • Re-Restoring (REPLACE) Backups Sets
  • Restores for Partial Online Databases
  • Choosing Right Backups for Restores

Video 17: Backups & Restores - II

  • Backup Mirrors and Restore Options
  • Backup Splits and Restore Options
  • Media Set, Media Family and Options
  • FORMAT, NOFORMAT, INIT and NOINIT
  • SQL 2012 Backups to SQL 2014 Restores
  • Partial Backups and STATS Options
  • CHECKSUM and CONTINUE_ON_ERROR
  • Compatibility, Recovery Model Options
  • Working with Recovery Models, Backups
  • Choosing correct Recovery Model
  • Backups using UI and SSMS Tool
  • COPY_ONLY Backups and Importance
  • Point-In-Time Restores & Recovery
  • Overwrite Options for DB Restores
  • Backup Devices Creation & Usage
  • Backup Devices Uses and Limitations

Video 18: Replication For HA/DR

  • Replication Use & Importance
  • Replication Architecture & Entities
  • Articles, Publications, Subscriptions
  • Deciding Distribution Components
  • Repl Distributor & Snapshot Paths
  • Distribution Database Configurations
  • Articles, Filters and Publications
  • Article Dependencies & Encryptions
  • Working of Snapshot Replication
  • Working of Transactional Replication
  • PUSH and PULL Subscription Options
  • Replication Monitor - Usage & Options
  • Testing Replication Components
  • Replication Jobs & Verifications

Video 19: Replication Tuning & Issues

  • Working of Merge Replication
  • Replication Conflicts and ROWGUIDCOL
  • Tuning Repl Merge Agent & Security
  • Domain Accounts For Replication
  • Limitations with Merge Replication
  • Peer-Peer Replication and Conflicts
  • Adding Peer Nodes with Node IDs
  • Pull Distributors For Peer-Peer
  • Replica Initialization with Backups
  • Replication Conflicts and Solutions
  • Replication Events and Data Audits
  • Article & Filter Management Options
  • Replication for HA & DR Procedures

Video 20: Log Shipping for DR

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

Video 21: DB Mirroring for Disaster Recovery

  • DB Mirroring Architecture & Use
  • Mirroring Configuration Scenarios
  • Backups & Restores for Mirrors
  • TCP Endpoints & Network Security
  • Heartbeat and Polling Concepts in DM
  • Working with Service Accounts & Use
  • Automatic Fail-Over Procedures
  • Manual Failover Options & Scenarios
  • PARTNER OFFLINE Conditions & Options
  • DB Mirror Monitors and Commit Loads
  • Real-World Considerations & DR Options
  • DR & HA with DB Mirroring Advantages

Video 22: Database Audits & Queries

  • Query Resources - CPU, IO and Memory
  • Audits - Activity Monitor Usage
  • Audits - SQL Profiler Tool Usage
  • Database Health Check & DBCC
  • Log Space Usage Audits with 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 Running Queries - DMF
  • Query Audits and DMVs / DMFs, Joins
  • Audits for Storage Allocation Issues

Video 23: Data Exports (SSIS) and DB Mail

  • Import & Export Operations
  • OLE-DB, SQLNCLI and Jet Drivers
  • Choosing correct Data Providers
  • Scheduling SSIS Packages using Jobs
  • 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 Emails
  • Warnings and Emails with DB Mail
  • Testing Job Failures and Notifications

Video 24: A Real-world Production DBA

  • An Online Book Sales Database
  • DBA Challenges in Real-time (PROD)
  • SLA and OLA Process in Real-time
  • Need for Documentations & References
  • Downtime & Maintenance Notifications
  • Using SQL Browser Service for TCP/IP
  • Configuration Manager Tool - Usage
  • Routine DBA Activities - Checklist
  • Emergency DBA Activities - Checklist
  • Maintenance DBA Activities - Checklist
  • Performance Tuning - Checklist

Video 25: Partitions & Query Tuning

  • 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 Types and Options
  • Managing Partitions and Tuning Options

Video 26: Full Text Indexes & Database Tuning

  • LIKE Operator - Limitations & Wild-cards
  • Full Text Search Configuration
  • Full Text Search Service and Options
  • Database Catalogs (FTC) and Storage
  • Full Text (FT) Indexes 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 Tuning with FT Indexes

Video 27: Index Management & Query Tuning

  • Index Internals and Execution Plans
  • Index Fragmentation - Issues, Solutions
  • SAMPLED & DETAILED Query Scans
  • 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
  • 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
  • Filtered Indexes and Sizing Options
  • Analyzing Work Load Tables and Scans
  • Table Statistics and Query Tuning
  • Statistics Role in Query Tuning Process

Video 28: 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
  • Modifying SSIS DB Maintenance Plans
  • Scheduling and Maintaining SSIS Plans
  • Log File Issues and Shrinking Operations
  • SQL DB Engine Properties & Guidelines
  • Service Configuration Properties
  • Distributed Transactions & Connections
  • Query Governor Usage and DOP Options
  • Policy Based Management (PBM) & Facets
  • Database Properties & Conditions
  • Scheduling Policies & Event Management
  • Considerations for Policy Management

Video 29: Alerts, Issues & Troubleshooting

  • LOG File Space Issues and Solutions
  • TEMPDB Space Issues with Solutions
  • MEMORY Management Issues - Solutions
  • OS Level Memory Clerks and Monitoring
  • Memory Leaks, 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 Options and Downtime
  • Database States Alerts and DB Events
  • DBCC Commands and Database Repairs
  • Rebuild Operations and Considerations
  • Important DMVs and DMFs for Audits

Video 30: Service Packs & Server Upgrades

  • Establishing Downtime For Maintenance
  • Precautions for Maintenance Activities
  • Service Packs and Patch/hotfix Activities
  • 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: Installing Windows Clusters

  • Understanding SQL Clustering Need
  • SQL Server Clustering Architecture
  • Understanding Ping Tests and Heartbeat
  • Windows and SQL Server Licensing
  • Windows Server Installation Options
  • SP Installation and Quorum Options
  • Installing Windows MSCS Service
  • Verifying SQL Cluster Installation
  • SQL Server Cluster PING and RAID Tests
  • Verifying Cluster Configurations
  • Software RAID Configuration and Issues

Video 32: Active Directory (AD) and DTC Config

  • 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
  • SAN versus NAS Comparisons & RAID

Video 33: SQL Server 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

Video 34: Always-On Availability Groups (AAG)

  • Connection Issues and Drains
  • Security Issues with Solutions
  • Storage Issues with Solutions
  • Installing Updates in SQL Clusters
  • QUORUM Checks, Storage Issues
  • SQL Server Cluster Utilities & Usage
  • Always-On Availability Groups (AAG)
  • Practical Challenges For HA and AAG

Video 35: SQL Server Cluster Management

  • Real-World Considerations For AAG
  • SQL Server Cluster and AAG Limitations
  • SQL Clusters For High Availability
  • Active-Active Cluster Configurations
  • Active-Passive Cluster Configurations
  • Cluster Working and Operative Modes
  • Configuration Settings - Monitors
  • SQL Server Cluster Node Updates
  • Cluster Configurations and Planning

Video 36: Database Migration & Management

  • Database Migration Options
  • DB Design Audit for File System
  • Database Detach Options and Downtime
  • Database Attach Options and Scripting
  • Linked Server Management Options
  • Memory Dashboard & Buffer Cache
  • Memory Management Audit Report
  • Memory Issues and Solutions
  • Policy Management Options and Usage
  • Facets and Conditions : On Demand
  • Facets and Conditions : On Change
  • Policy Based Management Reports
  • AAG - Insight with SQL Clusters

Video 37: Change Data Capture, Server Aliases

  • Need for CDC & Table Audits
  • CDC Audits - Jobs and DML Operations
  • CDC Tables for DDL Event Audits
  • LSN Mapping and State Changes
  • Limitations and Scenarios with CDC
  • SQL Server Configuration Tool & Usage
  • SQL Configuration Management Options
  • XML and BLOB Data Management
  • BLOB - Performance Considerations
  • Server Aliases and Protocols
  • 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

  • Database Encryption Options
  • Master Key Encryptions For TDE
  • Server Certificates for TDE
  • Database Key Encryptions for TDE
  • Certificate Backups and Restores
  • Database File Encryptions, Audits
  • DB Scripting Recommendations
  • Non SSMS Backups and Audits
  • Backups with Third Party Tools
  • Third Party Ticketing Tools
  • Understanding SLA & OLA Process
  • Real-world Knowledge Base (KB) Articles
  • Notifier Tools and SLA Reports
  • Server Dashboards and DB Audits
PS: Above curriculum applicable for registrations from September 5th, 2016.

Trainer : Mr. Sai Phanindra T, 9+ 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 Classroom 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
  • 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 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