Classified         Views: 812

MS SQL Server DBA Training at FuturePointTech - Texas

MS SQL Server DBA Training at FuturePointTech 

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

Price: Make Offer
Listing ID: 14965
    • Listing Began:
    • Sun, 05 January 2020
    • State
    • Texas
    • City
    • Dallas
    • Price:
    • Make Offer
    • Time Remaining:
    • Auction starts on first bid
Anonymous
Please be aware of scammers. Do not send money, give information or contact any untrusted entity. USA-classifieds does not ensure the identity of the publishers.

 Comments - Login Required

Be the first to post a question or comment on this listing.

Similar Classified Ads

100% Original Papers 100% Original Papers... Price: $0 USD Texas, San Antonio
Cybersecurity Certification Training... Price: $0 USD Texas, Irving
Build Your Own Nest Egg Income!... Price: $0 USD Texas, Austin
» More Similar Ads