Confluent ksqlDB complete course-Build streaming app by SQL

Focused View

Alexander Wong

5:49:48

73 View

1. Course Introduction

1. Course overview Introduction and agenda.mp4

02:50

2. Prerequisites.mp4

00:44

2. Meet Confluent KSQL And ksqlDB

1. Meet ksqldb section content overview.mp4

01:28

2. What is ksqlDB.mp4

02:08

3. ksqlDB Features and Benefits.mp4

03:04

4. ksqlDB vs kafka streams framework.mp4

02:41

5. ksqlDB Architecure and internal components.mp4

05:08

6. ksqlDB cluster deploy mode(interactive and headless).mp4

07:16

3. ksqlDB installation And quick start

1. ksqlDB installation And quick start contents overview.mp4

01:22

2.1 zookeeper kafka installation.txt

2. Apache Zookeeper And Kafka Cluster installation.mp4

07:09

3.1 ksqldb installation.txt

3. Confluent ksqlDB server installation.mp4

05:48

4.1 create first stream.txt

4. Create the first streaming application by ksql statement.mp4

06:41

5.1 run scripts.zip

5. Run sql scripts file at ksqlDB(batch submit queries statement).mp4

04:15

6.1 Execute Specific Statements and Quit.txt

6. Execute Specific Statements and Quit.mp4

03:49

7.1 headless.zip

7. ksqlDB headless deploy mode(lock down the Interactive).mp4

07:12

8. ksqlDB query statement execution lifecycle.mp4

02:02

9. Which SQL operations are supported in headless mode.html

10. Run a list of predefined queries and a file by using RUN SCRIPT.html

4. Stream processing basics with ksqlDB

1. Stream processing basics with ksqlDB contents overview.mp4

01:56

2.1 Data Types.txt

2. ksqlDB simple data types and compound data types.mp4

09:51

3.1 Custom Types.txt

3. ksqlDB support custom brand-new data types.mp4

02:39

4. ksqlDB Serialization and Serialization Formats.mp4

01:45

5.1 CSV Format.txt

5. ksqlDB DELIMITED Serialization Formats process CSV Data.mp4

04:39

6.1 schema registry integration with ksqldb.txt

6. ksqlDB JSON SR Serialization Formats and Confluent Schema Registry Installation.mp4

04:57

7.1 JSON SR Format.txt

7.2 producerclientwithsr.zip

7. Lab ksqlDB integration with Schema Registry process JSON SR Formats Data.mp4

05:43

8. ksqlDB collections introduction Stream And Table.mp4

04:34

9.1 Create source collection(stream And table)-I.txt

9. ksqlDB create source collections(streamsAndtables) syntax and examples-I.mp4

07:03

10.1 Create source collection(stream And table)-II.txt

10. ksqlDB create source collections(streamsAndtables) syntax and examples-II.mp4

04:28

11. ksqlDB time semantics and custom timestamp column.mp4

02:16

12.1 Custom timestamp column.txt

12. Lab ksqlDB time semantics and custom timestamp column.mp4

06:25

13.1 Manipulation Collections.txt

13. Manipulation Collections(ShowDescribeAlterDrop).mp4

05:28

14.1 Basic Queries.txt

14. ksqlDB collections basic queries and examples.mp4

07:27

15.1 Conditional Expressions in collection where clause queries.txt

15. Conditional Expression in collection where clause queries(handle NULL value).mp4

06:01

16.1 Creating Derived Collections(CSAS and CTAS).txt

16. Creating Derived Collections(CSAS and CTAS) syntax and examples.mp4

06:46

17.1 Persistent Queries-Writing Results Back to Kafka target topic.txt

17. Persistent Queries-Writing Results Back to Kafka target topic.mp4

03:53

18.1 word count.txt

18. Lab ksqlDB implement WordCount application by ksql query statement.mp4

07:42

19. Explain statement - Show the execution plan for a SQL expression.mp4

02:20

20.1 xmall.txt

20. Lab ksqlDB implement XMall transaction data real-time analysis application.mp4

09:07

21.1 variables.txt

21. Extra Defines a variable to be used within SQL statements.mp4

07:26

22. About Streams and Tables, which statement is incorrect.html

5. Advanced Stream Processing with ksqlDB and Kafka Connect

1. Advanced Stream Processing with ksqlDB and Kafka Connect contents overview.mp4

01:42

2. ksqlDB collections joins and windowed.mp4

03:05

3.1 streams join streams.txt

3. ksqlDB stream join(innerleftfull) another stream with windowed.mp4

07:34

4.1 streams join tables.txt

4. ksqlDB stream join(innerleft) another table.mp4

05:11

5.1 tables join tables.txt

5. ksqlDB table primary key join(innerleftfull) another table.mp4

06:02

6. ksqlDB table foreign key join(innerleft) another table.mp4

04:26

7. ksqlDB collections grouping clause And aggregating function.mp4

02:44

8.1 grouping and aggregate.txt

8. The group by clause basic queries and examples.mp4

06:06

9. Which sql statement is correct in group by clause.html

10. Lab ksqlDB grouping clause build sales champion application.mp4

09:53

11. ksqlDB time and windows.mp4

02:17

12. Which type of time window not support in ksqlAndksqlDB.html

13.1 tumbling time window.txt

13. ksqlDB Tumbling time window and network potential attack analysis by realtime.mp4

07:15

14.1 suppress windowed.txt

14. ksqlDB suppress windowed intermediate computation result to downstream(suppress).mp4

03:02

15.1 hopping time window.txt

15. ksqlDB Hopping time window and analysis Twitter hot words by realtime.mp4

05:34

16.1 session time window.txt

16. ksqlDB Session time window and analysis web visit stats during a valid session.mp4

02:44

17. Apache Kafka Connect introduction.mp4

04:50

18.1 Apache Kafka Connect.txt

18. Apache Kafka Connect distributed cluster setup.mp4

05:20

19. Apache Kafka connect install connector plugins and create FileSource Connector.mp4

07:37

20.1 ksqlDB integrate Kafka connect cluster.txt

20. ksqlDB integrate Kafka Connect distributed cluster define FileSource connector.mp4

06:33

21.1 confluentinc-kafka-connect-jdbc-10.7.0.zip

21.2 Kafka Connect Install SQL Connector.txt

21.3 mysql-connector-java-8.0.29.zip

21.4 patient.zip

21. Heartbeat sensor data realtime analysis patient health monitor-JDBC Connector.mp4

07:58

22. Lab Heartbeat sensor data real-time analysis patient health monitoring.mp4

10:26

23. ksqlDB Materialized Views.mp4

04:19

6. ksqlDB Functions(UDF And UDTF AndUDAF)

1. ksqlDB Functions(UDF And UDTF AndUDAF) contents overview.mp4

02:17

2.1 udf-scalar function.txt

2. ksqlDB function custom Scalar functions(UDF) implement compute BMI formula.mp4

10:05

3.1 udf-tabular functions.txt

3. ksqlDB function custom Tabular functions(UDTF) implement split and explode.mp4

06:37

4.1 udf- aggragator function.txt

4. ksqlDB function custom Aggregation functions(UDAF) implement MAX2 applied table.mp4

07:51

5.1 lambda functions.txt

5. ksqlDB Use lambda functions.mp4

07:33

7. ksqlDB Clients

1.1 ksqlDB rest API.txt

1. ksqlDB REST API.mp4

05:33

2. ksqlDB Java Clients - interactive ksqlDB collections by Java code.mp4

02:09

3. ksqlDB Java Client Example(list streams And asynchronous query).mp4

10:15

4. ksqlDB Java Client Example(synchronous query And batch query).mp4

06:47

8. PowerPoint and Source Code Download

1.1 Confluent KSQLDB.pptx

1.2 confluent-ksqldb.zip

1. Feel Free Download.html

Description

Kafka streams,Kafka Connect,The database purpose-built for stream processing applications. Build streaming app by sql

What You'll Learn?

Confluent ksql&ksqlDB
Kafka streaming process application
Advanced Stream Processing with ksqlDB
ksqlDB and Apache Kafka connect component integration
One mental model for the entire stack
Build a complete streaming app with a few SQL statements
Confluent ksqlDB components and architecture
Develop UDFs and UDAFs
ksqldb Clients(REST API & Java Client)

Who is this for?

Build a complete streaming app with a few SQL statements

Build Complex Event Processing(CEP) application by ksqlDB

Master Confluent ksql&ksqlDB

Master Realtime streaming event process by sql

What You Need to Know?

Apache Kafka fundamental

Apache Kafka Streams framework fundamental

SQL fundamental

JVM(Java/Scala) development experiences

More details

Description
ksqlDB is a database purpose-built for stream processing applications. What exactly does this mean? It incorporates many components found in almost every stream processing architecture.

This is important because almost all streaming architectures today are piecemeal solutions cobbled together from different projects. At a minimum, you need one subsystem to get events from existing data sources, another to store them, another to process them, and another to query against aggregation. Integrating each subsystem can be difficult. Everyone has their own mental models. Given all these complexities, it's easy to wonder: is it all worth it?

ksqlDB aims to provide a mental model to do everything you need. You can build a complete streaming application against ksqlDB, which has only one dependency: Apache KafkaÂ®.

This course will comprehensively and meticulously introduce all the knowledge points of ksql and ksqlDB, allowing you to master the use of ksqlDB from beginner to proficient, from shallow to deep. Using ksqlDB, you can easily use a few lines of SQL statements to complete the development of streaming computing applications for real-time data.

Â Â Â Â [course requirements]
Some Apache Kafka/Confluent Kafka experience is required
Procedural experience with relational database SQL
Familiar with the Kafka Streams framework (kstream, ktable)

[course features]
Practise driven
Lots of real cases trainning
Step by step shallow to deep
The course content are straightforward
Covers most Confluent ksqlDB & ksql content
Rich comprehensive case help you fully understand
Who this course is for:
Build a complete streaming app with a few SQL statements
Build Complex Event Processing(CEP) application by ksqlDB
Master Confluent ksql&ksqlDB
Master Realtime streaming event process by sql

User Reviews

Rating

average 0

Total votes0

Focused display

He has more than 10 years of development experience, familiar with CI, CD and other related technologies, and is good at high concurrency, distributed application architecture and design. He is a bestselling author and has published three books in total.More than 20 sets of video courses have been released on Chinese websites, with more than 1 million downloads.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.