SQL Server Administration

SpiralTrain BV

The course SQL Server Administration from SpiralTrain is designed for individuals who want to learn how to effectively manage and maintain a Microsoft SQL Server database.

Price

from €2,999

Level

Not specified

Kind

Training

Subject

Automation and IT, Training and education

More information and registration at SpiralTrain BV

Description

SQL Server Intro The course SQL Server Administration starts with an overview of SQL Server and its various components, such as the database engine, SQL Server Management Studio, and Transact-SQL. Server Configuration Next attention is paid to configuring the SQL Server instance. The various settings including memory, network protocols and collation are discussed in this respect. Database Configuration Also the creation and configuration of databases, including filegroups, file sizes, and file placement is on the schedule of the course SQL Server Administration. Table partitioning and table compression are covered as well. Indexes Another subject in the course content is which different types of indexes are available in SQL Server and how to create and maintain them for optimal performance. Database Consistency Furthermore the importance of maintaining database consistency is discussed. Different techniques for ensuring the integrity of data in SQL Server like checking and fixing errors, checking consistency and emergency mode are covered.