The best preparation for building an end-to-end, analytical warehouse solution with real-time insights.

Modern Data Warehousing and Analytics

Relevant and rigorous training

Our administrator course provides students with a comprehensive understanding of the procedures and techniques necessary to rapidly install, configure, monitor, secure, and manage Incorta.

Experience Builds Confidence

Hands-on, project-based learning

Through instructor-led discussion and interactive project-based labs, students will master Incorta key concepts, terminology and topics for on the job success.

Superheroes Wanted!

Audience prerequisites

Designed to serve the learning goals of database and data warehouse administrators, this course requires experience with bash shell, shell scripting, and SQL.

Although not required, we recommend that students have familiarity Python.

Data Warriors, Champions, and Visionaries

Professional certification for stardom

Incorta Certification establishes your leadership credentials and validates your expertise.

You can achieve Incorta certification by completing this course and by passing a certification exam. With a few clicks, you can easily add your digital certificate to your LinkedIn profiles.

Prerequisites

Incorta 4 Essentials Certification

In order to attend this free virtual training, you must have successfully achieved Incorta 4 Essentials Business User and Analyst Certification.

Curriculum

Course modules

  • 1

    About Fundamentals

    • Course Prerequisites
  • 2

    Details and Downloads

    • Meeting Details

    • BYOL and Software Requirements

    • Verify SSH Access

    • Student EC2 Hosts

    • Video: Session 01

    • Video: Session 02

    • Video: Session 03

    • Video: Session 04
  • 3

    Architecture Fundamentals

    • Architecture Diagram

    • Standalone

    • Cluster Typologies
  • 4

    Cluster Installation

    • Cluster Pre-configuration Requirements

    • LAB: Create an Incorta Cluster
  • 5

    Standalone Installation and Configuration

    • Standalone Pre-configuration Requirements

    • Command Line Installer

    • Silent Installation
  • 6

    Cluster Management Console

    • Incorta Node

    • Clusters

    • Loader Service Configuration

    • Analytics Service Configuration

    • Tenants

    • Cluster Configurations

    • SMTP Configuration

  • 7

    Managing Security

    • Incorta Roles

    • Managing Users and Groups

    • Object Permissions and Functionality

    • Data Encryption

    • SSO and LDAP

    • Runtime Security Filters (Table)

    • LAB: Runtime Security Filters

    • User and Group Setup

    • Reference: System Variables
  • 8

    Data Loading Strategies

    • Full

    • Incremental Refresh

    • Staging (Shared Storage)
  • 9

    Incorta and Apache Spark

    • Spark Configurations

    • Materialized View Properties
  • 10

    Monitoring and Performance Tuning

    • Audit Schema and Dashboards

    • Incorta Metadata Database

    • Inspector Tool

    • Memory Management

    • Troubleshoot with Logs

    • Log File Rotation

    • Monitoring tools

    • Parquet row counts

    • Service Scripts and Ulimit
  • 11

    Administration with the Incorta CLI and TMT

    • Tenant Management Tools

    • Tenant Migration with the TMT

    • CLI Commands

    • Shell Scripts

    • LAB: Export Session Variables using the CLI

    • LAB: Metadata Migration TMT

    • Backup and Restore

    • Back up and Restore Scripts and Files
  • 12

    Wrap up

    • What's Next?

    • Pay it forward!