Advanced SQL Database Administration Master Class, Online, July 10 to July 21, 2017
SQL Server is an enterprise level RDBMS server with a very powerful database engine capable of handling toughest of requirements in terms of scalability, availability, extensibility and performance. The 40-hour class offers a comprehensive coverage of Hardware Sizing, Installing and configuring SQL Server, Managing User and System Databases, Securing and Auditing SQL Server, Virtualization and Monitoring SQL Server. The course will help you to plan backup and restore strategies, design disaster recovery and high availability solutions and will make you ready for the cloud. Overall, this is the most detailed, advanced & comprehensive training on Administering SQL Server.
All Master Class participants will get a 6-month FREE subscription to SQLMaestros Hands-on-Labs. Apart from practicing course specific labs, participant’s will have access to the entire library.
|Course Title||Advanced SQL Database Administration|
(4 hours per day, 10 working days/2 consecutive weeks)
|Date||Week 1: July 10-14, 2017
Week 2: July 17-21, 2017
|Time||Pre-Register with us and let us know your preferred timings. Learn more about our Registration Process|
|Level||300-400 (Advanced to Expert)|
|Target Audience||This course is intended for Microsoft SQL Server Database Administrators who have basic administration expertise and want to advance to the next level in their career.|
|Prerequisites||You need to have at least 1 to 2 years of genuine working experience as SQL Server Database Administrator. This course is not for freshers!|
|Online Delivery|| GoToMeeting. Learn more about our Online Delivery Model|
|Sample Master Class(FREE)||Register|
|Trainer/Instructor||Amit R S Bansal (SQL MCM, SQL MVP)|
- The most advanced SQL Developer Workshop
- 40 hours of deep-dive learning
- Exclusive, level 300/400 content
- Packed with real-world scenarios and examples
- Get your own copy of SQLMaestros course material developed by Amit Bansal
- Learn from the Master: Amit R S Bansal (SQL MCM, SQL MVP)
Module 1: Determining Hardware Requirement for SQL Server Installation
partition alignment, I/O considerations, CPU considerations, Memory Considerations, Virtual machine considerations, Hardware Sizing, performance considerations, SAN Advanced Features and more!!!Module 2: Installing and Configuring SQL Server
Installation Considerations, Server and Database Configuration settings, Database file placement, master databases layout, Filestream consideration, GUI installation, unattended installation using powershell and more!!!Module 3: Managing Databases
Managing Storage for System and User Databases, Moving System and User Databases, Recovering System Databases, Database File Placement, Configuring Buffer Pool Extension and more!!!
Module 4: Securing your SQL Server Installation
Server and database level security, SQL Server logins and users, user and system roles, Authentication Modes, Encryption, certificates and more!!!Module 5: Auditing SQL Server
Audit Logins, Audit Data Changes, Audit SQL Server, DDL Triggers, Change Data Capture and more!!!Module 6: Backup and Restore
: Recovery Models, Backup Strategies, Backup Options, Different Types of Database Backups, Verifying Backup Integrity, Database Restore Process, Different Restore Types, Point-in-Time Recovery, Advanced Restore Scenarios and more!!! Module 7: Maintaining SQL Server Databases
Index and Statistics Maintenance, Consistency Checks, Data Archival or Purging, Creating a Database Maintenance Plan, Automating Maintenance Plan and more!!!Module 8: Monitoring SQL Server
Monitoring Tools – Extended Events, SQL Trace, Important DMVs, Wait Stats, Virtual File Stats, Performance Monitor, PAL, Monitoring VMs, Creating Baseline, Configuring Database Mail, Configuring Alerts, Analysing Collected Data and more!!!Module 9: Disaster Recovery and High Availability
Planning a Recovery Strategy, Log Shipping, Database Mirroring, Availability Groups, Failover Clustering and more!!!Module 10: Troubleshooting Administrative Issues
Troubleshooting Login and Connectivity Issues, Corruption and Consistency Issues, Service Related Issues, Building Inventory, live troubleshooting scenarios and more!!!Module 11: Managing and Troubleshooting Virtualization & 2012
Virtualization Considerations, Processor Best Practices, Memory Best Practices, Storage Best practices, Optimizing CPU, Memory and Storage, Find and fix common Hyper-V and VM-Ware problems and more!!!Module 12: Cloud for DBAs
Azure SQL Databases, SQL Server On Azure VM, Stretch Database, Hybrid Scenarios and more!!!
In the words of Amit Bansal
Hi, my name is Amit Bansal and I am the instructor of this course. SQL Server is an enterprise level RDBMS server with a very powerful database engine capable of handling toughest of requirements in terms of scalability, availability, extensibility and performance. Managing and Administering SQL Server requires solid understanding of SQL Server internals. This course is designed to give you the right amount knowledge and loads of practical implementation techniques to be a Rockstar SQL Server Database Administrator. The 40-hour class offers a comprehensive coverage of Hardware Sizing, Installing and configuring SQL Server, Managing User and System Databases, Securing and Auditing SQL Server, Virtualization and Monitoring SQL Server. The course will help you to plan backup and restore strategies, design disaster recovery and high availability solutions and will make you ready for the cloud. Note that this 40-hour class is rigorous and deep-dive! The course is packed with Hands-On-Labs powered by SQLMaestros.com.
Please feel free to contact us if you need any further information or Book a call with us now!
Email : firstname.lastname@example.org
Skype : email@example.com