Project Metamorphosis: Unveiling the next-gen event streaming platformLearn More

KSQL Training for Hands-On Learning

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.

Interested in learning more?

Learn about ksqlDB, the successor to KSQL.

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.

Did you like this blog post? Share it now

Subscribe to the Confluent blog

More Articles Like This

The Curious Incident of the State Store in Recovery in ksqlDB

When operating cloud infrastructure, “time is money” is more than a cliché—it is interpreted literally as every processing second stacks up on the monthly bill. ksqlDB strives to reduce these […]

Announcing ksqlDB 0.11.0

We’re pleased to announce ksqlDB 0.11.0, which takes a big step forward toward improved production stability. This is becoming increasingly important as companies like Bolt and PushOwl use ksqlDB for […]

I’ve Got the Key, I’ve Got the Secret. Here’s How Keys Work in ksqlDB 0.10.

ksqlDB 0.10 includes significant changes and improvements to how keys are handled. This is part of a series of enhancements that began with support for non-VARCHAR keys and will ultimately […]

Sign Up Now

Start your 3-month trial. Get up to $200 off on each of your first 3 Confluent Cloud monthly bills

Nouvelles inscriptions uniquement.

En cliquant sur le bouton « inscription » ci-dessus, vous acceptez que nous traitions vos informations personnelles conformément à notre Politique de confidentialité.

En cliquant sur « Inscription » ci-dessus, vous acceptez les termes du/de la Conditions d'utilisation et de recevoir occasionnellement des e-mails publicitaires de la part de Confluent. Vous comprenez également que nous traiterons vos informations personnelles conformément à notre Politique de confidentialité.

Get Confluent Cloud

Get up to $200 off on each of your first 3 Confluent Cloud monthly bills


Choose one sign-up option below

Marketplaces

  • AWS
  • Azure
  • Google Cloud

  • Billed through your Cloud provider*
  • Stream only on 1 cloud
*Billing admin role needed

Marketplaces

  • Billed through your Cloud provider*
  • Stream only on 1 cloud
  • Billing admin role needed

*Billing admin role needed

Confluent


  • Pay with a credit card
  • Stream across multiple clouds

Confluent

  • Pay with a credit card
  • Stream across multiple clouds

En cliquant sur le bouton « inscription » ci-dessus, vous acceptez que nous traitions vos informations personnelles conformément à notre Politique de confidentialité.

En cliquant sur « Inscription » ci-dessus, vous acceptez les termes du/de la Conditions d'utilisation et de recevoir occasionnellement des e-mails publicitaires de la part de Confluent. Vous comprenez également que nous traiterons vos informations personnelles conformément à notre Politique de confidentialité.

Gratuit à vie sur un seul broker Kafka
i

Le logiciel permettra une utilisation illimitée dans le temps de fonctionnalités commerciales sur un seul broker Kafka. Après l'ajout d'un second broker, un compteur de 30 jours démarrera automatiquement sur les fonctionnalités commerciales. Celui-ci ne pourra pas être réinitialisé en revenant à un seul broker.

Sélectionnez un type de déploiement
Déploiement manuel
  • tar
  • zip
  • deb
  • rpm
  • docker
ou
Déploiement automatique
  • kubernetes
  • ansible

En cliquant sur le bouton « télécharger gratuitement » ci-dessus, vous acceptez que nous traitions vos informations personnelles conformément à notre Politique de confidentialité.

En cliquant sur « Téléchargement gratuit » ci-dessus, vous acceptez la Contrat de licence Confluent et de recevoir occasionnellement des e-mails publicitaires de la part de Confluent. Vous acceptez également que vos renseignements personnels soient traitées conformément à notre Politique de confidentialité.

Ce site Web utilise des cookies afin d'améliorer l'expérience utilisateur et analyser les performances et le trafic sur notre site Web. Nous partageons également des informations concernant votre utilisation de notre site avec nos partenaires publicitaires, analytiques et de réseaux sociaux.