home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
C
Tous les coursbalkjeGénéralités » Introduction HW & SW » Soft skills » Cycles completsSystèmes d’exploitation » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad et iPhone iOSBases de données et middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data et analyticsDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Agile et Scrum » Les langages de programmation » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesGestion de système » ITIL » SecuritybalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
SQL Server database administration for DB2 DBAs

Objectives

This four-day course provides students with DB2 for LUW 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 DB2 for LUW DBA to map, compare, and contrast the features of the DB2 for LUW database management system to those offered by SQL Server.

At the end of this course, students:

  • will be able to compare the DB2 for LUW and the SQL Server architecture;
  • will understand the major differences between both RDBMS implementations;
  • will extend their existing competencies as DB2 for LUW 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 and 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
 

Intended for

This course is intended for experienced DB2 for LUW 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 shoud have thorough DB2 for LUW experience (see course DB2 for LUW DBA - Core competences) 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

Il n'y a pas de sessions publiques a ce moment. Nous organisons volontièrement un cours en entreprise ou une session publique supplémentaire (en cas d'un nombre suffisant de participants). Intéressé ? Veuillez contacter ABIS.

Reviews

     
prima, duidelijke uitleg van Peter, dank daarvoor (, )
     
iets meer praktijk misschien wel leerzamer (, )
     
volgens mij mag deze cursus wel een dagje langer duren, zodat er meer tijd is voor oefeningen (, )
     
goed, docent heeft ook praktijkervaring als consultant en deelt deze. Ondersteunt goed bij de oefeningen (, )