Intermediate Golf Memberships

Title says it all. looking for golf memberships in the local Calgary area for intermediate (30-35) category, curious if anyone has any recs for best value out there (if any)? Best courses? Best demographic (i.e. other young professionals)?