-
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
- Reinforce your knowledge!
-
Course Quiz 10 min
- Feedback
-
Take Course Survey 1 min
Actian Data Platform: Schema Design v2.0 (self-paced)
Explore Data Organization. Learn how data is stored in tables and how to create, partition, define column data types, and implement constraints within a user's schema.
Course Outcome:
You will possess the skills to create the necessary data tables within your Platform Warehouse to store your desired data. Additionally, you will gain insight into table partitioning, valid column data types, and the effective use of constraints to maintain data integrity within the Platform Warehouse.
Course Style:
The style of this course is 'how to' therefore provides a step by step guide for best practice advice and guidance.
Audience:
System or Database Administrators who have a responsibility for maintaining their organisations Platform assets.
Prerequisites:
- You have the appropriate access to Actian Data Platform.
- You have some experience of how to manage and administer corporate database installations.
Supplementary Resources:
|
Product Documentation:
|
|
|
Actian Community:
|
|
|
Software Download:
|