Netherlands here. You can get a permit for sport shooting or hunting. Guns for self defense are not allowed.
Any violence used to catch a burglary or somebody breaking in has to be a reasonable response. So if they have no weapon and you hit them with a baseball bat you are actually in trouble. This can be very frustrating but there is a point to it. Minimal violence is the name of the game here.
Even the police are trained to talk first and only resort to violence when absolutely necessary. Drawing a weapon as a cop means filling out paperwork and there will be a review to make sure it was the right move.
However, for sport shooting you have to join a shooting club and shoot competition. The first year you can only shoot with air guns.
If you get a gun for sport shooting, you have to have a safe for the weapon, grounded to the wall and the floor. It will be inspected and police can check on you at random times.
Ammo and weapon should be separated at all times, transport can only be done in cases.
You are not allowed to load the gun until you are basically ready to shoot. If you have to shoot five times, you are not allowed to load six shots. You can have a maximum of 5 guns. Assault rifles are not legal I think. There are no competitions with them, so you have no reason to buy them.
The rules are strict. We only had one big "recent" shooting and I think it is at least 10 years ago. I like it.
Of course criminals stil have guns, but for a random guy who lost his job and want to take revenge it is neigh impossible to just buy an AK47 and shoot all his colleagues. Quite a safe feeling actually.