Test theme
Actian Avalanche: Data Manipulation (self-paced)

Actian Avalanche: Data Manipulation (self-paced)

Curriculum107 min

  • Objectives 1 min
  • Client Runtime CLI and Avalanche Query Editor
  • Client Runtime CLI and Query Editor 2 min
  • How to: Install and Connect to the Linux CLI to Actian Avalanche 4 min
  • Avalanche Architecture Overview
  • Avalanche Architecture Overview 1 min
  • PDT and Query Working Memory 3 min
  • Bulk and Batch Updates
  • Batch Updates 5 min
  • Query Working Memory 3 min
  • Force Propagation 1 min
  • Bulk Updates 5 min
  • Batch or Bulk? 5 min
  • Activity: Batch, Bulk Operations 10 min
  • Database Procedures
  • Database Procedures 2 min
  • Statements Supported in Database Procedures 1 min
  • Scalar UDFs 1 min
  • Secondary Indexes
  • Indexing 4 min
  • Is Indexing Needed? 1 min
  • Activity: Secondary Index 8 min
  • Query Optimizer
  • Query Optimizer 1 min
  • Create/Drop Statistics 1 min
  • Auto Statistics 3 min
  • Optimizer Statistics 1 min
  • Activity: Query Optimizer 10 min
  • Query Execution Plans
  • Query Execution Plans 3 min
  • A Typical QEP 2 min
  • Activity: QEPs 10 min
  • Reinforce your knowledge!
  • Course Quiz 10 min
  • Feedback
  • Take Course Survey 1 min

Curriculum107 min

  • Objectives 1 min
  • Client Runtime CLI and Avalanche Query Editor
  • Client Runtime CLI and Query Editor 2 min
  • How to: Install and Connect to the Linux CLI to Actian Avalanche 4 min
  • Avalanche Architecture Overview
  • Avalanche Architecture Overview 1 min
  • PDT and Query Working Memory 3 min
  • Bulk and Batch Updates
  • Batch Updates 5 min
  • Query Working Memory 3 min
  • Force Propagation 1 min
  • Bulk Updates 5 min
  • Batch or Bulk? 5 min
  • Activity: Batch, Bulk Operations 10 min
  • Database Procedures
  • Database Procedures 2 min
  • Statements Supported in Database Procedures 1 min
  • Scalar UDFs 1 min
  • Secondary Indexes
  • Indexing 4 min
  • Is Indexing Needed? 1 min
  • Activity: Secondary Index 8 min
  • Query Optimizer
  • Query Optimizer 1 min
  • Create/Drop Statistics 1 min
  • Auto Statistics 3 min
  • Optimizer Statistics 1 min
  • Activity: Query Optimizer 10 min
  • Query Execution Plans
  • Query Execution Plans 3 min
  • A Typical QEP 2 min
  • Activity: QEPs 10 min
  • Reinforce your knowledge!
  • Course Quiz 10 min
  • Feedback
  • Take Course Survey 1 min