+91 8142000093 info@tanviinfo.com

MS SQL Server DBA

TIS_MS SQL Server DBA

MS SQL Server DBA

Course Duration : 40 Hours
Course Delivery : Classroom, Online, Weekends

Course Content

SQL Server DBA Training Syllabus
• Blockings and Deadlocks
• Partitioning Techniques
• DB Snapshots and usage
• Backup Strategies
• Restore Techniques
• Replication Techniques including RMO
• Securing Replication
• Log Shipping with Security
• DB Mirroring and Troubleshooting
• Security Enforcement Performance Tuning
• Import and Export using SSIS
• Cloning Databases and Objects
Advanced Administration
• Certificates and Signatures
• Query Troubleshooting
• SQL Server Profiler
• DB Engine Tuning Advisor
• Data Movement Procedures
• SMO and BCP
• Maintenance Plans
• Database Mail
• Clustering Configuration and Procedures