Learning by doing
Trainers with practical experience
Detailed course material
Clear content description
Tailormade content possible
Training that proceeds
The course SQL Server Administration is designed for individuals who want to learn how to effectively manage and maintain a Microsoft SQL Server database. The course covers a range of topics including server and database configuration, indexes, database consistency, security, backup and restore, high availability and performance.
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.
Next attention is paid to configuring the SQL Server instance. The various settings including memory, network protocols and collation are discussed in this respect.
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.
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.
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.
An important subject covered in the course SQL Server Administration are the various security features available in SQL Server, including authentication, authorization, and encryption.
Also how to create and manage backups of an SQL Server databases, as well as how to restore them in case of disaster is a topic.
Then the strategies for ensuring the availability of SQL Server databases, including clustering, log shipping and replication are treated. And also attention is paid to failover and recovery modes.
Finally the techniques for improving the performance of SQL Server databases, including index tuning, query optimization and monitoring performance are discussed.
The course SQL Server Administration is intended for database administrators who need to manage, monitor and support Microsoft SQL Server databases and Microsoft SQL Server servers.
Prior knowledge of the SQL query language and databases is required for participation in the course SQL Server Administration.
The course material is covered on the basis of presentations. Demos clarify the theory and practical exercises ensure that the material well understood.
After successful completion of the course participants receive a certificate SQL Server Administration.
Module 1 : SQL Server Intro
Module 2 : Server Configuration
Module 3 : Database Configuration
SQL Server Editions
Database Engine Service
Data Quality Client
Ports and Firewalls
Master and Model
Hybrid Buffer Pool
Module 4 : Indexes
Module 5 : Database Consistency
Module 6 : SQL Server Security
Primary Key Clustering
Page Verify Option
Master DB Corruption
Corruption of Binaries
Checking for Errors
Database Level Security
Object Level Security
SQL Data Discovery
Module 7 : Backup and Restore
Module 8 : High Availability
Module 9 : Performance
Transaction Log Backup
Restoring a Database
Restoring via T-SQL
Using Management Studio
Cost of Downtime
Automatic Page Repair
SQL Server Metadata
Buffer Cache Usage
Exposing File Stats
Retrieving Perfmon Counters