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