SQL Server Administration Fundamentals
Course Summary
Training level | SQL Server Fundamental Courses |
Duration | 5 days (40 hours) |
Delivery method | Virtual Instructor-led Training |
Level | 200 |
Language | Bulgarian/English |
List price | 815 Euro VAT excl. |
Click Tabs for Detailed info
This class will give you an excellent base for successful career as a database administrator. The training is very useful both for beginners and more experienced students to protect and maintain the databases of their organizations more effectively, to react quicker and adequate to all issues, which are database related, and to avoid following some harmful myths and wrong concepts in the field of database administration. The class is practically oriented and contains numerous exercises in order to better absorb the material.
- New specialists in role of DB Administrators/DB Developers
- Professionals working with other technology platforms, DB Specialists coming from versions earlier than SQL Server 2008
- DB Administrators 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
- Understand 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, configure levels of access to object properly and according to the requirements
- Understand encryption subsystems and its components like keys and certificates, as well as configure TDE for a database and restore an encrypted database
- Understand indexes, their structure, types and use cases as well as how to check their health status and maintain them
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 DBCC CHECKDB
Module 8. Maintenance and Automation of administrative tasks
Module 9. Monitoring and troubleshooting basics and case scenarios
Next planned dates:
Trainer: Magi Naumova

RESERVE YOUR SEAT

You have a question or you want to book now? Feel free to contact Vili Koleva – Training Manager
E: vili.koleva@inspirit.bg
M: 0885 113 442