home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and 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 and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
DB2 for LUW fundamentals course

Intended for

Users and developers who are dealing (directly or indirectly) with DB2 for Linux, UNIX and Windows objects and data.

This fundamentals course can also be interesting as an introduction course for system managers and database administrators who are NOT familiar with DB2 Universal Database.

Background

Knowledge of concepts of relational databases (see course RDBMS concepts) and basic knowledge of SQL (see course SQL fundamentals). You can test yourself to see if you have enough background by printing and filling in the self-tests ( PDF file - 57 KB and PDF file - 56 KB).

Training method

Classroom instruction with exercises.

Course leader

Koen De Backer, Kris Van Thillo.

Duration

3 days.

Schedule

datelanguageplacepriceremarks
14/05/2012NWoerden1335 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

In this the course the participant learns:

  • the set-up of the DB2 for LUW (Linux, UNIX and Windows) product;
  • the use of the user tools: command centre - control centre;
  • the DB2 objects for data storage and manipulation;
  • the simple definition of databases and tables;
  • the client set-up and the catalogue of databases.

Main topics

  • The DB2 for LUW family - overview:
  • single user • server • DB2 Tools: Command Centre, Control Centre, Client Configuration Assistant
  • Data definition:
  • set-up • directories • creation • connect
  • logic and physical objects: tablespaces and containers, extents, tables, indexes, views, udt, trigger, schema, package
  • Application development:
  • embedded SQL
  • Java applications and applets
  • Security and authorisation: authentication and authorisation.
  • Basic utilities: export/import and load utility
  • Concurrency and locking: isolation levels and locking
  • Client/Server set-up and node database cataloging
  • Performance: visual explain