This five-day instructor-led course provides students who want to administer and maintain SQL Server databases with the knowledge and skills to administer a SQL Server database infrastructure. In addition, it will be beneficial to people developing applications that deliver content from SQL Server databases.
Partner course
Please note that this is a partner course and therefore not covered by the Informator start guarantee.
After completing this course, students will be able to:
The primary audience for this course is people who will be administering and maintaining SQL Server databases. These individuals have database administration and maintenance as their primary responsibility or work in environments where databases play a key role in their primary job.
In addition to their professional experience, students participating in this training should already have the following technical knowledge:
Significant:
Nice to have:
Virtual classroom
For students participating remotely via a virtual classroom, an additional screen is required for this course to work with remote desktop labs and display training information. A remote desktop will be provided using GoToMyPC or LearnOnDemand.
The additional screen must have a minimum screen size of 19 inches and a minimum resolution of 1280×1024, with the vertical resolution (1024) being the most critical.
If you have any questions, contact our virtual team.
This course has no certification
This course is delivered with Informator’s partner QA
Structure of the course
Module 1: SQL overview
This module introduces the main terms used in SQL Server instance administration and discusses the requirements of the SQL architecture, such as what services are available and what security options are available.
Lessons learned:
Module 2: Installation of SQL Server
This module aims to install a SQL instance (standard or named), select the required services and review the installation options. Lessons covered include installation considerations, configuring tempdb, defaults for database file location and other SQL instance options, unattended installations using the GUI or command line, and upgrading SQL Server instances.
Lessons learned:
Module 3: Working with SQL databases
This module covers the tasks that can be performed by administrators working with databases, both in terms of installation and maintenance.
Lessons learned:
Module 4: Backing up and restoring SQL databases
This module covers all aspects of backup and recovery with SQL Server.
Lessons learned:
Module 5: Authentication of SQL Server
This module covers the setup and maintenance of logins, users and connections at both instance and database level. Often SQL queries will involve multiple instances and databases, linked servers are covered.
Lessons learned:
Module 6: Server and database roles
This module is about how to create and maintain roles at server and database level.
Lessons learned:
Module 7: Security of database objects
This module deals with the security of database-level objects such as tables, views, stored procedures and functions. This topic is usually a collaboration between administrators and developers.
Lessons learned:
Module 8: Data security
This module builds on the object-level security of the previous module to protect data security from the protection of data within the objects.
Lessons learned:
Module 9: Automation of SQL Server management
This module covers the automation of the administration with the SQL Server instance using database records, jobs, alerts and operators.
Lessons learned:
Course Overview
5 days
Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to find a suitable opportunity.
Customized Courses
The course can be adapted from several perspectives:
In interaction with the course leader, we ensure that the course meets your needs.
Send an expression of interest for the training
Send an expression of interest for the training