Interested in a private company training? Request it here.
This module introduces SQL Server in general, and the main tools administrators will use, such as Management Studio, SQLCMD and the SQL Server configuration manager.
Lots of decisions need to be made when installing SQL Server: Which components to install, the collation to use, ... . This module walks you through the different options and explains the consequences of the choices made.
A SQL Server database consists of data files, a log file and optional filestream folders. In this module you will learn how SQL Server stores its data in these files, and how to manage and optimize the storage.
Disaster recovery is an essential part of a database administrator's job. In this module the backups are discussed. SQL Server supports many different types of backups, each having its advantages and disadvantages.
From a single page over a file till the complete database: SQL Server offers different types of restore.
If you need to load large amounts of data from other systems, this module can help you identify the best options for doing so. Not only does it discuss different techniques (SSIS, BCP, ...) but it also provides tricks to improve the performance of these data loads.
SQL Server is not a black box, there are many ways to figure out what is happening inside your server. Monitoring your SQL Server becomes an essential skill if you want to keep your SQL Server in good shape.
The SQL Server Profiler is a tool that is frequently used to monitor which actions are executed on a SQL Server. From finding resource-heavy queries till troubleshooting locking issues: the Profiler can be used for all these things.
SQL Server security is rather advanced. Not only does it cover data access, but also permissions to create databases, backups etc.
Who will watch the watchmen? Database administrators have permissions to access any part of a SQL Server database. How can a company then guarantee that DBAs didn't misuse their permissions? This module shows two possible solutions to this dilemma: Auditing and Encryption.
Lots of things need to be done to keep a SQL Server in good shape. This module discusses the most important ones and shows how to automate these maintenance tasks.
Automation can go beyond the maintenance plans. The last two module explain all the options of the SQL Server Agent, from scheduled jobs over database mail till responding to specific events.
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2022 (or earlier) database. The course focuses on teaching individuals how to use SQL Server product features and tools related to maintaining a database.
The primary audience for this course is individuals who 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.
The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.