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.
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
Essential:
Nice to have:
Virtual Classroom
For learners attending remotely via any virtual classroom, an additional screen is required for this course to work through remote desktop labs and view training information. A remote Desktop will be provided using GoToMyPC or LearnOnDemand.
The additional screen must have a minimum screen size of 19 inch and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.
If you have questions,contact our Virtual team.
After completing this course, students will be able to:
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:
Join our public courses in our Hong Kong facilities. Private class trainings will be organized at the location of your preference, according to your schedule.