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

4.68 (1835 reviews)
Udemy
platform
English
language
Other
category
16,272
students
4 hours
content
Mar 2024
last update
$84.99
regular price

What you will 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

Description

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 Setup

  • KSQL Command Line

  • Streams with CSV, JSON, and AVRO

  • Use the KSQL-Datagen utility

  • Manipulate streams

  • Create Tables

  • Perform Joins

  • Advanced KSQL: Rekeying, Merging Streams, Windowing, Geospatial

  • Extending KSQL: UDF & UDAF

  • Moving to Production

  • KSQL Operations

Note: 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.


===============================

Instructor

My 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 Updates

  • A responsive instructor in the Q&A Section

  • Links to interesting articles, and lots of good code to base your next applications onto

  • Udemy Certificate of Completion Ready for Download

This 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 Learning

  • Kafka Streams for Data Processing

  • KSQL on ksqlDB - Hands On!

  • Kafka Cluster Setup & Administration

  • Confluent Schema Registry & Kafka REST Proxy

  • Kafka Security (SSL SASL ACL)

  • Kafka Monitoring and Operations

Happy learning!

Content

Introduction

KSQL Course Introduction
Project Overview

Code Download

Code Download

KSQL Setup

KSQL Setup - Mac / Linux / Windows
Important - Windows Users
KSQL Command Line

KSQL Basics

Our first KSQL Stream
Create a Stream with JSON
KSQL Datagen - Generating Streams
Manipulate a Stream
Our first table
Update a table

KSQL Intermediate

KSQL Joins
Pull Queries
Kafka Connect with ksqlDB
Data Encodings
CSV Delimited Data
JSON Data
Avro Data
Avro Schema Evolution
Nested JSON
Build a rekeyed table
Repartition a Stream
Merging Streams
Windowing
Geospatial

KSQL Extensions - UDF & UDAF

Extending KSQL - UDF / UDAF
Using the UDF / UDAF

KSQL in Production

Moving to Productions-Headless for KSQL
Explain Plan
Scaling and Load Balancing
Configuration Settings
State Stores

Next Steps

Next Steps & Congratulations
THANK YOU!
Bonus Lecture: Special discounts for our other courses

Screenshots

Apache Kafka Series - KSQL on ksqlDB for Stream Processing ! - Screenshot_01Apache Kafka Series - KSQL on ksqlDB for Stream Processing ! - Screenshot_02Apache Kafka Series - KSQL on ksqlDB for Stream Processing ! - Screenshot_03Apache Kafka Series - KSQL on ksqlDB for Stream Processing ! - Screenshot_04

Reviews

Pranjal
October 29, 2023
Instructor is good, although the demo is on old version, and many of the commands syntax has changed drastically.
George
October 28, 2023
I thought the course was very informative. However, I think it is very outdated and needs to be updated. Also, I came across a number of questions that were just left dead in the water. As a result, there were features working in the tutorial that I could not get to work in my version (left joins of tables and streams). I look forward to reviewing the tutorial again once updated.
Clemens
September 30, 2023
This course is outdated and it feels that there have been a lot of changes in ksqldp since this was recorded. It doesn't help that there is a newer readme with partially updated commands.
Pushpesh
June 6, 2023
Most of it was done with the confluent platform, would have been great if some time was given to show how to integrate KSQL with AWS MSK. That is my only nitpick as that was the only reason I enrolled for this course.
Franklin
May 11, 2023
I really enjoyed this course. I love the approach and the read-me md file with all the written steps of each exercise. It will be useful long after the course.
Sergio
April 3, 2023
Algunos de los subtítulos son inexactos y erróneos, tanto en español como en inglés. Hay veces es molesto cuando estás concentrado en el curso.
Joerg
March 3, 2023
Excellent! Would have been 5 stars, if only I could have been able to start the "DataGen" in my Windows/Docker environment. So I had to skip some practical excercises. I assume the currently available solution with docker-compose.yml requires additions.
Pedro
January 18, 2023
Excellent to have a general overview and understanding of Kafka-KSQL. Very hands-on tutorials, although you might need to find some alternative command lines in the internet depending on your system/version.
Heidi
December 29, 2022
Covered a lot of aspects of KSql though it would have been nice to have more detail on getting this running using Windows Docker image as well as discuss a bit about the docker-compose file configurations settings. I'm sure it's tough to keep up with all the version changes, but seems much of the UI as well as commands have changed since this course was put together. Though it was still a good resource to get introduced to all these aspects of KSql, so still a good course.
Dimitris
December 22, 2022
Excellent course, as usual the theory is solid. All instructions for the hands on sections are up to date and fully functioning.
Marco
October 27, 2022
Nice course, thank you, but I think Kafka Streams will be more useful to me, I took the course of Kafka Streams too, though. This course is really good, but I had some problems running the ksql server, I really recommend use the Docker version of Confluent, I tried to run the TAR version on an Ubuntu installation and it was a nightmare, don't know why but the server never run in that way.
Amit
October 11, 2022
Very good and informative course. Course demonstrates using the old versions but the course notes are updated for newer versions that really helps.
Abi
September 10, 2022
This is good course however it good be better by covering Ktable Global table, when we can use Ksql and for what data volume.
Andrew
July 21, 2022
This was a very good and informative course and I really learned quite a bit. Even though the technology versions being used were slightly outdated, the training notes/code were updated for newer versions. It would be good to have a lecture that maybe talked about what new features are available in newer versions, so that the learner can go look into more detail on the new capabilities.
Madhu
July 17, 2022
Concepts are well explained but it lacked quiz at the end whereas other kafka tutorials had the quiz at end of sections. There was too much time wasted at my end for setting up the kafka and ksql environment, the config varies across versions and it was time consuming figuring out the errors. I would suggest the tutorial to have a seperate VM or some online url where the required environment is already installed and we can play around the commands and queries and save time in setting up the ksql environment

Charts

Price

Apache Kafka Series - KSQL on ksqlDB for Stream Processing ! - Price chart

Rating

Apache Kafka Series - KSQL on ksqlDB for Stream Processing ! - Ratings chart

Enrollment distribution

Apache Kafka Series - KSQL on ksqlDB for Stream Processing ! - Distribution chart

Related Topics

2343996
udemy ID
4/29/2019
course created date
8/7/2019
course indexed date
Bot
course submited by