For a short stay trip to Germany that is less than 90 days in duration, a Schengen short stay visa will be needed. This is also known as a Type C visa.
For staying in Germany beyond 90 days, you will require a German long-stay visa. This is also referred to as a Type D visa.