The course provides you with knowledge and skills to administer and maintain a SQL Server database infrastructure.
The course lasts five days and is instructor-led. It is also useful for those developing applications that retrieve content from SQL Server databases.
Also check out our courses in data, cloud and AI to develop your knowledge in data analytics, cloud computing and artificial intelligence.
After the course, you can:
The course is aimed at those who:
In addition to professional experience, you need to have:
It is an advantage if you have:
This course does not have any associated certification. Each participant who completes the course receives a course certificate.
The course is conducted in collaboration with one of Informator’s partners.
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:
If you participate remotely in a virtual classroom, you need an extra screen to work with the labs via remote desktop (GoToMyPC or LearnOnDemand). The screen should be at least 19 inches with a resolution of at least 1280×1024, with vertical resolution being the most important.
Course overview
41900 kr
5 days
Advanced
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 get an opportunity that suits.
För samtliga utbildningar gäller våra
Allmänna Villkor.
Company-adapted course
Expression of interest