This comprehensive SQL Server administration course is designed to familiarize you with all aspects of the Microsoft SQL Server database management system. You'll start with installation, choosing installation options and automating your installations. Then you'll learn how to use the various tools (SQL Server Management Studio, Configuration Manager, Transact-SQL). You'll gain a better understanding of database management, security, backup and restore, and database messaging configuration. This training will also enable you to monitor your servers and guide you through high-availability options. You'll also be in a better position to decide on the version of your next SQL migration.
Duration
5 days
Schedule
9h to 16h
Regular fee
$2,395
Preferential fee A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$2,155
Objectives of the training
The main aim of this course is to learn how to manage, administer and understand SQL servers.Targeted audience
This course is suitable for professionals who consider themselves beginners or intermediates and who wish to acquire general expertise in SQL Server database management or for professionals who need to be updated on the latest developments with SQL Server 2022, database administrators, developers, analysts, technicians, operations or network managers, system engineers, professionals in a development, database or network position, as well as Web specialists.Prerequisite
We recommend one of the following prerequisites: Knowledge of basic MS SQL syntax (course BD102); Knowledge of SQL Server usage, database manipulation and SQL language; Basic knowledge of Windows administration; Experience as a database developer.Trainers
Benefits for Participants
- Install SQL Server.
- Administer SQL Server.
- Configure SQL Server.
- Apply a security policy to SQL Server.
- Automate administration tasks.
- Choosing the right SQL version for your migration
- Define a backup and recovery policy.
Course architecture
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
5 days
Schedule
9h to 16h
Regular fee
$2,395
Preferential fee A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$2,155
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote