SQL for Data Analysis

  1. Views and Temporary Objects
    1. Views
      1. View Concepts
        1. Creating Views
          1. Simple Views
            1. Complex Views
              1. Updatable Views
                1. View Dependencies
                  1. View Security Benefits
                  2. Materialized Views
                    1. Materialized View Concepts
                      1. Creating Materialized Views
                        1. Refreshing Materialized Views
                          1. Query Rewriting with Materialized Views
                            1. Performance Benefits
                            2. Temporary Tables
                              1. Local Temporary Tables
                                1. Global Temporary Tables
                                  1. Creating Temporary Tables
                                    1. Temporary Table Scope
                                      1. Performance Considerations
                                      2. Table Variables
                                        1. Declaring Table Variables
                                          1. Table Variables vs Temporary Tables
                                            1. Use Cases for Table Variables

                                          Previous

                                          10. Set Operations and Advanced Queries

                                          Go to top

                                          Next

                                          12. Advanced Data Types and Semi-Structured Data