Session Description

In “SQL Server Administration,” participants will understand system administration for SQL Server. Whether you are a beginner or an experienced professional, this session will provide you with the knowledge and skills needed to effectively administer MS SQL Server and other vendors' databases.  

Session Content

In this session, participants will: 

  • Describe the administrative features of SQL Management Studio, including security, SSIS, and 3rd party transaction tracking software 

  • Identify the process of creating new databases, importing/exporting data, implementing backups, performing maintenance tasks, and conducting error checking 

  • Discuss query creation and scripting to optimize performance and efficiency 

  • Demonstrate the use of SQL Server Management Studio (SSMS) to administer MS SQL Server instances effectively 

  • Illustrate disaster recovery planning, various database backup types, and designing maintenance plans for data integrity