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