Confluent
KSQL Training for Hands-On Learning
Traitement de flux

KSQL Training for Hands-On Learning

Simon Aubury

I’ve been using KSQL from Confluent since its first developer preview in 2017. Reading, writing, and transforming data in Apache Kafka® using KSQL is an effective way to rapidly deliver event streaming applications for clients (e.g., streaming insurance events). Plus, I’ve also had the opportunity to deploy KSQL in some not-so-serious hobby projects (see Noise Mapping with KSQL, a Raspberry Pi and a Software-Defined Radio and ML and KSQL Let Me Know When I’ve Left the Heater Running).

KSQL has been growing in features and popularity since its early releases. To inspire and help developers embrace this fantastic event streaming technology, Stéphane Maarek and I authored a new KSQL course. For a KSQL newbie the practical exercises show you how to process data in Apache Kafka using an interactive SQL interface. The more experienced KSQL developer will benefit from production deployment lessons. Either way, we are thrilled to be able to offer the course for USD $9.99 using this special coupon for our blog readers.

Through this hands-on course, you will build an entire taxi-booking application using KSQL and Apache Kafka. This project approach means that students first start with the building blocks of streams and tables and then proceed onto advanced KSQL areas, such as topic rekeying, data encoding (CSV, JSON, and Avro), stream merging, and time-based windowing. The course also shows students how to use geospatial extensions and extend KSQL with user-defined functions.

The production deployment lectures allow you to confidently scale a cluster, visualize a topology and demonstrate resilience in a multi-server configuration. It can be very satisfying to destroy nodes on your laptop and see your KSQL application continue unaffected!

The course consists of 33 lectures in total. We aim for each lesson to be under 10 minutes—enough time to cover the theory and build a component, yet quick enough to keep the momentum going. KSQL has a heap of terrific features, so we wanted to keep a good pace during the video lessons.

I really enjoyed having the opportunity to co-create KSQL for Stream Processing – Hands On! course with Stéphane. We both hope you’ll find the course a great way to get up and running quickly with KSQL. We can’t wait to see what amazing projects are created with KSQL by the fantastic community of developers.

Simon Aubury is a data geek on all things from databases to event streaming, architecture, IoT, and cloud. A data engineer architect from Sydney, Australia, he lives with his wife, two kids, and a grumpy cat.

Subscribe to the Confluent Blog

S'abonner

More Articles Like This

Kafka Tutorials
Michael Drogalis

Announcing Tutorials for Apache Kafka

Michael Drogalis .

We’re excited to announce Tutorials for Apache Kafka®, a new area of our website for learning event streaming. Kafka Tutorials is a collection of common event streaming use cases, with ...

KSQL
Mitch Seymour

KSQL UDFs and UDAFs Made Easy

Mitch Seymour .

One of KSQL’s most powerful features is allowing users to build their own KSQL functions for processing real-time streams of data. These functions can be invoked on individual messages (user-defined ...

Figure 1. The packaging of payloads for Oracle WMS Cloud
Stewart Bryson

Deploying Kafka Streams and KSQL with Gradle – Part 3: KSQL User-Defined Functions and Kafka Streams

Stewart Bryson .

Building off part 1 where we discussed an event streaming architecture that we implemented for a customer using Apache Kafka, KSQL, and Kafka Streams, and part 2 where we discussed ...

Leave a Reply

Your email address will not be published. Required fields are marked *

Try Confluent Platform

Download Now

Nous utilisons des cookies afin de comprendre comment vous utilisez notre site et améliorer votre expérience. Cliquez ici pour en apprendre davantage ou pour modifier vos paramètres de cookies. En poursuivant la navigation, vous consentez à ce que nous utilisions des cookies.