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.

Prijs

vanaf € 2.999

Niveau

Niet opgegeven

Soort

Training

Thema

Automatisering en ICT, Opleiden en onderwijs

Meer informatie en aanmelden bij SpiralTrain BV

Beschrijving

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.