-
Course Objective
- Data Manipulation Tools
-
Learning Section Objective
-
Platform Query Editor 7 min
-
Using ISQL and SQL on Windows 7 min
-
Using ISQL and SQL on Linux 7 min
- Actian Data Platform Overview
-
Actian Data Platform Overview 1 min
-
PDT and Query Working Memory 3 min
- Bulk and Batch Updates
-
Batch Updates 5 min
-
Query Working Memory 4 min
-
Force Propagation 1 min
-
Bulk Updates 6 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
- Indexes
-
Indexing 2 min
-
Is Indexing Needed? 2 min
-
Activity: Create an Index 3 min
- Query Optimizer
-
Query Optimizer 2 min
-
Create/Drop Statistics 2 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 3 min
-
Activity: QEPs 10 min
- Reinforce your knowledge!
-
Course Quiz 10 min
- Feedback
-
Take Course Survey 1 min
Actian Platform Warehouse: Data Manipulation v2.0 (self-paced)
Explore best practices for updating data within Platform Warehouse tables, optimizing query performance with statistics, and leveraging inbuilt query execution plans to ensure efficient queries.
Course Outcome:
You will know how to use database procedures to implement bulk or batch updates, how to maximise query execution efficiency using statistics, how to take advantage of secondary indexes, and how to use the integrated query execution plan to track the effectiveness of individual queries.
Course Style:
The style of this course is 'how to' therefore provides a step by step guide on effectively utilizing database procedures.
Audience:
System or Database Administrators who have a responsibility for maintaining their organization's Platform assets.
Prerequisites:
- You have been granted access to the Actian Data Platform administration portal.
- You have some experience of how to manage and administer corporate database installations.
Supplementary Resources:
|
Product Documentation:
|
|
|
Actian Community:
|
|
|
Software Download:
|