DB2 10 for LUW: Basic Administration for Linux and Windows

Corso

A Milano

Prezzo da consultare

Chiama il centro

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

Descrizione

  • Tipologia

    Corso

  • Luogo

    Milano

  • Inizio

    Scegli data

Prerequisiti
You should be able to:
Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
Discuss basic relational database concepts and objects such as tables, indexes, views, and join
These skills can be developed by taking:
OS Training:
AIX 5L Basics
Linux Basics and Administration
Windows Systems Administration
Or by having equivalent HP-UX or Solaris administration experience
DB2 SQL Workshop
DB2 Fundamentals
Target del corso
This intermediate course is for system administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.

Sedi e date

Luogo

Inizio del corso

Milano
Visualizza mappa
viale Piero e Alberto Pirelli 6, 20126

Inizio del corso

Scegli dataIscrizioni aperte

Domande e risposte

Aggiungi la tua domanda

I nostri consulenti e altri utenti potranno risponderti

Chi vuoi che ti risponda?

Inserisci i tuoi dati per ricevere una risposta

Pubblicheremo solo il tuo nome e la domanda

Opinioni

Materie

  • Security
  • Windows
  • SQL
  • Linux

Programma

dettagliati del corso
Overview of DB2 on Linux, UNIX and Windows
Command Line Processor (CLP) and GUI usage
The DB2 environment
Creating databases and data placement
Creating database objects
Moving data
Backup and recovery
Database Maintenance, Monitoring, and Problem Determination
Locking and concurrency
Security
Agenda
Day 1
Welcome
Unit 1: Overview of DB2 on Linux, UNIX and Windows
Unit 2: Command Line Processor (CLP) and GUI usage
Unit 3: The DB2 Database Manager Instance
Exercise 1: Create a New DB2 Instance
Unit 4: Creating databases and data placement
Exercise 2: Creating databases and data placement
Day 2
Unit 5: Creating database objects
Exercise 3: Create objects
Unit 6: Moving data
Exercise 4: Moving data
Day 3
Unit 7: Backup and recovery
Exercise 5: Backup and recovery
Unit 8: Database Maintenance, Monitoring, and Problem Determination
Exercise 6: Using DB2 Tools for Performance
Day 4
Unit 7: Locking and concurrency
Exercise 7: Investigating DB2 Locking
Unit 8: Security
Exercise 8: Database Security

Chiama il centro

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

DB2 10 for LUW: Basic Administration for Linux and Windows

Prezzo da consultare