Disable Preloader
SQL SERVER DBA

DBA is Database Administrator. The tasks undertaken are capacity planning, configuration, installation, migration, database design, security and troubleshooting and data recovery. Every course covers essential basic & advanced topics. Gain comprehensive knowledge on techniques to administrate the Microsoft Structured Query Language (SQL) database and secure career in field of such a good scope. Avail complete guidance with every course package to get placed as a MS SQL Server DBA in a leading firm in US.


Attend the MS SQL Server DBA training course to enhance your ability to design, implement and manage SQL Server databases. In this training course, students will enhance their skills and experience as Microsoft DBA for managing a SQL Server 2012 system. Now get a quick start for mapping, comparing and contrasting the various aspects of MS database management and business intelligence. All the modules of MS SQL Server are highly descriptive and focus on not just introducing the concepts but also on providing hands-on learning.

Module List

  • ARCHITECTURE
  • INSTALLATION
  • SQL SERVER ENHANCEMENTS FROM 2008
  • CONFIGURATION SETTINGS
  • SYSTEM DATABASES
  • CREATING USER DATABASES
  • DATABASE OPTIONS
  • BACKUPS
  • RESTORATIONS
  • AUTOMATION
  • SECURITY
  • MIGRATION
  • UPGRADATION
  • HIGH AVAILABILITY
  • PERFORMANCE TUNING

SQL SERVER DBA

    •  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
    • SQL Server Data Export and Import (Data Movement)
    • SQL Server security
    • Performance Tuning
    • SQL Server High Availability (Advance Topics) such as Database Mirroring, Log Shipping, AlwaysOn, Failover cluster instance improvements, Creating AlwaysOn availability groups, Administering AlwaysOn Availability groups and Reading secondary database copies

    MS SQL Server DBA training course is designed for IT professionals who support or plan to support Microsoft SQL Server 2012 or 2008 R2 databases. Even those who wish to take Administering Microsoft SQL Server 2012 Databases exam should opt for this course. SAP system administers, database administrators, project team members and technology consultants are ideal audience for this training.

    Interested candidates should have good hands-on knowledge of Microsoft Windows OS basic operations, networking concepts such as domain and active directory, and network settings.

    Microsoft Windows Server 2012 Infrastructure

Training Advantages
35 contact hours
Industry Case Studies
Industry case studies
Real time training

SQL SERVER DBA FAQ'S

    SQL Profiler in the SQL Server Utility can be used to trace the traffic hitting SQL Server.

    It serves as a template for all databases created on the same instance. Modifying the model database will automatically bring the changes in all subsequent databases created on that instance.

    •  Snapshot
    • Merge
    • Transaction

    It is a job scheduling mechanism in SQL Server that allows jobs to run at a pre-determined mind. Most commonly SQL Agent is used to schedule administrative jobs such as backups.

    DBCC statements are Database Console Commands and it is of four types

    • Maintenance
    • Informational
    • Validation
    • Miscellaneous

    •  SQL Server supports Windows Authentication and mixed-mode.
    • Name few native SQL Server performance monitoring and tuning tools
    • System objects
    • Profiler
    • Perfmon/System Monitor
    • Dynamic Management Views and Functions
    • SQL Server Management Studio Built-in Performance Reports
    • TYPEPERF.EXE

    •  CREATE INDEX with DROP_EXISTING
    • DROP INDEX and CREATE INDEX
    • ALTER INDEX