India : +91 9502991277
    VOIP: +1 408 876 4444
Email : online@mindqsystems.com
Latest Online Courses >> Microsoft .net and sharepoint
Follow us on :

SQL Server 2012 DBA

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

Pre-Requisites

Course Completion

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.

Pre-Requisites:

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture.

Software Needed on Each Student PC

  • Windows Server 2008/R2 or 2012, with at least 2GB RAM
  • SQL Server 2012

Course Completion:

After completing this course, students will be able to:

  • Install and configure SQL Server 2012
  • Upgrading from older versions like 2005/2008/R2 to 2012
  • Backup and restore databases.
  • Manage security.
  • Managing indexes and finding performance bottlenecks
  • Automate administrative tasks.
  • Replicate data between SQL Server instances.
  • Maintain high availability.[log-shipping, Mirroring]
  • SQL Server 2012 Clustering implentation/administration
  • Impletementing AlwaysOn and administering AlwaysOn groups
  • Data Compression, Resource Governor, Central Management Servers
  • User defined Server roles, Contained Databases, Column store indexes
  • Performance tuning using Profiler, DTA & System monitor
  • All students will receive:

  • More than 500 pages of fully-illustrated case studies courseware
  • A copy of Guide to SQL Server Database Administration

For Detailed Course Contents Click here
For Detailed Book Contents Click here
For Upcoming Class Room Batches Click here

For Registration      

  • Firehouse
  • Chloe nightclub
  • Firehouse bar
  • Firehouse chloe club fishtank
  • Firehouse restaurant
  • Firehouse