Скачать или смотреть CTD - Advanced SQL and Database Integration.

Subqueries: Embedding queries within other SQL statements for dynamic filtering or calculations.
Complex JOINs: Using INNER and LEFT JOINs across multiple related tables.
Aggregation Functions: Using MIN(), MAX(), AVG(), COUNT() with GROUP BY.
Aggregation with HAVING: Filtering grouped results using HAVING after aggregation.
Performance Optimization: Creating indexes to speed up frequent queries.
Transactions and Rollbacks: Ensuring consistency with BEGIN, COMMIT, and ROLLBACK.
Parameterized Queries: Preventing SQL injection using safe input handling with placeholders.
Window Functions: Applying RANK(), ROW_NUMBER(), and OVER() for row-level analytics.
Date and Time Functions: Calculating durations and extracting date components using JULIANDAY() and related functions.
Python Integration: Writing and executing SQL queries within Python scripts using sqlite3.