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
10.
Set Operations and Advanced Queries
10.1.
Set Operators
10.1.1.
UNION Operator
10.1.2.
UNION ALL Operator
10.1.3.
INTERSECT Operator
10.1.4.
EXCEPT Operator
10.1.5.
Set Operator Rules
10.1.6.
Column Compatibility
10.1.7.
Set Operator Precedence
10.2.
Advanced Query Techniques
10.2.1.
Pivot Operations
10.2.1.1.
Manual Pivoting with CASE
10.2.1.2.
PIVOT Operator
10.2.2.
Unpivot Operations
10.2.2.1.
UNPIVOT Operator
10.2.2.2.
Manual Unpivoting
10.2.3.
Recursive Queries
10.2.3.1.
Hierarchical Data Queries
10.2.3.2.
Tree Traversal
10.2.3.3.
Graph Analysis
10.3.
Query Optimization Techniques
10.3.1.
Query Rewriting
10.3.2.
Predicate Pushdown
10.3.3.
Join Elimination
10.3.4.
Subquery Optimization
Previous
9. Window Functions and Advanced Analytics
Go to top
Next
11. Views and Temporary Objects