A Category D visa is a long-term visa. It allows you to stay in Germany for more than 90 days. It's also called a National Visa or a residence permit.

The student visa, the job seeker visa, the freelance visa, the work visa, the Blue Card and the artist visa are types of Category D visas. The tourist visa is not a Category D visa.