Streaming Data Processing with Apache Kafka and KSQL

  1. Querying and Transforming Data
    1. Basic SELECT Statements
      1. Syntax of SELECT
        1. Projecting Columns
          1. Using Aliases
            1. Column Ordering
            2. Filtering Data
              1. The WHERE Clause
                1. Syntax and Usage
                  1. Filter Conditions
                  2. Comparison Operators
                    1. Equality and Inequality
                      1. Range Comparisons
                      2. Logical Operators
                        1. AND, OR, NOT
                          1. Operator Precedence
                          2. Pattern Matching
                            1. LIKE Operator
                              1. Regular Expressions
                            2. Data Transformation
                              1. Built-in Scalar Functions
                                1. String Functions
                                  1. CONCAT
                                    1. SUBSTRING
                                      1. UPPER
                                        1. LOWER
                                          1. TRIM
                                            1. REPLACE
                                            2. Numeric Functions
                                              1. ABS
                                                1. ROUND
                                                  1. CEIL
                                                    1. FLOOR
                                                      1. MOD
                                                        1. POWER
                                                        2. Date and Time Functions
                                                          1. TIMESTAMPTOSTRING
                                                            1. STRINGTOTIMESTAMP
                                                              1. DATEADD
                                                                1. DATESUB
                                                                  1. EXTRACT
                                                                2. Type Casting with CAST
                                                                  1. Syntax and Use Cases
                                                                    1. Supported Type Conversions
                                                                  2. Handling Complex Data Types
                                                                    1. Accessing STRUCT Fields
                                                                      1. Dot Notation
                                                                        1. Nested Structure Access
                                                                        2. Working with ARRAYs
                                                                          1. Array Functions
                                                                            1. Array Element Access
                                                                              1. Array Manipulation
                                                                              2. Working with MAPs
                                                                                1. Map Functions
                                                                                  1. Key-Value Access
                                                                                    1. Map Manipulation

                                                                                Previous

                                                                                5. ksqlDB Data Definition Language (DDL)

                                                                                Go to top

                                                                                Next

                                                                                7. Aggregations and Windowing