SQLAlchemy relationships connect Python classes to database tables using foreign keys and the relationship() function. Key concepts include one-to-many mappings, cascade options for deletes, loading strategies like lazy and eager loading, and enforcing data integrity with unique and foreign key constraints.