course overview
download outline
Overview
This five-day instructor-led course provides students who wish to administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
The primary audience for this course is individuals who will administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
Audience
After completing this course, students will be able to:
Prerequisites
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
Essential:
Nice to have:
Outline
Module 1 : SQL Overview
This module introduces the main terms used within the administration of SQL Server instances and discusses the requirements of SQL architecture such as which services are available, and which security options are available.
Lessons:
Module 2: SQL Server Installation
This module is aimed at installing a SQL instance (default or named), selecting the services required and reviewing installation options. The lessons covered include the considerations for installation, configuration of the tempdb, defaults for database files location, and other SQL instance options, unattended installs using the GUI or command line and upgrading SQL Server instances.
Lessons:
Module 3: Working with SQL Databases
This module looks at the tasks that could be undertaken by administrators working with databases both set up and maintaining.
Lessons:
Module 4: Backup and Restore SQL Databases
This module covers all aspects for backup and restore using SQL Server.
Lessons:
Module 5: SQL Server Authentication
This module covers the setup and maintenance of logins and users and connections at the both the instance and database levels. Often SQL queries will be cover multiple instance and database, linked servers are covered.
Lessons:
Module 6: Server and Database Roles
This module covers the creation and maintenance of roles at the server and database level.
Lessons:
Module 7: Database Object Security
This module covers security for objects at the database level such as tables, view, stored procedures, and functions. This topic is usually a collaboration between the administrators and developers.
Lessons:
Module 8: Data Security
This module builds on the object level security of the previous module to protect the security of data from the protection of data within the objects.
Lessons:
Module 9: Automating SQL Server management
This module covers the automation of administration with the SQL Server instance using database mail, jobs, alerts and operators.
Lessons:
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.
Submit an enquiry from any page on this site and let us know you are interested in the requirements box, or simply mention it when we contact you.
All $ prices are in USD unless it’s a NZ or AU date
SPVC = Self Paced Virtual Class
LVC = Live Virtual Class
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.
