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

    Welcome! Meeting, BYOL, and Software Requirements

    • Welcome

    • BYOL and Software Requirements

    • Verify SSH Access

    • Access Your EC2 Host

    • Video: Session 01

    • Video: Session 02

    • Video: Session 03

    • Video: Session 04
  • 3

    Architecture Fundamentals

    • Architecture Diagram

    • Cluster Typologies
  • 4

    Cluster Installation

    • Host Requirements and Compatibility Matrix

    • Linux Settings

    • Command Line Installer

    • Silent Installation

    • LAB: Install and Create an Incorta 5.1 Cluster
  • 5

    Cluster Management Console

    • Clusters

    • Incorta Node

    • Loader Service Configuration

    • Analytics Service Configuration

    • Cluster Configurations - Server Configurations

    • Cluster Configurations - Default Tenant Configurations

    • Spark Configurations

    • Materialized View Properties
  • 6

    Managing Security

    • Authentication

    • Authorization and Access

    • Users and Groups

    • Runtime Security Filters.

    • LAB: Runtime Security Filters

    • Reference: System Variables
  • 7

    Data Loading Strategies

    • Full

    • Incremental

    • Staging
  • 8

    Monitoring and Performance Tuning

    • Audit Schema and Dashboards

    • Incorta Metadata Database

    • Inspector Tool

    • Troubleshoot with Logs

    • Log File Rotation

    • Parquet row counts

    • Service Scripts

    • Monitoring tools
  • 9

    Administration with the Incorta CLI and TMT

    • Tenant Management Tools

    • CLI Commands

    • Incorta CLI shell scripts

    • LAB: Export Session Variables using the CLI

    • LAB: Metadata Migration TMT

    • Backup and Restore

    • Back up and Restore Scripts and Files
  • 10

    Certification Exam

    • Instructions

    • Certification Exam
  • 11

    Wrap up

    • What's Next?

    • Pay it forward!

Your Instructor

Principal Technical Instructor

John Nadasky

For over 25 years, John has been an Information Technology professional, mostly as an Oracle database administrator specializing in performance analysis. At NetApp, he specialized in enterprise storage. While expanding his industry and product knowledge, John became a technical instructor. For the past eight years, he conducted virtual and in-person training mostly focusing on NetApp’s storage, performance and analytics products.

John is a graduate from Pace University in New York with a bachelor’s degree in business administration and master’s degree in information systems. Before becoming a part time online adjunct professor with Southern New Hampshire University, John was an adjunct professor with the University of Phoenix. For nearly twenty years, John has been an online IT professor.

Originally from New Jersey, John lives just outside Raleigh, North Carolina, with his wife, three sons, and two Labrador retrievers. When not working, John enjoys spending time with family and friends, taking walks with his dogs, and watching movies and football.