home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
Tous les coursbalkjeGénéralités » Introduction HW & SW » Cycles completsSystèmes d’exploitation » MVS - z/OS » UNIX - Linux - AIX » VMwareBases de données, systèmes transactionnels et middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence et data warehouseDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Les langages de programmation » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesGestion de système » ITILbalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
SQL Server database administration for Oracle DBAs

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 courses Oracle DBA 1 - Core competences and Oracle DBA 2 - Advanced tuning), and be familiar with the Microsoft Windows operating system on which the database will run.

Training method

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

Course leader

Peter ter Braake (TrainSQL).

Duration

4 days.

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 contact ABIS.

Objectives

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.

Main topics

  • Installing and configuring SQL Server 2005
  • 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