I am not sure if that is the lens that you wanted to link to - but that is a 12-24mm wide angle lens that is great for taking pictures of landscapes - but not ideal for macros of fish or frogs.
For Nikon macros - you have a couple of good options. First thing you want to consider is the working distance (how much space between you and the subject). There are a couple of common ranges available:
50-60mm - good for inanimate objects, can be harder for live subjects as you need to be close - and they may get spooked
90-105mm - this is my go to distance. It offers you the benefits of a little more working distance - but not too much (i.e. a very heavy lens)
150-180mm - these lenses can be fun - and great for really flighty subjects, but the lenses are bulky and heavy - and take practice to use without a tripod/monopod or stabilization.
I have a Sigma 180mm that I enjoy - but my Nikkor 105mm gets more use.
As for specific lenses - you have options:
I like the Nikkor 105mm. You can save some money and get the older non-VR lens. I can't say enough good things about this lens.
http://www.kenrockwell.com/nikon/105af.htm
I don't own them - but I have heard really good things about the Tamron 90mm and the Sigma 105mm DG macro.
If you want the shorter focal length - then you are still in good shape with either Nikon or Sigma (haven't read much about the other lenses).
Like I mentioned - I own the 180mm Sigma - and I really like the quality and build of the lens - and I have heard similar things about the others.
For really good lens reviews - check out
http://www.fredmiranda.com/reviews/