List of topics for learning and test:
- Introduction to SQLite
- SQLite Data Types
- Creating a Database
- Creating Tables
- Primary Keys and Constraints
- Inserting Data
- Querying Data with SELECT
- Filtering Data with WHERE
- Sorting Data with ORDER BY
- Updating Records with UPDATE
- Deleting Records with DELETE
- Aggregating Data with GROUP BY
- JOIN Operations in SQLite
- Subqueries
- Indexing and Optimization
- Transactions in SQLite
- Views in SQLite
- Triggers
- Working with BLOB Data
- Handling NULL Values
- Date and Time Functions
- String Functions
- Using SQLite with Programming Languages
- Error Handling in SQLite
- SQLite Command-Line Interface (CLI)