How should unit test be written for data transformation?

Usually the workflow I have is as follows:

1. Perform SQL query on database,
2. Load it into memory
3. Transform data based on logic foo()
4. Insert the transformed data to a table in a database.

How should unit test be written for this kind of workflow? I'm really new to testing.

Anyway, I'm using Python 3.4.