While much of Nietzsche's writings are available (either in German or translated into English) on line, there are almost no really good secondary sources. There are some articles in the Stanford Encyclopedia of Philosophy, always preferable to those in Wikipedia, about N, and if you research Google Scholar or Google Books, you will find a few of the books I mentioned in the Nietzsche Bibliography post.
I would not gladly offer a psychological interpretation of N's attitude toward women, except to say that in life, they were far different than one would suspect just from reading his books (N said that he was one thing, his books another). I suspect that biographies of the following women might provide some insight:
Matwida von Meysenbug
If one considers women as women, what can one know??? If one looks at numbers alone, how many can a man know??? Four is not too many, and it is certain that Nietzsche knew more, or at least, knew of more... Perhaps he had the women of literature... Perhaps he knew his landlord's daughter who used to spy at him through the key hole... But if a man knows fifty, or a hundred, or two hundred, and relates to them more or less, as an equal, sharing space, sex, food, conversation and communication then what can a man know of women??? Nietzsche knowing so few was quick to pass judgement on the better half of humanity, and in doing so never seem a bigger fool...What could he know, and what must he have only imagined??? Morrison said it better: Women seem wicked when you're unwanted.. A man only knows the women he knows, and seldom that many, and for the pleasures of their company a man must endure many a mystery...