Apache Kafka Series KSQL on ksqlDB for Stream Processing

Use SQL on Apache Kafka with Confluent ksqlDB! Build an entire taxi booking application based on KSQL stream processing
Apache Kafka Series KSQL on ksqlDB for Stream Processing
File Size :
1019.26 MB
Total length :
4h 1m



Stephane Maarek | AWS Certified Cloud Practitioner,Solutions Architect,Developer


Last update




Apache Kafka Series KSQL on ksqlDB for Stream Processing

What you’ll learn

Learn all the fundamentals of KSQL & ksqlDB
Create a taxi booking application
Create Streams, Tables, Generate Data with ksql-datagen
Advanced Operations: Joins, Windowing, Aggregations, Geospatial
Deal with all kind of data formats: CSV, JSON & Avro
Create and use UDF, use UDAF
Moving KSQL to production with tips

Apache Kafka Series KSQL on ksqlDB for Stream Processing


Fundamental understanding of Kafka (see beginners course)
Kafka Streams knowledge is a plus (but not a requirement)


The latest release in the Apache Kafka Series!Confluent ksqlDB has become an increasingly popular stream processing framework built upon Kafka Streams. It enables developers to write real-time stream processing applications with the ease of SQL. No Kafka Streams knowledge required!For this course, I have partnered with KSQL expert Simon Aubury to bring you the ultimate KSQL course. We’ll take a project based approach for this course. You’ll learn all the most important KSQL features by gradually building a KSQL taxi booking application!KSQL SetupKSQL Command LineStreams with CSV, JSON, and AVROUse the KSQL-Datagen utilityManipulate streamsCreate TablesPerform JoinsAdvanced KSQL: Rekeying, Merging Streams, Windowing, GeospatialExtending KSQL: UDF & UDAFMoving to ProductionKSQL OperationsNote: To best enjoy this course, a Mac or Linux machine is preferred. Windows users will have special instructions and would be better by leveraging a Linux VM. ===============================InstructorMy name is Stephane Maarek, and I’ll be your instructor in this course. I teach about Apache Kafka, the Kafka ecosystem and Kafka Certifications with my focus always on helping my students improve their professional proficiencies. I am also the co-founder of Conduktor: an enterprise Apache Kafka platform & UI to help everyone use Kafka.Throughout my career in designing and delivering these certifications and courses, I have already taught 1,000,000+ students and gotten 350,000+ reviews!Simon Aubury is the lead instructor of this course. He is a KSQL expert, authored many blogs on the Confluent Blog, and wrote cool KSQL POCs on Medium such as detecting in real-time when the heater of his house is left on, or when planes go over his house! He’ll be leading you through this course and make sure that everything is properly explained. With Apache Kafka becoming much more than a buzzword out there, I’ve decided it’s time for students to properly learn how to be a Kafka professional. So, let’s kick start the course! You are in good hands!===============================This Course Also Comes With:Lifetime Access to All Future UpdatesA responsive instructor in the Q&A SectionLinks to interesting articles, and lots of good code to base your next applications ontoUdemy Certificate of Completion Ready for DownloadThis is the course that could improve your career!Apache Kafka is a skill in high demand and there are not enough people to fulfill all the open positions. You can boost your income, take on new roles and fun challenges. Many of my students are now the Kafka experts of their companies! You can be the next!I hope to see you inside the course!=======================Note: Looking for more advanced Kafka concepts? There are many volumes in the Apache Kafka Series:Learn Kafka for Beginners v2 (great to start)Kafka Connect Hands On LearningKafka Streams for Data ProcessingKSQL on ksqlDB – Hands On!Kafka Cluster Setup & AdministrationConfluent Schema Registry & Kafka REST ProxyKafka Security (SSL SASL ACL)Kafka Monitoring and OperationsHappy learning!


Section 1: Introduction

Lecture 1 ksqlDB and KSQL Course Introduction

Lecture 2 Project Overview

Section 2: Code Download

Lecture 3 Code Download

Lecture 4 Prepare the ksqlDB project files

Section 3: ksqlDB and KSQL Setup

Lecture 5 KSQL Setup – Mac / Linux / Windows

Lecture 6 Important – Windows Users

Lecture 7 KSQL Command Line

Section 4: ksqlDB and KSQL Basics

Lecture 8 Our first KSQL Stream

Lecture 9 Create a Stream with JSON

Lecture 10 KSQL Datagen – Generating Streams

Lecture 11 Manipulate a Stream

Lecture 12 Streams from streams and functions

Lecture 13 ksqlDB Tables

Section 5: ksqlDB and KSQL Intermediate

Lecture 14 KSQL Joins

Lecture 15 Pull Queries

Lecture 16 Kafka Connect with ksqlDB

Lecture 17 Data Encodings

Lecture 18 CSV Delimited Data

Lecture 19 JSON Data

Lecture 20 Avro Data

Lecture 21 Avro Schema Evolution

Lecture 22 Nested JSON

Lecture 23 Build a rekeyed table

Lecture 24 Repartition a Stream

Lecture 25 Merging Streams

Lecture 26 Windowing

Lecture 27 Geospatial

Section 6: ksqlDB and KSQL Extensions – UDF & UDAF

Lecture 28 Extending KSQL – UDF / UDAF

Lecture 29 Using the UDF / UDAF

Section 7: ksqlDB and KSQL in Production

Lecture 30 Moving to Productions-Headless for KSQL

Lecture 31 Explain Plan

Lecture 32 Scaling and Load Balancing

Lecture 33 Configuration Settings

Lecture 34 State Stores

Lecture 35 Testing ksqlDB applications

Section 8: Next Steps

Lecture 36 Next Steps & Congratulations

Lecture 37 THANK YOU!

Lecture 38 Bonus Lecture

Developers who want to learn and write their first KSQL applications,Architects who want to understand how KSQL fits into their solution architecture,Anyone looking to learn more about KSQL

Course Information:

Udemy | English | 4h 1m | 1019.26 MB
Created by: Stephane Maarek | AWS Certified Cloud Practitioner,Solutions Architect,Developer

You Can See More Courses in the IT & Software >> Greetings from CourseDown.com

New Courses

Scroll to Top