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.

• 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

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

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English or Dutch.

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.

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.