Useful Links
Computer Science
Databases
SQL Database Language
1. Introduction to Databases and SQL
2. SQL Fundamentals and Syntax
3. Basic Data Retrieval with SELECT
4. Data Manipulation Operations
5. Database Structure Management
6. Multi-Table Operations and Joins
7. Aggregate Functions and Data Summarization
8. Subqueries and Nested Queries
9. Advanced SQL Features
10. Transaction Management and Concurrency
11. Database Security and Access Control
12. Stored Procedures and Programmability
Basic Data Retrieval with SELECT
SELECT Statement Fundamentals
Basic Syntax Structure
Execution Order Concepts
Query Processing Flow
Selecting Columns
All Columns Selection
Asterisk Wildcard
Performance Considerations
Best Practices
Specific Column Selection
Column Name Specification
Column Order Control
Non-Existent Column Handling
Calculated Columns
Arithmetic Expressions
String Concatenation
Function Applications
Column Aliases
AS Keyword Usage
Alias Naming Rules
Quoted Aliases
Alias Scope
DISTINCT Keyword
Duplicate Elimination
Performance Impact
Multiple Column DISTINCT
DISTINCT vs GROUP BY
FROM Clause Essentials
Table Specification
Schema Qualification
Table Aliases
Alias Definition
Alias Usage Benefits
Correlation Names
WHERE Clause Filtering
Basic Filtering Concepts
Filter Condition Structure
Comparison Operators
Equal To
Not Equal To
Greater Than
Less Than
Greater Than or Equal
Less Than or Equal
Logical Operators
AND Operator
Multiple Conditions
Operator Precedence
OR Operator
Alternative Conditions
Parentheses Usage
NOT Operator
Negation Logic
De Morgan's Laws
Range and Set Operators
BETWEEN Operator
Inclusive Range Testing
Date Range Queries
Numeric Range Queries
IN Operator
Value List Testing
Subquery Integration
Performance Characteristics
NOT IN Considerations
NULL Value Handling
Unexpected Results
Pattern Matching
LIKE Operator
Wildcard Characters
Percent Sign Usage
Underscore Usage
Escape Characters
Case Sensitivity in Patterns
Regular Expressions
NULL Value Handling
IS NULL Testing
IS NOT NULL Testing
NULL Comparison Pitfalls
Three-Valued Logic
Sorting Results
ORDER BY Clause
Basic Sorting Syntax
Default Sort Order
Sort Directions
Ascending Order
Descending Order
Mixed Sort Orders
Multi-Column Sorting
Sort Priority
Secondary Sort Criteria
Sorting by Expressions
Calculated Field Sorting
Function-Based Sorting
NULL Value Sorting
NULLS FIRST
NULLS LAST
Default NULL Handling
Limiting Result Sets
Row Limitation Concepts
LIMIT Clause
MySQL Syntax
PostgreSQL Syntax
Row Count Specification
OFFSET Clause
Skip Row Functionality
Pagination Implementation
TOP Clause
SQL Server Syntax
Percentage Options
FETCH Clause
Standard SQL Syntax
FIRST and NEXT Options
Performance Considerations
Index Usage
Large Result Set Handling
Previous
2. SQL Fundamentals and Syntax
Go to top
Next
4. Data Manipulation Operations