SQL for Data Analysis

  1. Advanced Filtering and Selection
    1. Logical Operators
      1. AND Operator
        1. OR Operator
          1. NOT Operator
            1. Combining Multiple Conditions
              1. Operator Precedence
                1. Using Parentheses for Grouping
                2. Pattern Matching
                  1. LIKE Operator
                    1. Wildcards
                      1. Percent Sign Wildcard
                        1. Underscore Wildcard
                        2. ESCAPE Clause
                          1. Case Sensitivity in Pattern Matching
                          2. Range and Set Operations
                            1. BETWEEN Operator
                              1. IN Operator
                                1. NOT IN Operator
                                  1. ANY Operator
                                    1. ALL Operator
                                      1. SOME Operator
                                      2. NULL Value Handling
                                        1. IS NULL Operator
                                          1. IS NOT NULL Operator
                                            1. NULL Comparison Behavior
                                              1. Three-Valued Logic
                                              2. Regular Expressions
                                                1. REGEXP Operator
                                                  1. Common Regex Patterns
                                                    1. Case-Insensitive Matching

                                                  Previous

                                                  3. Fundamental SQL Queries

                                                  Go to top

                                                  Next

                                                  5. Data Aggregation and Grouping