Useful Links
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
Advanced Data Types and Semi-Structured Data
Array Data Types
Array Declaration
Array Operations
Array Functions
Unnesting Arrays
JSON Data Handling
JSON Data Type
JSON Functions
JSON_EXTRACT
JSON_VALUE
JSON_QUERY
JSON Path Expressions
JSON Aggregation
XML Data Handling
XML Data Type
XML Functions
XPath Queries
XML Parsing
User-Defined Types
Creating Custom Types
Using Custom Types
Type Hierarchies
Previous
11. Views and Temporary Objects
Go to top
Next
13. SQL for Data Analysis Applications