Hands-on tutorials for working with a broad spectrum of modern database systems — Relational (PostgreSQL), NewSQL (CockroachDB), Key-Value (Redis), Wide-Column (Cassandra), Document (MongoDB), Search (Elasticsearch), Graph (Neo4j, GraphDB), Time-Series (InfluxDB), and Vector (Qdrant).
This workshop is part of the Trivadis course NoSQL Databases as well as the NoSQL Module of the Big Data CAS at the Berner Fachhochschule.
| # | Workshop | Description |
|---|---|---|
| 1 | Working with PostgreSQL | Design a 3rd Normal Form relational schema for the film dataset and learn SQL querying, JOINs, aggregations, indexes, and views in PostgreSQL. |
| 2 | Working with Redis | Learn the core Redis data structures (Strings, Lists, Sets, Sorted Sets, Hashes), benchmark performance with the built-in tool, and interact with Redis from Python. |
| 3 | Working with Cassandra | Model and query wide-column data in Apache Cassandra using CQL, covering keyspace design, partition keys, and time-series data patterns. |
| 4 | Working with MongoDB | Store, query, and aggregate JSON documents in MongoDB, exploring schema flexibility, indexing, and the aggregation pipeline. |
| 5 | Working with Elasticsearch | Index and search documents in Elasticsearch using full-text queries, filters, and aggregations via the REST API. |
| 6 | Working with Neo4j | Model and traverse graph data in Neo4j using the Cypher query language, covering nodes, relationships, and pattern matching. |
| 7 | Working with GraphDB | Load RDF triples into Ontotext GraphDB and query the knowledge graph using SPARQL, including joins, filters, and aggregations. |
| 8 | Working with InfluxDB | Write and query time-series metrics in InfluxDB v3 using SQL and the Flux language, covering downsampling and retention policies. |
| 9 | Working with Qdrant | Store vector embeddings in Qdrant and perform similarity search with payload filtering using the REST API and Python client. |
| 10 | Working with CockroachDB | Use the same 3NF film schema on CockroachDB and explore its NewSQL-specific features: distributed ranges, time-travel queries, online schema changes, and serializable transactions. |