SQL Server 2005 Database Administration Fundamentals
Course
In Gatwick
Description
-
Type
Course
-
Location
Gatwick
-
Duration
5 Days
Upon completion of this presentation, the delegate should have an intimate understanding of the SQL Server DB engine per the 'Core Topics' in the detailed outline. Suitable for: Would-be system and database administrators.
Facilities
Location
Start date
Start date
About this course
At least 6 months experience with a Windows operating system.
Reviews
Course programme
After discussing relational database design, theories and practices, this presentation elaborates on the SQL Server database engine in terms of its facilities related to:
- Architecture
- Configuration
- DB vs. DB files
- Logging and recovery of transactions
- Tables and indexes
- SQL queries
- Locking and concurrency
- Security
- Data replication
- DB backup/recovery
- DB performance issues
- Troubleshooting
- And the like
SQL Server 2005 Database Administration Fundamentals