I have cat6 running inside a wall. i also have netgear and qnap with sfp+. if both connect using this module and cat6, can they talk with each other?

Yes, if both connect using this SFP+ to RJ45 copper module and cat6 cable, they can talk with each other. But it should be noted that the maximum length of cat6 cable is 30 meters.