Instead of focussing on current state, you focus on the changes that have occurred over time. It is the practice of modelling your system as a sequence of events.
Event Sourcing domain expert won't talk about “tables” and “joins”, they'll describe processes as the series of events that can occur and the rules applied to them.
Example: Stream - How to capture change of state - Change Data Capture (CDC)