About this course:

SQL Server is a Microsoft product used to manage and store information. Technically, SQL Server is a “relational database management system” (RDMS). Broken apart, this term means two things. First, that data stored inside SQL Server will be housed in a “relational database”, and second, that SQL Server is an entire “management system”, not just a database. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.
  1. Introduction to DBA
  2. SQL Server Installation
  3. SQL Server Environment
  4. Security in SQL Server
  5. DBA practical Usage
  6. Objects Level Maintenance
  7. Disaster Recovery Planning
  8. Automation
  9. High Availability
  10. Replication
  11. Monitoring The Database System
  12. Upgrading To SQL Server 2012
  13. Business Intelligence Administration
  14. Third Party Tools
  15. Build Data Quality Solutions

Course Duration : 20 Days (80 Hrs)