You want to master the concepts, installation, configuration, administration and maintenance of SQL Server? Then this DBA SQL Server Essential Skills course is for you. This course will teach you the key concepts of SQL Server databases. By the end of the course, you'll be able to understand, administer and maintain SQL Server databases according to best practices.
Objectives
- Understand SQL Server concepts (operation, storage, security, administration)
- Install & configure a GUI or command line instance, following best practices
- Create and configure databases
- Maintain an MSSQL environment: maintenance plan (indexes, data integrity, backups), SQL agent jobs and alerts, error log optimization
- SQL Server prerequisites and best practices
Method
- Presentations, practical exercises, case studies and question-oriented demonstrations
- Discussion and networking during breaks and lunch (included)
Target groups
- This Microsoft SQL Server DBA Essentials course is designed for Database Administrators (DBAs) as well as network, system and application administrators responsible for SQL Server databases or their support.
Prerequisites
- Basic knowledge of Windows Server.
5% discount for SOUG, SwissPUG and DOAG members.