Description
Seller-provided details for this listing.
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
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