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
4.
Advanced Filtering and Selection
4.1.
Logical Operators
4.1.1.
AND Operator
4.1.2.
OR Operator
4.1.3.
NOT Operator
4.1.4.
Combining Multiple Conditions
4.1.5.
Operator Precedence
4.1.6.
Using Parentheses for Grouping
4.2.
Pattern Matching
4.2.1.
LIKE Operator
4.2.2.
Wildcards
4.2.2.1.
Percent Sign Wildcard
4.2.2.2.
Underscore Wildcard
4.2.3.
ESCAPE Clause
4.2.4.
Case Sensitivity in Pattern Matching
4.3.
Range and Set Operations
4.3.1.
BETWEEN Operator
4.3.2.
IN Operator
4.3.3.
NOT IN Operator
4.3.4.
ANY Operator
4.3.5.
ALL Operator
4.3.6.
SOME Operator
4.4.
NULL Value Handling
4.4.1.
IS NULL Operator
4.4.2.
IS NOT NULL Operator
4.4.3.
NULL Comparison Behavior
4.4.4.
Three-Valued Logic
4.5.
Regular Expressions
4.5.1.
REGEXP Operator
4.5.2.
Common Regex Patterns
4.5.3.
Case-Insensitive Matching
Previous
3. Fundamental SQL Queries
Go to top
Next
5. Data Aggregation and Grouping