Confluent ksqlDB complete course-Build streaming app by SQL

سرفصل های دوره

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

1. Course Introduction

1. Course overview Introduction and agenda

2. Prerequisites

2. Meet Confluent KSQL And ksqlDB

1. Meet ksqldb section content overview

2. What is ksqlDB

3. ksqlDB Features and Benefits

4. ksqlDB vs kafka streams framework

5. ksqlDB Architecure and internal components

6. ksqlDB cluster deploy mode(interactive and headless)

3. ksqlDB installation And quick start

1. ksqlDB installation And quick start contents overview

2.1 zookeeper kafka installation.txt

2. Apache Zookeeper And Kafka Cluster installation

3.1 ksqldb installation.txt

3. Confluent ksqlDB server installation

4.1 create first stream.txt

4. Create the first streaming application by ksql statement

5.1 run scripts.zip

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

6.1 Execute Specific Statements and Quit.txt

6. Execute Specific Statements and Quit

7.1 headless.zip

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

8. ksqlDB query statement execution lifecycle

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

2.1 Data Types.txt

2. ksqlDB simple data types and compound data types

3.1 Custom Types.txt

3. ksqlDB support custom brand-new data types

4. ksqlDB Serialization and Serialization Formats

5.1 CSV Format.txt

5. ksqlDB DELIMITED Serialization Formats process CSV Data

6.1 schema registry integration with ksqldb.txt

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

7.1 JSON SR Format.txt

7.2 producerclientwithsr.zip

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

8. ksqlDB collections introduction Stream And Table

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

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

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

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

11. ksqlDB time semantics and custom timestamp column

12.1 Custom timestamp column.txt

12. Lab ksqlDB time semantics and custom timestamp column

13.1 Manipulation Collections.txt

13. Manipulation Collections(ShowDescribeAlterDrop)

14.1 Basic Queries.txt

14. ksqlDB collections basic queries and examples

15.1 Conditional Expressions in collection where clause queries.txt

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

16.1 Creating Derived Collections(CSAS and CTAS).txt

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

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

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

18.1 word count.txt

18. Lab ksqlDB implement WordCount application by ksql query statement

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

20.1 xmall.txt

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

21.1 variables.txt

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

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

2. ksqlDB collections joins and windowed

3.1 streams join streams.txt

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

4.1 streams join tables.txt

4. ksqlDB stream join(innerleft) another table

5.1 tables join tables.txt

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

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

7. ksqlDB collections grouping clause And aggregating function

8.1 grouping and aggregate.txt

8. The group by clause basic queries and examples

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

10. Lab ksqlDB grouping clause build sales champion application

11. ksqlDB time and windows

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

14.1 suppress windowed.txt

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

15.1 hopping time window.txt

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

16.1 session time window.txt

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

17. Apache Kafka Connect introduction

18.1 Apache Kafka Connect.txt

18. Apache Kafka Connect distributed cluster setup

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

20.1 ksqlDB integrate Kafka connect cluster.txt

20. ksqlDB integrate Kafka Connect distributed cluster define FileSource connector

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

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

23. ksqlDB Materialized Views

6. ksqlDB Functions(UDF And UDTF AndUDAF)

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

2.1 udf-scalar function.txt

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

3.1 udf-tabular functions.txt

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

4.1 udf- aggragator function.txt

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

5.1 lambda functions.txt

5. ksqlDB Use lambda functions

7. ksqlDB Clients

1.1 ksqlDB rest API.txt

1. ksqlDB REST API

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

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

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

8. PowerPoint and Source Code Download

1.1 Confluent KSQLDB.pptx

1.2 confluent-ksqldb.zip

1. Feel Free Download.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training