Useful Links
1. Introduction to SQL and Relational Databases
2. Basic SQL Query Structure
3. Fundamental SQL Queries
4. Advanced Filtering and Selection
5. Data Aggregation and Grouping
6. Joining Tables
7. Data Transformation and Manipulation
8. Subqueries and Derived Tables
9. Window Functions and Advanced Analytics
10. Set Operations and Advanced Queries
11. Views and Temporary Objects
12. Advanced Data Types and Semi-Structured Data
13. SQL for Data Analysis Applications
14. Performance Optimization and Best Practices
  1. Computer Science
  2. Data Science

SQL for Data Analysis

1. Introduction to SQL and Relational Databases
2. Basic SQL Query Structure
3. Fundamental SQL Queries
4. Advanced Filtering and Selection
5. Data Aggregation and Grouping
6. Joining Tables
7. Data Transformation and Manipulation
8. Subqueries and Derived Tables
9. Window Functions and Advanced Analytics
10. Set Operations and Advanced Queries
11. Views and Temporary Objects
12. Advanced Data Types and Semi-Structured Data
13. SQL for Data Analysis Applications
14. Performance Optimization and Best Practices
  1. Advanced Data Types and Semi-Structured Data
    1. Array Data Types
      1. Array Declaration
        1. Array Operations
          1. Array Functions
            1. Unnesting Arrays
            2. JSON Data Handling
              1. JSON Data Type
                1. JSON Functions
                  1. JSON_EXTRACT
                    1. JSON_VALUE
                      1. JSON_QUERY
                      2. JSON Path Expressions
                        1. JSON Aggregation
                        2. XML Data Handling
                          1. XML Data Type
                            1. XML Functions
                              1. XPath Queries
                                1. XML Parsing
                                2. User-Defined Types
                                  1. Creating Custom Types
                                    1. Using Custom Types
                                      1. Type Hierarchies

                                    Previous

                                    11. Views and Temporary Objects

                                    Go to top

                                    Next

                                    13. SQL for Data Analysis Applications

                                    © 2025 Useful Links. All rights reserved.

                                    About•Bluesky•X.com