SQL for Data Analysis

  1. Joining Tables
    1. Join Fundamentals
      1. Purpose of Joins
        1. Join Conditions
          1. Join Cardinality
            1. Join Performance Considerations
            2. Inner Joins
              1. INNER JOIN Syntax
                1. Equi-joins
                  1. Non-equi-joins
                    1. Multiple Join Conditions
                    2. Outer Joins
                      1. LEFT JOIN
                        1. RIGHT JOIN
                          1. FULL OUTER JOIN
                            1. Handling NULL Values in Outer Joins
                            2. Cross Joins
                              1. Cartesian Product
                                1. Use Cases for Cross Joins
                                2. Self Joins
                                  1. Joining Table to Itself
                                    1. Hierarchical Data Queries
                                      1. Comparing Rows Within Same Table
                                      2. Advanced Join Techniques
                                        1. Multi-table Joins
                                          1. Join Order Optimization
                                            1. Using Subqueries in Joins
                                              1. Conditional Joins
                                              2. Join Alternatives
                                                1. Implicit Join Syntax
                                                  1. WHERE Clause Joins
                                                    1. UNION for Join-like Operations

                                                  Previous

                                                  5. Data Aggregation and Grouping

                                                  Go to top

                                                  Next

                                                  7. Data Transformation and Manipulation