MS SQL Server DBA Training at FuturePointTech - Texas

Module 1 – Basic SQL Server DBA 2014 1. Transaction Locks and Deadlocks 5. Data Replications and DR Process • Significance of LOCKS and Usage • Replication Architecture and Configuration • Types of Locks and Lock Hints? • Snapshot and Transactional Replications • Isolation Levels - Types & Usage • Merge Replication, DB Recovery process • Choosing best Isolation Level • Peer-Peer with Backup Initialization • TempDB Issues with Isolation Levels • Replication Types - PUSH & PULL • Recovery Models and Options • Replication Alerts, Warnings and Emails • Choosing Best Recovery Model • Replication Monitors and Event Watch • Real-time Data Deployment Issues • Replication for Load Balancing & DR • Agent Operators, Notifications / Emails 2. Database Backups Strategies • Data Access Modes and Agent Properties • Need for Backups Strategies • Database Backups and Partial Backups 6. Log Shipping and DB Mirroring • FORMAT, INIT, SKIP, CHECKSUM Options • Disaster Recovery in SQL Server • Backup using T-SQL Scripts & UI • Log Shipping Configuration and Modes • Backup validations and Restore Paths • Manual DB Failover using Log Shipping • MSDB History Tables, Backup Audits • DB Mirroring Configuration and Modes • Compressed Backups and Expiry • Automatic and Manual Failover Options • Log backups and Truncation options • Mirror Monitors, Network Considerations • Backup Audit Tables in MSDB • Comparing Log Shipping and Mirroring • Media Sets and Media Truncate Options 7. Security and Data Encryption 3. Database Restores and Recovery Paths • Levels of Security Implementation • Need for Restores and Types • Server level Logins and DB level Users • Backup Verification using T-SQL & UI • Server Roles and User Mappings http://futurepointtech.com/sql-server-dba-training.html