About
CrateDB Workshop is a hands-on learning experience for novel and experienced users. The workshop introduces the fundamental concepts of CrateDB, a distributed SQL database, and how it can be used to efficiently store, query, and analyze large amounts of data.
The content for this workshop will be divided into five modules over two days:
Day 1: October 10
- Module 1: Introduction to CrateDB and its Architecture
2:00–2:20 pm CET - Module 2: Installing and configuring CrateDB
2:30–2:50 pm CET - Module 3: Inserting and Querying Data
3:00–3:50 pm CET
Day 2: October 11
- Module 4: Modeling Data in CrateDB
2:00–2:50 pm CET - Module 5: Query Planning and Optimizations
3:00–3:50 pm CET
The workshop is delivered in a guided, step-by-step manner over two days. On the first day, you will learn about CrateDB’s distributed architecture, installation process, and how to create tables and run queries. During the second day, you will get familiar with more advanced features such as full-text search, data modeling, and how to further optimize your queries.
What you will learn
- The fundamentals of CrateDB architecture and its SQL and NoSQL capabilities
- How to install and set up your CrateDB instance
- Inserting and querying data in CrateDB
- How to find a perfect sharding and partitioning strategy
- Advanced data analysis: joins, aggregations window functions, and full-text search
- Understanding the query planner and how to get the best performance for your use case
By the end of the workshop, you will have a solid understanding of CrateDB's core features and how to use them to build scalable, data-driven applications. You will also have hands-on experience working with CrateDB and be equipped with the tools and knowledge needed to further explore its capabilities.
Prerequisites
- Basic SQL knowledge