SQL Server Administration Fundamentals

Course Summary

Training levelSQL Server Foundation Courses
Duration5 days / 40 Hours
Delivery methodIn Class
List price750 Euro VAT Excl.

Click Tabs for Detailed info

SQL Server Fundamentals courses give you an excellent base for successful career as administrator or data base developer. Their practical purpose, use of scenarios of working practice will help both the beginners, as well as the more experienced students to protect in a better way the data of their organizations, to react quicker and adequate to all issues, which are data base related, and to avoid following some harmful myths and wrong concepts in administration and data base development.

  • New specialists in role of DBAs/Devs;
  • Professionals working with other technology platforms
  • DB Specialists coming from versions earlier than SQL Server 2008
  • DBA who are willing to fill the gaps in their knowledge and build a good understanding of SQL Server product
  • Plan and implement pre-deployment steps for SQL Server deployment
  • Install and configure SQL Server instances and databases
  • Understand main SQL Server processes as logging, recovery, checkpoint, page allocations, etc
  • Test and optimize the I/O subsystem for SQL Server workload
  • Uderstand the structure of of the database and the transaction log file in order to configure and optimize for specific workload
  • Understand the role of system databases and especially the TempDB, how it is used and how to isolate its issues and configure properly
  • Understand and configure the SQL Server security subsystem, to configure levels of access to object properly and according to the requirements
  • To understand encryption subsystems and its components like keys and certificates, as well as configure TDE for a database and restore an encrypted database
  • To understand indexes, their structure, types and use cases as well as how to check their health status and maintain them
  • To understand statistics and their importance for queries as well as their maintenance requirements
  • To understand in details the backup and restore and to plan and implement appropriate backup plans for databases
  • Restore and recover databases with minimal data loss in case of corruption
  • Know how to react in case of system failure in order to bring the system back with minimal recovery time and data loss
  • Understand how the transactions work, what are isolation levels, locking architecture and types in order to find and isolate blocking problems and recommend proper solution
  • Monitor, find and isolate performance problems using the right tools, make proper troubleshooting for most common cases and know how to find information for other not well known cases

Module 1: SQL Server Overview and Components, Management Tools

Module 2: Database Fundamentals

Module 3: Logging and the Transaction Log

Module 4: SQL Server Installation and Configurations

Module 5: Foundation of SQL Server Security Subsystem

Module 6: SQL Server Backup and Restore

Module 7: Index Fundamentals and CHECKDB

Module 8: Maintenance and Automation of administrative tasks

Module 9: Monitoring and troubleshooting basics and case scenarios

Next planned dates:

Trainer: Rozalina Zaharieva


Reserve your seat

Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date