-
Objectives 1 min
- Schemas
-
What is a Schema? 1 min
-
Schema Design 2 min
- Tables
-
Creating a Table 4 min
-
Activity: Create tables 10 min
-
Table Partitioning 3 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 4 min
- Nulls
-
Nulls and NULLable Unique Keys 2 min
- Constraints
-
Column Constraints 5 min
-
Activity: Constraints 10 min
- Min/Max Indexes
-
MINMAX Indexes and MINMAX_SAMPLES 3 min
-
Activity: MINMAX index 10 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
Avalanche Cloud Data Platform Architect: Schema Design & Indexing
Data is held in Tables and tables are created within a users schema. In this course we describe how to create tables, partition tables, column data types and how to apply constraints.
|
At the end of this course you will:
|
|
You will have the knowledge and know-how to create the data tables needed to store the data within your Actian Avalanche Platform. Additionally, you will be familiar with table partitioning, valid column data types, and the use of constraints to ensure valid data within the Actian Avalanche Platform.
|
|
Course Style:
|
|
The content is broken up into numerous lessons, which you are able to navigate as you wish; however, the course is not considered complete until all content has been viewed at least once. Each lesson presents a specific topic in an informative and how-to style.
|
|
Audience:
|
|
For architects who have a responsibility for designing solutions using the Actian Avalanche Platform.
|
|
Prerequisites:
|
|
The course assumes that you already have experience as a database/warehouse architect.
|
|
Resource Links:
|
|
Software Download: https://esd.actian.com/
Actian Community: https://communities.actian.com
Documentation: https://docs.actian.com/
|