SQL for Data Analysis

  1. Subqueries and Derived Tables
    1. Subquery Fundamentals
      1. Definition and Purpose
        1. Subquery Types
          1. Subquery Placement
            1. Correlated vs Non-correlated Subqueries
            2. Scalar Subqueries
              1. Single Value Returns
                1. Use in SELECT Lists
                  1. Use in WHERE Clauses
                    1. Use in HAVING Clauses
                    2. Multi-row Subqueries
                      1. Subqueries with IN
                        1. Subqueries with NOT IN
                          1. Subqueries with EXISTS
                            1. Subqueries with NOT EXISTS
                              1. Subqueries with ANY
                                1. Subqueries with ALL
                                2. Correlated Subqueries
                                  1. Outer Reference Concept
                                    1. Performance Considerations
                                      1. Common Use Cases
                                        1. Rewriting as Joins
                                        2. Derived Tables
                                          1. Subqueries in FROM Clause
                                            1. Table Aliases for Derived Tables
                                              1. Multi-level Derived Tables
                                              2. Common Table Expressions
                                                1. WITH Clause Syntax
                                                  1. CTE Benefits
                                                    1. Readability
                                                      1. Modularity
                                                        1. Reusability
                                                        2. Multiple CTEs
                                                          1. Recursive CTEs
                                                            1. Recursive CTE Syntax
                                                              1. Base Case and Recursive Case
                                                                1. Hierarchical Data Processing
                                                                  1. Graph Traversal

                                                              Previous

                                                              7. Data Transformation and Manipulation

                                                              Go to top

                                                              Next

                                                              9. Window Functions and Advanced Analytics