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: 80 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 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)

 

* Below course curriculum applicable for registrations from March 26th, 2017
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: 16    Cost: INR 6000/-

VIDEO 1: 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 2: 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 3: 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
  • Basic SQL Operations and Conditions

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

VIDEO 5: 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 RIGHT Outer Joins - Usage
  • Joins with multiple tables, Basic Reports
  • Using JOINS with Cascaded Views
  • Views on Multi Table Joined Queries

VIDEO 6: INDEXES & QUERY TUNING

  • Indexes Architecture, Types and Purpose
  • Clustered Indexes - Architecture, Usage
  • Non Clustered Indexes - Architecture
  • Data Pages and Index Pages 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)
  • Indexes with Primary Key & Unique
  • Query Optimizer (QO) Component Usage
  • Query Tuning with Execution Plans

VIDEO 7: 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 8: 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 9: CTE, QUERY TUNING & CURSORS

  • Stored Procs for Dynamic Sub Queries
  • OUTPUT Parameters, Nested Sub Queries
  • Common Table Expressions (CTE) & Uses
  • CTE - Data Retrieval & Conditional DML
  • Using Recursive CTEs with Procedures
  • Recursive CTEs and Query Performance
  • Tuning Operations with CTE Queries
  • CTE Limitations and Self Join Options
  • Cached Plans & Memory for Stored Procs
  • RECOMPILE, ENCRYPTION, ANCHOR
  • Cursor Types - Benefits, Purpose, Options
  • Cursor Life Cycle & Usage Precautions
  • FORWARD_ONLY, SCROLL Cursors Types
  • STATIC, DYNAMIC Cursors and Queries
  • LOCAL and GLOBAL Cursor and Queries
  • KEYSET DRIVEN Cursor & Performance
  • Embedding Cursors in Stored Procedures
  • SPs with Cursors For Dynamic Data Loads
  • Temporary Tables for Stored Procedures
  • Embedding Cursors in Stored Procedures

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: 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 13: 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 14: 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 15: 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 16: 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 17: 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 18: 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 and Commit Overloads
  • Unrestored Log Information - History
  • PARTNER OFFLINE Conditions & Options
  • DB Mirroring Monitors, Commit Loads
  • SYNCHRONOUS & ASYNCHRONOUS Modes
  • Automated Failover and Partner Roles
  • Mirroring Monitor and Mirroring History
  • Real-World Considerations & DR Options
  • DR & HA with DB Mirroring Advantages
  • Need for Always-On & Higher Availability
  • Database Mirroring Errors and Solutions

VIDEO 19 - 20: SECURITY MANAGEMENT

  • Authentication Types - WINDOWS, SQL
  • Windows Logins - Users and AD Groups
  • SQL Server Logins, POLICIES, EXPIRY
  • CONTAINED Database Authentication
  • Server Configuration for Containment
  • Default Database and Language Settings
  • 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, Test Logins
  • Scripting Logins, Users, Roles, Schemas
  • Scripting Login - User Mapping, Securables
  • Scripting User and Role Permissions
  • Symmetric Key Passwords: Data Security
  • CERTIFICATES For Data Level Security
  • Master Passwords, DB Level Encryption
  • Master Passwords and Certificate IDs
  • Proxies - Purpose, Usage and Options
  • Server Credentials for Agent Proxies
  • Job Level Security, Replication Proxies
  • Login Errors � Audits and Server Logs
  • Management Error Logs, 18456 Error
  • Possible Logon Failure Errors, Scenarios
  • Password Resets and Disabling Logins
  • Common Security Functions & Queries
  • DMVs for Server and DB Security Audits
  • Server Principals, Database Principals
  • Security Audits Reports - Creation, Store
  • Audit Spectification Types, LOGON Events

VIDEO 21: LOCKS, DEADLOCKS, XEVENTS

  • 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
  • DeadLock Priority and Trace Flags
  • Extended Events and Telemetry Logs
  • SQL Profiler Tool & DeadLock Graphs
  • SQL Profielr Tool with XDL Events

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: 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
  • Creating Performance Baselines
  • Backup Encryptions & Stretch Databases

VIDEO 24: 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 25: 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 26: 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 27: 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 28: 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 29*: 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
  • Data Migration Assistant (DMA) Tool
  • Using DMA Tool for Database Migrations
  • Using DMA Tool for Server Assessments
  • Rebuilding System Databases & Objects
  • Pre Database Maintenance Activities
  • Post Database Maintenance Activities
  • Server Aliases and Usage. Port Settings
  • Side-By-Side Upgrades - Scenarios, Usage
  • Inplace Upgrades : Scenarios, Usage
  • Rollback Operations: Upgrades, Updates
  • Real-world Management Considerations

VIDEO 30: 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
  • Add Nodes to SQL Server Cluster
  • SQL Group & AD Syncup Operations
  • Network Security Issues with Solutions

VIDEO 31: 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
  • Fail-Over Disk & RAID Implementation
  • Smoke Test Procedures in Real-time
  • SQL Group & AD Syncup Operations
  • SAN System for Shared Data Storage
  • MS DTC Configurations (Local/Remote)

VIDEO 32,33: ALWAYS-ON AVAILABILITY(AAG)

  • Need for Always - On Availability (AAG)
  • Always-On Prerequisites, Node Config
  • Always-On Availability Groups (AAG)
  • Prerequisites for Always-On for HA/DR
  • Always-On Extended Events - Logging
  • SQL Server Cluster Installation
  • Verifying Cluster Node Configurations
  • 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
  • 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 34: 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 35: 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 36: 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
VIDEO 37, 38: Real-time Project

ECommerce Domain: Always-On,
HR/DR, PSSDIAG, Tuning, 3rd Party Tools, DBA Checklist Activities, Errors, Solutions SQL Database Deployment to Azure (Cloud)

PS: Above curriculum applicable for registrations from June 13th, 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

SQL School Phone IndiaIndia: +91 (0)9666440801
SQL School Phone USAUSA: +1(510) 400-4845
 

WHY CHOOSE US:

Microsoft Partner (ID# 4338151)

100% Real-Time and Practical

ISO 9001:2008 Certified

24/7 LIVE Server Access

Real Time Projects

Theory Material in Advance

Weekly Mock Interviews

Placement Assistance

Job Support

OFFICE 1:

#108/2RT, Road #1, Beside SR Nagar Bus Stop, Ameerpet, Hyd-38

India: 0091 (0)9666440801

Map
OFFICE 2:

Sai Anu Avenue, Street #3,
Patrika Nagar, HITEC City, Hyd - 81

India: 0091 (0)9666440801

Map

OUR RATINGS

Google: 4.7/5

Facebook: 4.8/5

Sulekha: 4.8/5

JustDial: 4.7/5

MouthShut: 5/5

UrbanPro: 5/5

Yet5: 5/5

 
 

©2008-2017 SQL School, Regd®: Sequelgate (I) Technologies Pvt. Ltd™

Sql School is an Authorized Microsoft Training Partner (ID# 4338151)

SequelGate (I) Technologies Pvt.Ltd. is rated 4.8/5 by www.facebook.com/Sqlschool based on 107 reviews

FOLLOW US:
social
social
social
social
social
social