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
3.
Fundamental SQL Queries
3.1.
The SELECT Statement
3.1.1.
Basic Syntax and Structure
3.1.2.
Selecting All Columns
3.1.3.
Selecting Specific Columns
3.1.4.
Column Order and Positioning
3.1.5.
Selecting Distinct Values
3.1.6.
Handling Duplicate Rows
3.2.
The FROM Clause
3.2.1.
Specifying Source Tables
3.2.2.
Table References
3.2.3.
Schema Qualification
3.2.4.
Database Qualification
3.3.
The WHERE Clause
3.3.1.
Filtering Rows
3.3.2.
Condition Evaluation
3.3.3.
Comparison Operators
3.3.3.1.
Equal
3.3.3.2.
Not Equal
3.3.3.3.
Less Than
3.3.3.4.
Greater Than
3.3.3.5.
Less Than or Equal To
3.3.3.6.
Greater Than or Equal To
3.3.4.
Operator Precedence
3.4.
The ORDER BY Clause
3.4.1.
Sorting Results
3.4.2.
Ascending Order
3.4.3.
Descending Order
3.4.4.
Sorting by Multiple Columns
3.4.5.
Sorting by Column Position
3.4.6.
Sorting by Expressions
3.4.7.
NULL Value Ordering
3.5.
The LIMIT Clause
3.5.1.
Restricting Row Count
3.5.2.
OFFSET for Pagination
3.5.3.
TOP Clause Alternative
3.5.4.
FETCH and OFFSET Standard
3.6.
Using Aliases
3.6.1.
Column Aliases
3.6.2.
Table Aliases
3.6.3.
Alias Scope and Visibility
3.6.4.
Best Practices for Aliases
Previous
2. Basic SQL Query Structure
Go to top
Next
4. Advanced Filtering and Selection