Email: Phone: +91-9711040083

SQL Server DBA

SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. This course is appropriate for junior-level database administrators that maintain a sql server database. Server runs on T-SQL (Transact -SQL), a set of programming extensions from Microsoft that add several features to standard SQL, including transaction control, exception and error handling , row processing, and declared variables.
SQL Server is the most widely used database management platform round the world. It provides GUI environment to work as DBA. The Sql Server DBA Technology training includes Database architecture, backup & recovery, security concept, monitoring and storage structure etc.

Course Duration : 120 Hours
Syllabus :Download

Course Objective:

    Learn sql server architecture Installing Oracle and understand architecture
  • Monitoring and optimizing the performance of the database
  • Planning for backup and recovery of database information
  • Creating and maintaining Oracle Database Instances.
  • Creating and managing users.
  • Building and managing Storage Structures.
  • Configuring and managing the Network Environment.
  • Monitoring and troubleshooting the database while ensuring performance.
  • Learning basic backup and recovery techniques
  • Monitor the performance of an instance of the SQL Server Database Engine, Analysis Server, or Integration Services
  • Debug Transact-SQL statements and stored procedures.
  • Analyze performance by identifying slowly executing queries