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.

Read Master Class Testimonials
Register For Sample Master Class (FREE)

Course Code PI_SQL_106
Course Title Advanced SQL Database Administration
Course Brochure Download   download_img
List Price
(Super Early Bird) till Mar 4, 2017 USD 1,999
(Early Bird) March 5 to April 8, 2017       USD 2,199
(Regular) April 9 to July 10, 2017 USD 2,499
Duration 40 hours
(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 Ahmad Osama (Senior Consultant at SQLMaestros & Microsoft Data Platform MVP)
Key Highlights:

  • 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 Ahmad Osama
  • Learn from the Master: Ahmad Osama (Senior Consultant at SQLMaestros & Microsoft Data Platform 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 Ahmad Osama

Hi, my name is Ahmad Osama 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 : classes@sqlmaestros.com
Skype : classes@sqlmaestros.com
Contact: +91-9503124667