SQL Server DBA Training

← Back to document page

SQL Server DBA Training Andrew Fraser, September 2010, This course is a reduced version of Microsoft s 5 day System Administration for Microsoft SQL. Server course. It focuses on the differences between SQL Server and Oracle and on the main SQL Server tasks a DBA team is likely to have to perform: Installs; Service Access Requests;. Cloning; Backups; Restores; Datafile maintenance. DBA tasks which are out of scope for this course are upgrades and performance tuning. These notes apply to version SQL Server 2008 Release 2. Table of Contents 1. SQL Server Overview ........................................ ........................................ ............................ 2. 2. Installing and Configuring SQL Server ........................................ ........................................ ... 3. 3. Security ........................................ ........................................ ........................................ .......... 9. 4. Managing Database 11. 5. Backup.

SQL Server DBA Training Page 3 of 48 2. Installing and Configuring SQL Server Installation Unlike Oracle, Microsoft do not make their software available for download. It is instead typically supplied in a pack of Microsoft DVDs with licence codes preloaded.

  Training, Server, Sql server dba training