SQL Server Administration Fundamentals
Course Summary
Training level | SQL Server Foundation Courses |
Duration | 3 days / 24 Hours |
Delivery method | In Class |
Level | 100 |
Language | Bulgarian/English |
List price | 350 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
Reserving a seat does not imply any obligations for payment