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

  • 2

    Welcome! Zoom, BYOL, and Software Requirements

    • Welcome!

    • Zoom Meeting | January 19 9:00 AM - 11:30 AM PST

    • BYOL and Software Requirements

    • Verify SSH Access

  • 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

    • SSO and LDAP

    • Runtime Security Filters (Table)

    • User and Group Setup

    • LAB: Runtime Security Filters

    • 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

    • Troubleshoot with Logs

    • Log File Rotation

    • Parquet row counts

    • Service Scripts and Ulimit

  • 11

    Administration with the Incorta CLI and TMT

    • Tenant Management Tools

    • 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!

Your Instructors

Both John and Seth will be your guides.

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.

Director of Customer Enablement

Seth Luersen

As Director of Customer Enablement, Seth is responsible for learn.incorta.com and docs.incorta.com.

Seth started his career as a Reports Developer at Microsoft and led a business intelligence and decision support team. Seth now specializes in creating professional training and certification programs for growth startups such as Incorta.

With over 15 years of experience, he is a seasoned professional trainer, teacher, and curriculum developer. Seth holds numerous professional credentials: Sitecore Certified Developer, Administrator, and Architect; Microsoft SQL Server Certified Database Developer and Administrator; MemSQL Certified Administrator and Developer; and Incorta Certified Developer and Administrator. He lives in the Bay Area with his wife and two boys, Jake and Luke.

Please connect with Seth directly via email or via LinkedIn.