Hi Brian,
there are some simple things(if any are too obvious,sorry)
1) IMO there are more differences based on the size and depth of the body water than the "type"of water.
of course, deeper means more caution and attention to gauges(depth,spg, timer, etc).
Also there ocean has currents,while a quarry??
2) You'll probably need to carry a bit more weight( presuming you are not overweighted for fresh water.)
3) Don't drink the (salt) water! but bring water to drink.
4) The salt water may sting if it gets in your eyes-this is normal, and a very temporary. condition.
5) Let the DM (if there is one-if not it might be a good idea to hire one at first)know of your level of experience. Usually,they like to know in advance,m and can help you gain experience safely.
6)Generally,most sharks are more cool than a bother-generally.
7)If you are going to be diving form a boat-do a search of the board for "boat etiquette"(sp?)
8) (also for boat dives)-Think ahead re seasickness prevention. Be aware-it can happen to almost anyone.
9) As always, if you feel uncomfortable with a situation-you are NOT under any pressure to continue.
10) You might want to check in with some of the board members who live in Hawaii for more site specific info.
Good luck and enjoy your trip.
Mike
edited to add: I see some of the other posters have covered some of my suggestions-sorry for the repetition,but I type very slowly :06: