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.
Objectives
The main aim of this course is to learn how to manage, administer and understand SQL servers.
Is it for you ?
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.
Your benefits
Content
SQL Server Overview and Installation
- Overview and architecture of Microsoft MS SQL Server.
- What's new in SQL 2022.
- Important pre-installation information.
- Planning the installation of MS SQL Server 2022.
- SQL Server configuration and optimization
- SQL Server 2022 configuration and optimization.
See more + / -
Configuring system and user databases.
- Adjusting efficient resources for our server.
- maxDOP and cost threshold for parallelism.
- Optimizing tempDB.
- Data files and logs (MDF, NDF and LDF).
- Using file groups to boost SQL server performance.
- Optimized memory tables and partitioning.
- Sound transaction log management to avoid filling up our disk.
- The benefits of using the full-text search service.
Administration tasks
- DBA tasks.
- Administration tools and SQL Server components.
- Executing and automating administrative and scheduled tasks.
- Migration to MS SQL Server 2022 and managing database compatibility.
- Preparing your SQL Servers for migration to the cloud.
Security and encryption
- How to manage access, security and permissions.
- Securing connections and sessions.
- Different authentication modes.
- Roles: server roles, database roles, user-created roles, application roles.
- Assigning privileges (Grant, Revoke, Deny).
- Database auditing and the creation of auditable events.
- Use of Dynamic Data Masking.
Backups and restores
- Different types of backup (full, differential, transaction log).
- Different recovery modes.
- Creating a database backup and restore strategy.
- Simulation of a major data loss incident.
- How to restore without data loss.
- Optimizing storage with backup compression.
Monitoring and performance
- Setting up a maintenance plan using best practices.
- Using eXtended Events (XEvents) to track usage against its predecessor the profiler.
- Use the Query Store to monitor server performance.
- Understand and manage your scheduled tasks securely.
- Manage and configure alerts and database mail.
- Monitor and optimize performance and activity.
- Reading the execution plan.
- Using the performance analyzer with perfmon.
- Defining different index types.
- Managing and optimizing indexes and statistics.
Complementary tools & high availability
- Implementing replication.
- Setting up your databases in high-availability mode with AlwaysOn.
- Overview of an integration project (SSIS).
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote