SQL for Data Analysis

  1. Window Functions and Advanced Analytics
    1. Window Function Concepts
      1. Purpose and Use Cases
        1. Window vs Aggregate Functions
          1. OVER Clause Fundamentals
          2. Window Frame Specification
            1. PARTITION BY Clause
              1. ORDER BY in Windows
                1. Frame Boundaries
                  1. ROWS Frame
                    1. RANGE Frame
                      1. UNBOUNDED PRECEDING
                        1. CURRENT ROW
                          1. UNBOUNDED FOLLOWING
                        2. Ranking Functions
                          1. ROW_NUMBER Function
                            1. RANK Function
                              1. DENSE_RANK Function
                                1. NTILE Function
                                  1. Ranking with Ties
                                  2. Aggregate Window Functions
                                    1. Running Totals
                                      1. Moving Averages
                                        1. Cumulative Distributions
                                          1. Window-based MIN and MAX
                                          2. Offset Functions
                                            1. LAG Function
                                              1. LEAD Function
                                                1. FIRST_VALUE Function
                                                  1. LAST_VALUE Function
                                                    1. NTH_VALUE Function
                                                    2. Statistical Window Functions
                                                      1. PERCENT_RANK Function
                                                        1. CUME_DIST Function
                                                          1. PERCENTILE_CONT Function
                                                            1. PERCENTILE_DISC Function
                                                            2. Advanced Window Techniques
                                                              1. Multiple Window Specifications
                                                                1. Named Windows
                                                                  1. Filtering Window Results
                                                                    1. Window Functions in Subqueries

                                                                  Previous

                                                                  8. Subqueries and Derived Tables

                                                                  Go to top

                                                                  Next

                                                                  10. Set Operations and Advanced Queries