DW522G IBM PureData System for Analytics for Developers and Administrators

Overnet Education
A Segrate

2.200 
+IVA
Vuoi parlare del corso con un consulente?
Confronta questo corso con altri simili
Leggi tutto

Informazione importanti

  • Corso
  • Segrate
  • Durata:
    5 Giorni
Descrizione

A continuazione troverai il programma di questo corso disegnato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti.
This course is the combination of IBM PureData System for Analytics Usage (DW503) and IBM PureData System for Analytics advanced Concepts (DW512) This course will teach participants database administration for the IBM PureData System for Analytics appliances. This course is designed to give the participant an overview of the IBM PureData System for Analytics architecture and provide a working knowledge and understanding of the Netezza database features and best practices. This course teaches participants advanced database administration skills for the IBM PureData System for Analytics Advanced Concepts System. This course is designed to give participants a working knowledge and understanding on IBM PureData System for Analytics internals to optimize IBM PureData System for Analytics performance and tune system parameters. This course provides an overview of IBM PureData System for Analytics administration and analysis.

Informazione importanti
Sedi

Dove e quando

Inizio Luogo
Consultare
Segrate
Via Cassanese, 224, Palazzo Mantegna, Scala A, 20090, Milano, Italia
Visualizza mappa

Programma

Il centro presenta a continuazione il programma pensato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti. Nel corso della formazione si alterneranno differenti moduli che ti permetteranno di acquisire le conoscenze sulle differenti tematiche proposte. Inscriviti per poter accedere alle seguenti materie.


  • Data warehouse overview
  • Architecture
  • Connecting to the IBM PureData System for Analytics host
  • Managing user access to the IBM PureData System for Analytics database
  • Administration tools
  • Databases and tables and schemas
  • Distributions
  • Loading and unloading tables
  • ODBC, JDBC, OLEDB client connectivity
  • Optimizer and query plans
  • Zone maps and Clustered Base Tables (CBT)
  • Materialized views
  • Generate statistics
  • Cross-database access
  • Transactions
  • GROOM
  • Stored procedures
  • High availability architecture
  • DBOS internals and system log files
  • nzsql and scripting
  • nzevents and event processing
  • Analyzing plan files
  • Analyzing and optimizing query performance
  • Workload management
  • System management
  • Configuring query history
  • Backup and restore
  • Security including authenticating users with LDAP, SSL

Dotazione:
Each participant will have a station set up with operating systems and software needed for the exercises.


Confronta questo corso con altri simili
Leggi tutto