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
Basic SQL Query Structure
SQL Statement Types
Data Query Language
Data Definition Language
Data Manipulation Language
Data Control Language
Query Execution Order
Logical Processing Order
Physical Execution Order
SQL Syntax Rules
Case Sensitivity
Statement Terminators
Comments
Single-line Comments
Multi-line Comments
Reserved Words
Identifiers and Naming Rules
Previous
1. Introduction to SQL and Relational Databases
Go to top
Next
3. Fundamental SQL Queries