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; and basic performance tuning.
- SQL Server overview
- Installing and Configuring SQL Server
- Managing Database Files
- Automating Administrative Tasks with Jobs and Alerts
- Transferring Data with SSIS
- Monitoring Tools
- Maintenance Plans
- High Availability
- Appendix – List of Differences between SQL Server and Oracle
These notes apply to version SQL Server 2012 – an older version of the course for SQL Server 2008R2 is here (pdf).