Curriculum planned

Stage 07 · Distributed Compute & Federated SQL

Trino

A comprehensive Trino course covering federated distributed SQL, catalogs and connectors, lakehouse and relational federation, SQL semantics, query planning, cost-based optimization, pushdown, dynamic filtering, memory and resource governance, fault-tolerant execution, security, observability, Kubernetes operations, plugin development, benchmarking, and production platform design.

Browse planned curriculum Back to all courses

34planned chapters

170reserved lesson paths

Intermediate → Advancedlearning level

Plannedcourse state

Coverage baselineTrino 483 baseline (released July 17, 2026) with current coordinator/worker architecture, connector ecosystem, cost-based and adaptive optimizations, dynamic filtering, object-storage access, OpenTelemetry/OpenMetrics observability, and fault-tolerant execution

Course brief

Build a federated SQL platform by connecting SQL semantics to connector capabilities, query plans, data movement, statistics, memory, resource groups, fault tolerance, and governance—then validate performance with explain plans and production telemetry.

A comprehensive Trino course covering federated distributed SQL, catalogs and connectors, lakehouse and relational federation, SQL semantics, query planning, cost-based optimization, pushdown, dynamic filtering, memory and resource governance, fault-tolerant execution, security, observability, Kubernetes operations, plugin development, benchmarking, and production platform design.

This syllabus deliberately separates foundations, data/model semantics, internals, reliability, security, performance, operations, and production design so advanced material is not compressed into generic catch-all chapters.

By the end

You will be able to

Write advanced Trino SQL across heterogeneous catalogs using complex types, functions, windows, joins, and lakehouse table formats
Explain stages, tasks, splits, pipelines, exchanges, join distribution, statistics, pushdown, dynamic filtering, and adaptive optimization behavior
Design and tune secure multi-tenant clusters using resource groups, memory controls, fault-tolerant execution, exchange managers, and workload isolation
Operate Trino with TLS and modern authentication, access control, secrets, OpenTelemetry/OpenMetrics/JMX, event listeners, graceful shutdown, and Kubernetes
Evaluate connector limitations, benchmark federated workloads, build plugins where necessary, and design a production data-access layer across databases and object storage

Complete planned syllabus

34 chapters · 170 lesson paths.

Every lesson path is reserved now but intentionally not linked until its lesson HTML is actually published. The sequence moves from foundations through advanced implementation, architecture, operations, reliability, security, tuning, and a production capstone.

01

Chapter 1

Trino Foundations: Federated SQL, MPP Query Engines, Workload Fit, Trino 483, and Local Lab Setup

5 lessons

01

Trino Foundations: Federated SQL, MPP Query Engines, Workload Fit, Trino 483, and Local Lab Setup: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter01/Lesson1.html

Planned02

Trino Foundations: Federated SQL, MPP Query Engines, Workload Fit, Trino 483, and Local Lab Setup: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter01/Lesson2.html

Planned03

Trino Foundations: Federated SQL, MPP Query Engines, Workload Fit, Trino 483, and Local Lab Setup: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter01/Lesson3.html

Planned04

Trino Foundations: Federated SQL, MPP Query Engines, Workload Fit, Trino 483, and Local Lab Setup: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter01/Lesson4.html

Planned05

Checkpoint Lab — Trino Foundations: Federated SQL, MPP Query Engines, Workload Fit, Trino 483, and Local Lab Setup: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter01/Lesson5.html

Planned

02

Chapter 2

Cluster Architecture: Coordinator, Workers, Discovery, Node Identity, JVM Runtime, Configuration Files, and Startup Lifecycle

5 lessons

01

Cluster Architecture: Coordinator, Workers, Discovery, Node Identity, JVM Runtime, Configuration Files, and Startup Lifecycle: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter02/Lesson1.html

Planned02

Cluster Architecture: Coordinator, Workers, Discovery, Node Identity, JVM Runtime, Configuration Files, and Startup Lifecycle: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter02/Lesson2.html

Planned03

Cluster Architecture: Coordinator, Workers, Discovery, Node Identity, JVM Runtime, Configuration Files, and Startup Lifecycle: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter02/Lesson3.html

Planned04

Cluster Architecture: Coordinator, Workers, Discovery, Node Identity, JVM Runtime, Configuration Files, and Startup Lifecycle: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter02/Lesson4.html

Planned05

Checkpoint Lab — Cluster Architecture: Coordinator, Workers, Discovery, Node Identity, JVM Runtime, Configuration Files, and Startup Lifecycle: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter02/Lesson5.html

Planned

03

Chapter 3

Clients and Connectivity: Trino CLI, JDBC, Python/DBAPI Ecosystem, BI Tools, Sessions, Prepared Statements, and Connection Properties

5 lessons

01

Clients and Connectivity: Trino CLI, JDBC, Python/DBAPI Ecosystem, BI Tools, Sessions, Prepared Statements, and Connection Properties: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter03/Lesson1.html

Planned02

Clients and Connectivity: Trino CLI, JDBC, Python/DBAPI Ecosystem, BI Tools, Sessions, Prepared Statements, and Connection Properties: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter03/Lesson2.html

Planned03

Clients and Connectivity: Trino CLI, JDBC, Python/DBAPI Ecosystem, BI Tools, Sessions, Prepared Statements, and Connection Properties: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter03/Lesson3.html

Planned04

Clients and Connectivity: Trino CLI, JDBC, Python/DBAPI Ecosystem, BI Tools, Sessions, Prepared Statements, and Connection Properties: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter03/Lesson4.html

Planned05

Checkpoint Lab — Clients and Connectivity: Trino CLI, JDBC, Python/DBAPI Ecosystem, BI Tools, Sessions, Prepared Statements, and Connection Properties: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter03/Lesson5.html

Planned

04

Chapter 4

Trino SQL Fundamentals: Data Types, NULL Semantics, DDL, DML, Transactions, Sessions, and Dialect Differences

5 lessons

01

Trino SQL Fundamentals: Data Types, NULL Semantics, DDL, DML, Transactions, Sessions, and Dialect Differences: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter04/Lesson1.html

Planned02

Trino SQL Fundamentals: Data Types, NULL Semantics, DDL, DML, Transactions, Sessions, and Dialect Differences: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter04/Lesson2.html

Planned03

Trino SQL Fundamentals: Data Types, NULL Semantics, DDL, DML, Transactions, Sessions, and Dialect Differences: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter04/Lesson3.html

Planned04

Trino SQL Fundamentals: Data Types, NULL Semantics, DDL, DML, Transactions, Sessions, and Dialect Differences: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter04/Lesson4.html

Planned05

Checkpoint Lab — Trino SQL Fundamentals: Data Types, NULL Semantics, DDL, DML, Transactions, Sessions, and Dialect Differences: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter04/Lesson5.html

Planned

05

Chapter 5

Expressions and Functions: Strings, Dates, Numerics, Regular Expressions, Conditional Logic, Lambdas, and User-Visible Semantics

5 lessons

01

Expressions and Functions: Strings, Dates, Numerics, Regular Expressions, Conditional Logic, Lambdas, and User-Visible Semantics: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter05/Lesson1.html

Planned02

Expressions and Functions: Strings, Dates, Numerics, Regular Expressions, Conditional Logic, Lambdas, and User-Visible Semantics: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter05/Lesson2.html

Planned03

Expressions and Functions: Strings, Dates, Numerics, Regular Expressions, Conditional Logic, Lambdas, and User-Visible Semantics: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter05/Lesson3.html

Planned04

Expressions and Functions: Strings, Dates, Numerics, Regular Expressions, Conditional Logic, Lambdas, and User-Visible Semantics: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter05/Lesson4.html

Planned05

Checkpoint Lab — Expressions and Functions: Strings, Dates, Numerics, Regular Expressions, Conditional Logic, Lambdas, and User-Visible Semantics: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter05/Lesson5.html

Planned

06

Chapter 6

Analytical SQL: Aggregations, GROUPING SETS, Windows, Ranking, Ordered Aggregates, Set Operations, and Advanced Query Composition

5 lessons

01

Analytical SQL: Aggregations, GROUPING SETS, Windows, Ranking, Ordered Aggregates, Set Operations, and Advanced Query Composition: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter06/Lesson1.html

Planned02

Analytical SQL: Aggregations, GROUPING SETS, Windows, Ranking, Ordered Aggregates, Set Operations, and Advanced Query Composition: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter06/Lesson2.html

Planned03

Analytical SQL: Aggregations, GROUPING SETS, Windows, Ranking, Ordered Aggregates, Set Operations, and Advanced Query Composition: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter06/Lesson3.html

Planned04

Analytical SQL: Aggregations, GROUPING SETS, Windows, Ranking, Ordered Aggregates, Set Operations, and Advanced Query Composition: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter06/Lesson4.html

Planned05

Checkpoint Lab — Analytical SQL: Aggregations, GROUPING SETS, Windows, Ranking, Ordered Aggregates, Set Operations, and Advanced Query Composition: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter06/Lesson5.html

Planned

07

Chapter 7

Complex and Semi-Structured Data: ARRAY, MAP, ROW, JSON, UNNEST, Nested Data, Casting, and Schema-on-Read Patterns

5 lessons

01

Complex and Semi-Structured Data: ARRAY, MAP, ROW, JSON, UNNEST, Nested Data, Casting, and Schema-on-Read Patterns: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter07/Lesson1.html

Planned02

Complex and Semi-Structured Data: ARRAY, MAP, ROW, JSON, UNNEST, Nested Data, Casting, and Schema-on-Read Patterns: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter07/Lesson2.html

Planned03

Complex and Semi-Structured Data: ARRAY, MAP, ROW, JSON, UNNEST, Nested Data, Casting, and Schema-on-Read Patterns: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter07/Lesson3.html

Planned04

Complex and Semi-Structured Data: ARRAY, MAP, ROW, JSON, UNNEST, Nested Data, Casting, and Schema-on-Read Patterns: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter07/Lesson4.html

Planned05

Checkpoint Lab — Complex and Semi-Structured Data: ARRAY, MAP, ROW, JSON, UNNEST, Nested Data, Casting, and Schema-on-Read Patterns: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter07/Lesson5.html

Planned

08

Chapter 8

Catalogs, Connectors, and the SPI: Catalog Boundaries, Metadata, Splits, Pages, Pushdown Contracts, and Connector Capability Discovery

5 lessons

01

Catalogs, Connectors, and the SPI: Catalog Boundaries, Metadata, Splits, Pages, Pushdown Contracts, and Connector Capability Discovery: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter08/Lesson1.html

Planned02

Catalogs, Connectors, and the SPI: Catalog Boundaries, Metadata, Splits, Pages, Pushdown Contracts, and Connector Capability Discovery: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter08/Lesson2.html

Planned03

Catalogs, Connectors, and the SPI: Catalog Boundaries, Metadata, Splits, Pages, Pushdown Contracts, and Connector Capability Discovery: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter08/Lesson3.html

Planned04

Catalogs, Connectors, and the SPI: Catalog Boundaries, Metadata, Splits, Pages, Pushdown Contracts, and Connector Capability Discovery: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter08/Lesson4.html

Planned05

Checkpoint Lab — Catalogs, Connectors, and the SPI: Catalog Boundaries, Metadata, Splits, Pages, Pushdown Contracts, and Connector Capability Discovery: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter08/Lesson5.html

Planned

09

Chapter 9

Hive Connector Deep Dive: Metastore, Partitions, Bucketing, File Formats, Statistics, Object Storage, and Legacy Lake Integration

5 lessons

01

Hive Connector Deep Dive: Metastore, Partitions, Bucketing, File Formats, Statistics, Object Storage, and Legacy Lake Integration: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter09/Lesson1.html

Planned02

Hive Connector Deep Dive: Metastore, Partitions, Bucketing, File Formats, Statistics, Object Storage, and Legacy Lake Integration: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter09/Lesson2.html

Planned03

Hive Connector Deep Dive: Metastore, Partitions, Bucketing, File Formats, Statistics, Object Storage, and Legacy Lake Integration: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter09/Lesson3.html

Planned04

Hive Connector Deep Dive: Metastore, Partitions, Bucketing, File Formats, Statistics, Object Storage, and Legacy Lake Integration: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter09/Lesson4.html

Planned05

Checkpoint Lab — Hive Connector Deep Dive: Metastore, Partitions, Bucketing, File Formats, Statistics, Object Storage, and Legacy Lake Integration: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter09/Lesson5.html

Planned

10

Chapter 10

Lakehouse Connectors: Iceberg, Delta Lake, Hudi, Catalog Choices, Snapshots, Schema Evolution, Partition Evolution, and Writes

5 lessons

01

Lakehouse Connectors: Iceberg, Delta Lake, Hudi, Catalog Choices, Snapshots, Schema Evolution, Partition Evolution, and Writes: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter10/Lesson1.html

Planned02

Lakehouse Connectors: Iceberg, Delta Lake, Hudi, Catalog Choices, Snapshots, Schema Evolution, Partition Evolution, and Writes: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter10/Lesson2.html

Planned03

Lakehouse Connectors: Iceberg, Delta Lake, Hudi, Catalog Choices, Snapshots, Schema Evolution, Partition Evolution, and Writes: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter10/Lesson3.html

Planned04

Lakehouse Connectors: Iceberg, Delta Lake, Hudi, Catalog Choices, Snapshots, Schema Evolution, Partition Evolution, and Writes: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter10/Lesson4.html

Planned05

Checkpoint Lab — Lakehouse Connectors: Iceberg, Delta Lake, Hudi, Catalog Choices, Snapshots, Schema Evolution, Partition Evolution, and Writes: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter10/Lesson5.html

Planned

11

Chapter 11

Relational Federation: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, ClickHouse, JDBC Pushdown, and Source-System Protection

5 lessons

01

Relational Federation: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, ClickHouse, JDBC Pushdown, and Source-System Protection: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter11/Lesson1.html

Planned02

Relational Federation: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, ClickHouse, JDBC Pushdown, and Source-System Protection: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter11/Lesson2.html

Planned03

Relational Federation: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, ClickHouse, JDBC Pushdown, and Source-System Protection: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter11/Lesson3.html

Planned04

Relational Federation: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, ClickHouse, JDBC Pushdown, and Source-System Protection: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter11/Lesson4.html

Planned05

Checkpoint Lab — Relational Federation: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, ClickHouse, JDBC Pushdown, and Source-System Protection: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter11/Lesson5.html

Planned

12

Chapter 12

NoSQL, Search, and Streaming Connectors: MongoDB, Cassandra, Elasticsearch/OpenSearch, Kafka, Redis, and Connector-Specific Tradeoffs

5 lessons

01

NoSQL, Search, and Streaming Connectors: MongoDB, Cassandra, Elasticsearch/OpenSearch, Kafka, Redis, and Connector-Specific Tradeoffs: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter12/Lesson1.html

Planned02

NoSQL, Search, and Streaming Connectors: MongoDB, Cassandra, Elasticsearch/OpenSearch, Kafka, Redis, and Connector-Specific Tradeoffs: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter12/Lesson2.html

Planned03

NoSQL, Search, and Streaming Connectors: MongoDB, Cassandra, Elasticsearch/OpenSearch, Kafka, Redis, and Connector-Specific Tradeoffs: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter12/Lesson3.html

Planned04

NoSQL, Search, and Streaming Connectors: MongoDB, Cassandra, Elasticsearch/OpenSearch, Kafka, Redis, and Connector-Specific Tradeoffs: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter12/Lesson4.html

Planned05

Checkpoint Lab — NoSQL, Search, and Streaming Connectors: MongoDB, Cassandra, Elasticsearch/OpenSearch, Kafka, Redis, and Connector-Specific Tradeoffs: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter12/Lesson5.html

Planned

13

Chapter 13

Object Storage and File Systems: S3-Compatible Storage, Azure, GCS, HDFS, Credentials, Caching, Throughput, and Failure Modes

5 lessons

01

Object Storage and File Systems: S3-Compatible Storage, Azure, GCS, HDFS, Credentials, Caching, Throughput, and Failure Modes: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter13/Lesson1.html

Planned02

Object Storage and File Systems: S3-Compatible Storage, Azure, GCS, HDFS, Credentials, Caching, Throughput, and Failure Modes: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter13/Lesson2.html

Planned03

Object Storage and File Systems: S3-Compatible Storage, Azure, GCS, HDFS, Credentials, Caching, Throughput, and Failure Modes: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter13/Lesson3.html

Planned04

Object Storage and File Systems: S3-Compatible Storage, Azure, GCS, HDFS, Credentials, Caching, Throughput, and Failure Modes: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter13/Lesson4.html

Planned05

Checkpoint Lab — Object Storage and File Systems: S3-Compatible Storage, Azure, GCS, HDFS, Credentials, Caching, Throughput, and Failure Modes: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter13/Lesson5.html

Planned

14

Chapter 14

Metadata and Catalog Services: Hive Metastore, Glue-Style Catalogs, REST Catalogs, Lakehouse Catalogs, Caching, and Consistency Boundaries

5 lessons

01

Metadata and Catalog Services: Hive Metastore, Glue-Style Catalogs, REST Catalogs, Lakehouse Catalogs, Caching, and Consistency Boundaries: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter14/Lesson1.html

Planned02

Metadata and Catalog Services: Hive Metastore, Glue-Style Catalogs, REST Catalogs, Lakehouse Catalogs, Caching, and Consistency Boundaries: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter14/Lesson2.html

Planned03

Metadata and Catalog Services: Hive Metastore, Glue-Style Catalogs, REST Catalogs, Lakehouse Catalogs, Caching, and Consistency Boundaries: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter14/Lesson3.html

Planned04

Metadata and Catalog Services: Hive Metastore, Glue-Style Catalogs, REST Catalogs, Lakehouse Catalogs, Caching, and Consistency Boundaries: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter14/Lesson4.html

Planned05

Checkpoint Lab — Metadata and Catalog Services: Hive Metastore, Glue-Style Catalogs, REST Catalogs, Lakehouse Catalogs, Caching, and Consistency Boundaries: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter14/Lesson5.html

Planned

15

Chapter 15

Query Execution Internals: Logical Plans, Fragments, Stages, Tasks, Splits, Drivers, Operators, Pipelines, Pages, and Exchanges

5 lessons

01

Query Execution Internals: Logical Plans, Fragments, Stages, Tasks, Splits, Drivers, Operators, Pipelines, Pages, and Exchanges: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter15/Lesson1.html

Planned02

Query Execution Internals: Logical Plans, Fragments, Stages, Tasks, Splits, Drivers, Operators, Pipelines, Pages, and Exchanges: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter15/Lesson2.html

Planned03

Query Execution Internals: Logical Plans, Fragments, Stages, Tasks, Splits, Drivers, Operators, Pipelines, Pages, and Exchanges: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter15/Lesson3.html

Planned04

Query Execution Internals: Logical Plans, Fragments, Stages, Tasks, Splits, Drivers, Operators, Pipelines, Pages, and Exchanges: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter15/Lesson4.html

Planned05

Checkpoint Lab — Query Execution Internals: Logical Plans, Fragments, Stages, Tasks, Splits, Drivers, Operators, Pipelines, Pages, and Exchanges: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter15/Lesson5.html

Planned

16

Chapter 16

Statistics and Cost-Based Optimization: Table/Column Statistics, Cardinality, Join Reordering, Cost Models, ANALYZE, and Bad-Estimate Diagnosis

5 lessons

01

Statistics and Cost-Based Optimization: Table/Column Statistics, Cardinality, Join Reordering, Cost Models, ANALYZE, and Bad-Estimate Diagnosis: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter16/Lesson1.html

Planned02

Statistics and Cost-Based Optimization: Table/Column Statistics, Cardinality, Join Reordering, Cost Models, ANALYZE, and Bad-Estimate Diagnosis: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter16/Lesson2.html

Planned03

Statistics and Cost-Based Optimization: Table/Column Statistics, Cardinality, Join Reordering, Cost Models, ANALYZE, and Bad-Estimate Diagnosis: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter16/Lesson3.html

Planned04

Statistics and Cost-Based Optimization: Table/Column Statistics, Cardinality, Join Reordering, Cost Models, ANALYZE, and Bad-Estimate Diagnosis: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter16/Lesson4.html

Planned05

Checkpoint Lab — Statistics and Cost-Based Optimization: Table/Column Statistics, Cardinality, Join Reordering, Cost Models, ANALYZE, and Bad-Estimate Diagnosis: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter16/Lesson5.html

Planned

17

Chapter 17

Predicate, Projection, Aggregation, Join, Top-N, Limit, and Dereference Pushdown: What Executes Remotely and How to Verify It

5 lessons

01

Predicate, Projection, Aggregation, Join, Top-N, Limit, and Dereference Pushdown: What Executes Remotely and How to Verify It: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter17/Lesson1.html

Planned02

Predicate, Projection, Aggregation, Join, Top-N, Limit, and Dereference Pushdown: What Executes Remotely and How to Verify It: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter17/Lesson2.html

Planned03

Predicate, Projection, Aggregation, Join, Top-N, Limit, and Dereference Pushdown: What Executes Remotely and How to Verify It: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter17/Lesson3.html

Planned04

Predicate, Projection, Aggregation, Join, Top-N, Limit, and Dereference Pushdown: What Executes Remotely and How to Verify It: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter17/Lesson4.html

Planned05

Checkpoint Lab — Predicate, Projection, Aggregation, Join, Top-N, Limit, and Dereference Pushdown: What Executes Remotely and How to Verify It: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter17/Lesson5.html

Planned

18

Chapter 18

Dynamic Filtering and Runtime Pruning: Selective Joins, Partition Pruning, Collection Limits, Connector Support, and Diagnostics

5 lessons

01

Dynamic Filtering and Runtime Pruning: Selective Joins, Partition Pruning, Collection Limits, Connector Support, and Diagnostics: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter18/Lesson1.html

Planned02

Dynamic Filtering and Runtime Pruning: Selective Joins, Partition Pruning, Collection Limits, Connector Support, and Diagnostics: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter18/Lesson2.html

Planned03

Dynamic Filtering and Runtime Pruning: Selective Joins, Partition Pruning, Collection Limits, Connector Support, and Diagnostics: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter18/Lesson3.html

Planned04

Dynamic Filtering and Runtime Pruning: Selective Joins, Partition Pruning, Collection Limits, Connector Support, and Diagnostics: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter18/Lesson4.html

Planned05

Checkpoint Lab — Dynamic Filtering and Runtime Pruning: Selective Joins, Partition Pruning, Collection Limits, Connector Support, and Diagnostics: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter18/Lesson5.html

Planned

19

Chapter 19

Join and Exchange Engineering: Broadcast vs Partitioned Joins, Distribution, Skew, Distributed Sort, Spill, and Network-Cost Tradeoffs

5 lessons

01

Join and Exchange Engineering: Broadcast vs Partitioned Joins, Distribution, Skew, Distributed Sort, Spill, and Network-Cost Tradeoffs: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter19/Lesson1.html

Planned02

Join and Exchange Engineering: Broadcast vs Partitioned Joins, Distribution, Skew, Distributed Sort, Spill, and Network-Cost Tradeoffs: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter19/Lesson2.html

Planned03

Join and Exchange Engineering: Broadcast vs Partitioned Joins, Distribution, Skew, Distributed Sort, Spill, and Network-Cost Tradeoffs: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter19/Lesson3.html

Planned04

Join and Exchange Engineering: Broadcast vs Partitioned Joins, Distribution, Skew, Distributed Sort, Spill, and Network-Cost Tradeoffs: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter19/Lesson4.html

Planned05

Checkpoint Lab — Join and Exchange Engineering: Broadcast vs Partitioned Joins, Distribution, Skew, Distributed Sort, Spill, and Network-Cost Tradeoffs: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter19/Lesson5.html

Planned

20

Chapter 20

Memory Management and Spill: User/System/Revocable Memory, Pools, Low-Memory Killers, Spill-to-Disk, OOM Diagnosis, and JVM Constraints

5 lessons

01

Memory Management and Spill: User/System/Revocable Memory, Pools, Low-Memory Killers, Spill-to-Disk, OOM Diagnosis, and JVM Constraints: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter20/Lesson1.html

Planned02

Memory Management and Spill: User/System/Revocable Memory, Pools, Low-Memory Killers, Spill-to-Disk, OOM Diagnosis, and JVM Constraints: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter20/Lesson2.html

Planned03

Memory Management and Spill: User/System/Revocable Memory, Pools, Low-Memory Killers, Spill-to-Disk, OOM Diagnosis, and JVM Constraints: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter20/Lesson3.html

Planned04

Memory Management and Spill: User/System/Revocable Memory, Pools, Low-Memory Killers, Spill-to-Disk, OOM Diagnosis, and JVM Constraints: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter20/Lesson4.html

Planned05

Checkpoint Lab — Memory Management and Spill: User/System/Revocable Memory, Pools, Low-Memory Killers, Spill-to-Disk, OOM Diagnosis, and JVM Constraints: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter20/Lesson5.html

Planned

21

Chapter 21

Concurrency and Workload Governance: Resource Groups, Queues, Limits, Scheduling Policies, Session Property Managers, and Multi-Tenancy

5 lessons

01

Concurrency and Workload Governance: Resource Groups, Queues, Limits, Scheduling Policies, Session Property Managers, and Multi-Tenancy: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter21/Lesson1.html

Planned02

Concurrency and Workload Governance: Resource Groups, Queues, Limits, Scheduling Policies, Session Property Managers, and Multi-Tenancy: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter21/Lesson2.html

Planned03

Concurrency and Workload Governance: Resource Groups, Queues, Limits, Scheduling Policies, Session Property Managers, and Multi-Tenancy: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter21/Lesson3.html

Planned04

Concurrency and Workload Governance: Resource Groups, Queues, Limits, Scheduling Policies, Session Property Managers, and Multi-Tenancy: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter21/Lesson4.html

Planned05

Checkpoint Lab — Concurrency and Workload Governance: Resource Groups, Queues, Limits, Scheduling Policies, Session Property Managers, and Multi-Tenancy: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter21/Lesson5.html

Planned

22

Chapter 22

Fault-Tolerant Execution: QUERY/TASK Retry Policies, Exchange Managers, Object-Storage Spooling, Encryption, Retry Semantics, and Connector Support

5 lessons

01

Fault-Tolerant Execution: QUERY/TASK Retry Policies, Exchange Managers, Object-Storage Spooling, Encryption, Retry Semantics, and Connector Support: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter22/Lesson1.html

Planned02

Fault-Tolerant Execution: QUERY/TASK Retry Policies, Exchange Managers, Object-Storage Spooling, Encryption, Retry Semantics, and Connector Support: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter22/Lesson2.html

Planned03

Fault-Tolerant Execution: QUERY/TASK Retry Policies, Exchange Managers, Object-Storage Spooling, Encryption, Retry Semantics, and Connector Support: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter22/Lesson3.html

Planned04

Fault-Tolerant Execution: QUERY/TASK Retry Policies, Exchange Managers, Object-Storage Spooling, Encryption, Retry Semantics, and Connector Support: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter22/Lesson4.html

Planned05

Checkpoint Lab — Fault-Tolerant Execution: QUERY/TASK Retry Policies, Exchange Managers, Object-Storage Spooling, Encryption, Retry Semantics, and Connector Support: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter22/Lesson5.html

Planned

23

Chapter 23

Performance Tuning: Coordinator Sizing, Worker Sizing, Task Concurrency, Writer Scaling, Partition Counts, Compression, Caching, and Latency/Throughput Tradeoffs

5 lessons

01

Performance Tuning: Coordinator Sizing, Worker Sizing, Task Concurrency, Writer Scaling, Partition Counts, Compression, Caching, and Latency/Throughput Tradeoffs: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter23/Lesson1.html

Planned02

Performance Tuning: Coordinator Sizing, Worker Sizing, Task Concurrency, Writer Scaling, Partition Counts, Compression, Caching, and Latency/Throughput Tradeoffs: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter23/Lesson2.html

Planned03

Performance Tuning: Coordinator Sizing, Worker Sizing, Task Concurrency, Writer Scaling, Partition Counts, Compression, Caching, and Latency/Throughput Tradeoffs: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter23/Lesson3.html

Planned04

Performance Tuning: Coordinator Sizing, Worker Sizing, Task Concurrency, Writer Scaling, Partition Counts, Compression, Caching, and Latency/Throughput Tradeoffs: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter23/Lesson4.html

Planned05

Checkpoint Lab — Performance Tuning: Coordinator Sizing, Worker Sizing, Task Concurrency, Writer Scaling, Partition Counts, Compression, Caching, and Latency/Throughput Tradeoffs: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter23/Lesson5.html

Planned

24

Chapter 24

EXPLAIN, EXPLAIN ANALYZE, and Query Diagnostics: Plans, Costs, Runtime Stats, Blocked Time, Skew, Slow Sources, and Regression Analysis

5 lessons

01

EXPLAIN, EXPLAIN ANALYZE, and Query Diagnostics: Plans, Costs, Runtime Stats, Blocked Time, Skew, Slow Sources, and Regression Analysis: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter24/Lesson1.html

Planned02

EXPLAIN, EXPLAIN ANALYZE, and Query Diagnostics: Plans, Costs, Runtime Stats, Blocked Time, Skew, Slow Sources, and Regression Analysis: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter24/Lesson2.html

Planned03

EXPLAIN, EXPLAIN ANALYZE, and Query Diagnostics: Plans, Costs, Runtime Stats, Blocked Time, Skew, Slow Sources, and Regression Analysis: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter24/Lesson3.html

Planned04

EXPLAIN, EXPLAIN ANALYZE, and Query Diagnostics: Plans, Costs, Runtime Stats, Blocked Time, Skew, Slow Sources, and Regression Analysis: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter24/Lesson4.html

Planned05

Checkpoint Lab — EXPLAIN, EXPLAIN ANALYZE, and Query Diagnostics: Plans, Costs, Runtime Stats, Blocked Time, Skew, Slow Sources, and Regression Analysis: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter24/Lesson5.html

Planned

25

Chapter 25

Authentication and Transport Security: TLS, Password Files, LDAP, OAuth 2.0, JWT, Kerberos, Certificates, Proxies, and Client Trust

5 lessons

01

Authentication and Transport Security: TLS, Password Files, LDAP, OAuth 2.0, JWT, Kerberos, Certificates, Proxies, and Client Trust: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter25/Lesson1.html

Planned02

Authentication and Transport Security: TLS, Password Files, LDAP, OAuth 2.0, JWT, Kerberos, Certificates, Proxies, and Client Trust: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter25/Lesson2.html

Planned03

Authentication and Transport Security: TLS, Password Files, LDAP, OAuth 2.0, JWT, Kerberos, Certificates, Proxies, and Client Trust: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter25/Lesson3.html

Planned04

Authentication and Transport Security: TLS, Password Files, LDAP, OAuth 2.0, JWT, Kerberos, Certificates, Proxies, and Client Trust: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter25/Lesson4.html

Planned05

Checkpoint Lab — Authentication and Transport Security: TLS, Password Files, LDAP, OAuth 2.0, JWT, Kerberos, Certificates, Proxies, and Client Trust: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter25/Lesson5.html

Planned

26

Chapter 26

Authorization and Governance: System/Connector Access Control, File Rules, OPA-Style Policy, Row/Column Controls, Impersonation, and Audit Boundaries

5 lessons

01

Authorization and Governance: System/Connector Access Control, File Rules, OPA-Style Policy, Row/Column Controls, Impersonation, and Audit Boundaries: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter26/Lesson1.html

Planned02

Authorization and Governance: System/Connector Access Control, File Rules, OPA-Style Policy, Row/Column Controls, Impersonation, and Audit Boundaries: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter26/Lesson2.html

Planned03

Authorization and Governance: System/Connector Access Control, File Rules, OPA-Style Policy, Row/Column Controls, Impersonation, and Audit Boundaries: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter26/Lesson3.html

Planned04

Authorization and Governance: System/Connector Access Control, File Rules, OPA-Style Policy, Row/Column Controls, Impersonation, and Audit Boundaries: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter26/Lesson4.html

Planned05

Checkpoint Lab — Authorization and Governance: System/Connector Access Control, File Rules, OPA-Style Policy, Row/Column Controls, Impersonation, and Audit Boundaries: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter26/Lesson5.html

Planned

27

Chapter 27

Secrets and Configuration Management: Environment Separation, Credential Providers, Catalog Secrets, Rotation, Least Privilege, and Configuration Hygiene

5 lessons

01

Secrets and Configuration Management: Environment Separation, Credential Providers, Catalog Secrets, Rotation, Least Privilege, and Configuration Hygiene: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter27/Lesson1.html

Planned02

Secrets and Configuration Management: Environment Separation, Credential Providers, Catalog Secrets, Rotation, Least Privilege, and Configuration Hygiene: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter27/Lesson2.html

Planned03

Secrets and Configuration Management: Environment Separation, Credential Providers, Catalog Secrets, Rotation, Least Privilege, and Configuration Hygiene: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter27/Lesson3.html

Planned04

Secrets and Configuration Management: Environment Separation, Credential Providers, Catalog Secrets, Rotation, Least Privilege, and Configuration Hygiene: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter27/Lesson4.html

Planned05

Checkpoint Lab — Secrets and Configuration Management: Environment Separation, Credential Providers, Catalog Secrets, Rotation, Least Privilege, and Configuration Hygiene: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter27/Lesson5.html

Planned

28

Chapter 28

Observability: Web UI, JMX, OpenMetrics, OpenTelemetry, Logs, Query Events, Event Listeners, Lineage Hooks, Dashboards, and Alerting

5 lessons

01

Observability: Web UI, JMX, OpenMetrics, OpenTelemetry, Logs, Query Events, Event Listeners, Lineage Hooks, Dashboards, and Alerting: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter28/Lesson1.html

Planned02

Observability: Web UI, JMX, OpenMetrics, OpenTelemetry, Logs, Query Events, Event Listeners, Lineage Hooks, Dashboards, and Alerting: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter28/Lesson2.html

Planned03

Observability: Web UI, JMX, OpenMetrics, OpenTelemetry, Logs, Query Events, Event Listeners, Lineage Hooks, Dashboards, and Alerting: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter28/Lesson3.html

Planned04

Observability: Web UI, JMX, OpenMetrics, OpenTelemetry, Logs, Query Events, Event Listeners, Lineage Hooks, Dashboards, and Alerting: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter28/Lesson4.html

Planned05

Checkpoint Lab — Observability: Web UI, JMX, OpenMetrics, OpenTelemetry, Logs, Query Events, Event Listeners, Lineage Hooks, Dashboards, and Alerting: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter28/Lesson5.html

Planned

29

Chapter 29

Deployment and Kubernetes Operations: Packaging, Helm Concepts, Persistent Configuration, Service Discovery, Autoscaling Tradeoffs, Graceful Shutdown, and Rolling Maintenance

5 lessons

01

Deployment and Kubernetes Operations: Packaging, Helm Concepts, Persistent Configuration, Service Discovery, Autoscaling Tradeoffs, Graceful Shutdown, and Rolling Maintenance: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter29/Lesson1.html

Planned02

Deployment and Kubernetes Operations: Packaging, Helm Concepts, Persistent Configuration, Service Discovery, Autoscaling Tradeoffs, Graceful Shutdown, and Rolling Maintenance: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter29/Lesson2.html

Planned03

Deployment and Kubernetes Operations: Packaging, Helm Concepts, Persistent Configuration, Service Discovery, Autoscaling Tradeoffs, Graceful Shutdown, and Rolling Maintenance: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter29/Lesson3.html

Planned04

Deployment and Kubernetes Operations: Packaging, Helm Concepts, Persistent Configuration, Service Discovery, Autoscaling Tradeoffs, Graceful Shutdown, and Rolling Maintenance: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter29/Lesson4.html

Planned05

Checkpoint Lab — Deployment and Kubernetes Operations: Packaging, Helm Concepts, Persistent Configuration, Service Discovery, Autoscaling Tradeoffs, Graceful Shutdown, and Rolling Maintenance: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter29/Lesson5.html

Planned

30

Chapter 30

Multi-Tenant Platform Design: Interactive vs Batch Clusters, Routing, Resource Isolation, SLAs, Admission Control, Cost Attribution, and Noisy-Neighbor Defense

5 lessons

01

Multi-Tenant Platform Design: Interactive vs Batch Clusters, Routing, Resource Isolation, SLAs, Admission Control, Cost Attribution, and Noisy-Neighbor Defense: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter30/Lesson1.html

Planned02

Multi-Tenant Platform Design: Interactive vs Batch Clusters, Routing, Resource Isolation, SLAs, Admission Control, Cost Attribution, and Noisy-Neighbor Defense: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter30/Lesson2.html

Planned03

Multi-Tenant Platform Design: Interactive vs Batch Clusters, Routing, Resource Isolation, SLAs, Admission Control, Cost Attribution, and Noisy-Neighbor Defense: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter30/Lesson3.html

Planned04

Multi-Tenant Platform Design: Interactive vs Batch Clusters, Routing, Resource Isolation, SLAs, Admission Control, Cost Attribution, and Noisy-Neighbor Defense: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter30/Lesson4.html

Planned05

Checkpoint Lab — Multi-Tenant Platform Design: Interactive vs Batch Clusters, Routing, Resource Isolation, SLAs, Admission Control, Cost Attribution, and Noisy-Neighbor Defense: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter30/Lesson5.html

Planned

31

Chapter 31

Extensibility: Custom Connectors, Functions, Event Listeners, Session Property Managers, Plugins, SPI Compatibility, and Testing Extensions

5 lessons

01

Extensibility: Custom Connectors, Functions, Event Listeners, Session Property Managers, Plugins, SPI Compatibility, and Testing Extensions: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter31/Lesson1.html

Planned02

Extensibility: Custom Connectors, Functions, Event Listeners, Session Property Managers, Plugins, SPI Compatibility, and Testing Extensions: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter31/Lesson2.html

Planned03

Extensibility: Custom Connectors, Functions, Event Listeners, Session Property Managers, Plugins, SPI Compatibility, and Testing Extensions: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter31/Lesson3.html

Planned04

Extensibility: Custom Connectors, Functions, Event Listeners, Session Property Managers, Plugins, SPI Compatibility, and Testing Extensions: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter31/Lesson4.html

Planned05

Checkpoint Lab — Extensibility: Custom Connectors, Functions, Event Listeners, Session Property Managers, Plugins, SPI Compatibility, and Testing Extensions: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter31/Lesson5.html

Planned

32

Chapter 32

Testing and Benchmarking: TPC-H/TPC-DS, Representative Data, Connector Benchmarks, Plan Assertions, Fault Injection, and Performance Baselines

5 lessons

01

Testing and Benchmarking: TPC-H/TPC-DS, Representative Data, Connector Benchmarks, Plan Assertions, Fault Injection, and Performance Baselines: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter32/Lesson1.html

Planned02

Testing and Benchmarking: TPC-H/TPC-DS, Representative Data, Connector Benchmarks, Plan Assertions, Fault Injection, and Performance Baselines: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter32/Lesson2.html

Planned03

Testing and Benchmarking: TPC-H/TPC-DS, Representative Data, Connector Benchmarks, Plan Assertions, Fault Injection, and Performance Baselines: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter32/Lesson3.html

Planned04

Testing and Benchmarking: TPC-H/TPC-DS, Representative Data, Connector Benchmarks, Plan Assertions, Fault Injection, and Performance Baselines: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter32/Lesson4.html

Planned05

Checkpoint Lab — Testing and Benchmarking: TPC-H/TPC-DS, Representative Data, Connector Benchmarks, Plan Assertions, Fault Injection, and Performance Baselines: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter32/Lesson5.html

Planned

33

Chapter 33

Upgrades and Compatibility: Trino Release Cadence, Connector/Plugin Compatibility, Configuration Changes, Rolling Strategy, Rollback, and Regression Gates

5 lessons

01

Upgrades and Compatibility: Trino Release Cadence, Connector/Plugin Compatibility, Configuration Changes, Rolling Strategy, Rollback, and Regression Gates: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter33/Lesson1.html

Planned02

Upgrades and Compatibility: Trino Release Cadence, Connector/Plugin Compatibility, Configuration Changes, Rolling Strategy, Rollback, and Regression Gates: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter33/Lesson2.html

Planned03

Upgrades and Compatibility: Trino Release Cadence, Connector/Plugin Compatibility, Configuration Changes, Rolling Strategy, Rollback, and Regression Gates: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter33/Lesson3.html

Planned04

Upgrades and Compatibility: Trino Release Cadence, Connector/Plugin Compatibility, Configuration Changes, Rolling Strategy, Rollback, and Regression Gates: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter33/Lesson4.html

Planned05

Checkpoint Lab — Upgrades and Compatibility: Trino Release Cadence, Connector/Plugin Compatibility, Configuration Changes, Rolling Strategy, Rollback, and Regression Gates: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter33/Lesson5.html

Planned

34

Chapter 34

Production Capstone: Design, Secure, Tune, Observe, Fail, Recover, and Upgrade a Federated Trino Lakehouse-and-Database Query Platform

5 lessons

01

Production Capstone: Design, Secure, Tune, Observe, Fail, Recover, and Upgrade a Federated Trino Lakehouse-and-Database Query Platform: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter34/Lesson1.html

Planned02

Production Capstone: Design, Secure, Tune, Observe, Fail, Recover, and Upgrade a Federated Trino Lakehouse-and-Database Query Platform: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter34/Lesson2.html

Planned03

Production Capstone: Design, Secure, Tune, Observe, Fail, Recover, and Upgrade a Federated Trino Lakehouse-and-Database Query Platform: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter34/Lesson3.html

Planned04

Production Capstone: Design, Secure, Tune, Observe, Fail, Recover, and Upgrade a Federated Trino Lakehouse-and-Database Query Platform: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter34/Lesson4.html

Planned05

Checkpoint Lab — Production Capstone: Design, Secure, Tune, Observe, Fail, Recover, and Upgrade a Federated Trino Lakehouse-and-Database Query Platform: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter34/Lesson5.html

Planned