SQL for Data Analysis

  1. Set Operations and Advanced Queries
    1. Set Operators
      1. UNION Operator
        1. UNION ALL Operator
          1. INTERSECT Operator
            1. EXCEPT Operator
              1. Set Operator Rules
                1. Column Compatibility
                  1. Set Operator Precedence
                  2. Advanced Query Techniques
                    1. Pivot Operations
                      1. Manual Pivoting with CASE
                        1. PIVOT Operator
                        2. Unpivot Operations
                          1. UNPIVOT Operator
                            1. Manual Unpivoting
                            2. Recursive Queries
                              1. Hierarchical Data Queries
                                1. Tree Traversal
                                  1. Graph Analysis
                                2. Query Optimization Techniques
                                  1. Query Rewriting
                                    1. Predicate Pushdown
                                      1. Join Elimination
                                        1. Subquery Optimization

                                      Previous

                                      9. Window Functions and Advanced Analytics

                                      Go to top

                                      Next

                                      11. Views and Temporary Objects