Ask HN: Learning SQL

I have been offered a position at a startup, primarily coding in sql. The only problem is I have never used sql before. Any advice for learning sql (mainly oracle, possibly postgres) will be helpful. There is only one I know of at the company who is a full time sql programmer - a full-time DBA, who works in a different location. My background: Python & C.