Test theme
Actian Avalanche: Schema Design (self-paced)

Actian Avalanche: Schema Design (self-paced)

Curriculum92 min

  • Objectives 1 min
  • Schemas
  • What is a Schema? 1 min
  • Schema Design 1 min
  • Tables
  • Creating a Table 4 min
  • Activity: Create tables 10 min
  • Design Considerations
  • Data Types
  • Supported and Unsupported Data Types 1 min
  • Choosing Data Types / Lengths - Good Practice 1 min
  • How to: Implement JSON Functionality 3 min
  • Nulls
  • Nulls and NULLable Unique Keys 1 min
  • Constraints
  • Column Constraints 4 min
  • Activity: Constraints 10 min
  • Min/Max Indexes
  • MINMAX Indexes and MINMAX_SAMPLES 2 min
  • Activity: MINMAX index 10 min
  • Data at Rest Encryption
  • Data at Rest Encryption Levels 4 min
  • Activity: Data At Rest Encryption 10 min
  • Column Masking
  • Column Masking 1 min
  • Data Sort Sequence
  • Benefits, Type and Impact of Data Ordering 2 min
  • Activity: Data Ordering 10 min
  • Reinforce your knowledge!
  • Course Quiz 10 min
  • Feedback
  • Take Course Survey 1 min

Curriculum92 min

  • Objectives 1 min
  • Schemas
  • What is a Schema? 1 min
  • Schema Design 1 min
  • Tables
  • Creating a Table 4 min
  • Activity: Create tables 10 min
  • Design Considerations
  • Data Types
  • Supported and Unsupported Data Types 1 min
  • Choosing Data Types / Lengths - Good Practice 1 min
  • How to: Implement JSON Functionality 3 min
  • Nulls
  • Nulls and NULLable Unique Keys 1 min
  • Constraints
  • Column Constraints 4 min
  • Activity: Constraints 10 min
  • Min/Max Indexes
  • MINMAX Indexes and MINMAX_SAMPLES 2 min
  • Activity: MINMAX index 10 min
  • Data at Rest Encryption
  • Data at Rest Encryption Levels 4 min
  • Activity: Data At Rest Encryption 10 min
  • Column Masking
  • Column Masking 1 min
  • Data Sort Sequence
  • Benefits, Type and Impact of Data Ordering 2 min
  • Activity: Data Ordering 10 min
  • Reinforce your knowledge!
  • Course Quiz 10 min
  • Feedback
  • Take Course Survey 1 min