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:

* Below course curriculum applicable for registrations from July 6th, 2017. If you already pursuing the course click here for older curriculum

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

    Video 36, 37: Real-time Project for SQL DBA

    ECommerce Domain:
    Always-On (AG) Groups, HR & DR Implementation, DB Monitoring PSSDIAG, Tuning, Trace Flags, Policy Based Management (PBM), Facets Server Aliases, Configuration Manager 3rd Party Tools, SLA-OLA, DBA Checklist Activities Database Migration to SQL Azure Routine DBA Activites & Solutions Emergency DBA Activities & Solutions Common Erros & Solutions

    * Above course curriculum applicable for registrations from July 6th, 2017. If you already pursuing the course click here for older curriculum 

    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 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
    • High Availability, Disaster Recovery, Always-On
    Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses