SQL Server DBA online training course is a soup-to-nuts course that will teach you everything you need to build, configure a server, maintain a SQL Server disaster recovery plan, and how to design and manage a secure solution. You'll learn how to automate daily, weekly and hourly tasks (like backups), the details of security, SQL Server online clustering, replication, disaster recovery, and using jobs and database maintenance tasks. This course consists of all practical trouble shooting issue which you arise in day to day activities. Each and every topic is covered with unique case studies. This course is divided into 7 modules and totals more than 50 hours of instructor-led online/onsite training for SQL Server 2012.
Overview:
This course is a soup-to-nuts course that will teach you everything you need to build, configure a server, maintain a SQL Server disaster recovery plan, and how to design and manage a secure solution. You'll learn how to automate daily, weekly, and hourly tasks (like backups), the details of security, SQL Server clustering, replication, disaster recovery, and using jobs and database maintenance tasks.
This course consists of all practical trouble shooting issue which you arise in day to day activities. Each and every topic is covered with unique case studies. This course is divided into 7 modules and totals more than 50 hours of instructor-led online/onsite training for SQL Server 2012.
Course Topics:
- Introduction to database management systems and databases
- SQL Server 2012 Installation
- SQL Server 2012 Administration and Development Tools
- SQL Server 2012 Architecture
- SQL Server Database objects
- SQL Server Backup and Recovery – Part 1
- SQL Server Backup and Recovery – Part 2
- SQL Server Data Export and Import (Data Movement)
- SQL Server security
- Performance Tuning – Part 1
- Performance Tuning – Part 2
- SQL Server High Availability (Advance Topis)
- Unique Teaching Methodology