Free Bank account in Germany – FREE Girokonto / Current Account

Which is the best free German bank account? Which bank account should you choose when living in Germany as an expat or foreigner? How to open a bank account in Germany? Online? Offline?