Welcome to CrateDB Academy

This is a learning hub dedicated to empowering data enthusiasts with the tools and knowledge to harness the power of CrateDB.

Whether you're a beginner or an experienced professional, our comprehensive program is designed to provide you with the skills to start your first project or advance further with CrateDB.

  • Simon Prickett from the CrateDB Academy explains Common Table Expressions
  • CrateDB Advanced Time Series Certificate

CrateDB Fundamentals

Up and Running with CrateDB

Lesson 1: What is CrateDB?
Lesson 2: Getting Started with CrateDB Cloud
Lesson 3: Getting Started with Docker
Lesson 4:
Installing the Crash CLI
Lesson 5:
Loading the Dataset
Lesson 6:
Hands-on: Your First CrateDB Cluster
Lesson 7:
Querying the Sample Data

Why CrateDB

Lesson 8: Benefits of a Multi-Model Database
Lesson 9:
Example Use Cases

Data Modelling with CrateDB

Lesson 10: Data Modelling: Overview
Lesson 11:
Primitive Data Types
Lesson 12:
Working with Time Series Data
Lesson 13:
Hands-on: Time Series Data
Lesson 14:
Document Data
Lesson 15: Hands-on Document Data
Lesson 16: Vector Similarity Search
Lesson 17:
Geospatial Data
Lesson 18:
Hands-on: Geospatial Data

Working with Data in CrateDB

Lesson 19: Importing and Exporting Data
Lesson 20: Streaming & Foreign Data Wrappers
Lesson 21:
Indexing
Lesson 22:
Aggregating and Grouping Data
Lesson 23:
Hands-on: Aggregating and Grouping Data
Lesson 24:
Querying Data with Joins
Lesson 25:
Hands-on: Querying Data with Joins
Lesson 26:
Full-Text Search
Lesson 27:
Hands-on: Full-Text Search
Lesson 28:
Powerful SQL Queries
Lesson 29:
User-Defined Functions

Integrating CrateDB into your Application

Lesson 30: Client Interfaces
Lesson 31: Drivers
Lesson 32: Tools and Ecosystem Integrations

Operating at Scale

Lesson 33: Architecture Overview
Lesson 34: Monitoring and Tuning
Lesson 35: Security

Enroll into the CrateDB Fundamentals course now and get your certificate!

Advanced Time Series

Getting Started

Lesson 1: Introduction to Time Series Data
Lesson 2: Time Series Data in CrateDB
Lesson 3: Real-life Challenges with Time Series

Time Series Data Manipulation & Visualization

Lesson 4: Time Series Data Modeling
Lesson 5: Time Series SQL Queries
Lesson 6: Time Series Query Optimization
Lesson 7: Visualizing Time Series Data

Time Series Data Storage

Lesson 8: Sharding and Partitioning for Time Series
Lesson 9: Indexing for Time Series
Lesson 10: Managing Time Series Data Lifecycle

Importing Time Series Data

Lesson 11: Importing Data – Batch
Lesson 12: Importing Data – Stream

Machine Learning on Time Series Data

Lesson 13: Exploratory Data Analysis
Lesson 14: Decomposition of Time Series
Lesson 15: AutoML: Anomaly Detection in Time Series Data
Lesson 16:
AutoML: Forecasting of Time Series Data

Enroll into the Advanced Time Series course now and get your certificate!