Apart from a few exceptions, all visa applications have to be submitted at the Consulate General in Lagos. Please find more information on the application procedure here.
For stays in Germany for over 90 days, a long term - or national - visa has to be applied for. Please find more information on the different types of long term visas and their requirements here.
Long term visa
For short term stays in Germany (less than 90 days) - e.g. visiting friends and family or attending a business meeting - a Schengen visa has to be applied for. Please find more information on the different categories and required documents here.
Short term visa