Do you have an EPC card? The information is on the website, most courses are offering summer memberships at the moment otherwise Sharjah and Montgomery are very reasonably priced.
I am a weekday airline member of the Dubai Creek, which costs about half of what you will pay at Emirates golf club, send me a PM if you would like more details.