The different isolation levels behave in very different ways, and which one you will want to use depends on your database and on the operations you are performing. The following set of tutorials will help you determine which isolation levels are suitable for different tasks.
Tutorial: dirty reads
Tutorial: non-repeatable reads
Tutorial: phantom rows
Tutorial: practical locking implications