SQL Server database administration for Oracle DBAs

This four-day course provides students with Oracle DBA knowledge and skills all expertise required to be able to setup and manage a Microsoft SQL Server system. This interactive course provides a quick start for the Oracle DBA to map, compare, and contrast the properties and features of an Oracle database system to those of a SQL Server database system.

At the end of this course, students:

  • will be able to compare the Oracle and SQL Server architecture;
  • will understand the major differences between both RDBMS implementations;
  • will extend their existing competencies as Oracle DBAs to SQL Server - they will be able to manage the SQL Server system, databases, and users, manage database files by backing up or migrating to other systems; define and implement monitoring and tuning solutions for the SQL Server system.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

This course is intended for experienced Oracle database administrators (DBAs) who work in a multi-vendor database environment, requiring the skills to begin supporting and maintaining a SQL Server database.

Background

Before attending this course, participants should have thorough Oracle DBA experience (see course Oracle DBA 1 - Core competences), and be familiar with the Microsoft Windows operating system on which the database will run.

Main topics

  • Installing and configuring SQL Server
  • SQL Server Overview - Instance and Database architecture - Data Dictionary - Memory and Process architecture
  • Creating Databases
  • Database Architecture - Storage options (Files and Filegroups) - Schema objects - Database options
  • Backup and Restore
  • Security
  • Logins en users - Permissions - Encryption
  • Performance
  • Indexing - Read consistency (locking, blocking en isolation levels) - Monitoring - Tools
  • Database tuning
  • Import and Export
  • Bcp - Bulk Insert - Import/export wizard - Introduction in Integration Services
  • Automating SQL Server
  • Maintenance plans - SQL Server Agent - Jobs, Alerts, Operators
  • Availability
  • Log shipping - Mirroring - Clustering - (Intro in) Replication

Training method

Class training alternated with focus on exercises. Participant interaction and intervention is actively encouraged.

Duration

4 days.

Course leader

Peter ter Braake (TrainSQL).


SESSION INFO AND ENROLMENT