UsefulLinks
Computer Science
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
12.
Advanced Data Types and Semi-Structured Data
12.1.
Array Data Types
12.1.1.
Array Declaration
12.1.2.
Array Operations
12.1.3.
Array Functions
12.1.4.
Unnesting Arrays
12.2.
JSON Data Handling
12.2.1.
JSON Data Type
12.2.2.
JSON Functions
12.2.2.1.
JSON_EXTRACT
12.2.2.2.
JSON_VALUE
12.2.2.3.
JSON_QUERY
12.2.3.
JSON Path Expressions
12.2.4.
JSON Aggregation
12.3.
XML Data Handling
12.3.1.
XML Data Type
12.3.2.
XML Functions
12.3.3.
XPath Queries
12.3.4.
XML Parsing
12.4.
User-Defined Types
12.4.1.
Creating Custom Types
12.4.2.
Using Custom Types
12.4.3.
Type Hierarchies
Previous
11. Views and Temporary Objects
Go to top
Next
13. SQL for Data Analysis Applications