SQL Server 2005/2008/2008 R2 Database Administration Fundamentals

Course Code: SQSDBA
Duration: 5 days
Audience: Would-be system and database administrators.
Prerequisites: At least 6 months experience with a Windows operating system.
Summary: 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
Objectives: 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.
View full outline in PDF formatDetailed Outline Bookmark and Share

Course Schedule

  • 20-24 February
  • 19-23 March
  • 30 April-4 May
  • 28 May-1 June
  • 25-29 June
  • 16-20 July

Price: £1,650+VAT
Venue: London Gatwick

Testimonials

“Very well constructed and executed course...enjoyed thouroughly, learned a lot... had a good time! Thank you!”
M.A., energy company.

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page