Experience with SQL test at Hubspot?

Has anyone taken it? Any tips? I’m well-versed in querying via joins, subqueries, etc but don’t know a lot about table creation / data engineering. Wondering what I should brush up on ahead of time.

@Hubspot
@Data
@New
Add a comment
Amazon fejj zebos Sep 9, 2019

It's basically designing a few related tables and knowing the ins and our of keys/indexes. Last time I checked all Hubspot interview questions were on Glassdoor.

Cox Automotive VVTN45 OP Sep 10, 2019

Appreciate it

Cox Automotive VVTN45 OP Sep 13, 2019

Follow up if anyone needs info in future. This was for analytics role (non-SWE). Test was basic. Aggregations in select statements, simple joins, a couple sub queries. Nothing on table management or keys. If you regularly query SQL databases you will be fine.

The Trust for Public Land BeanJuice Sep 18, 2019

Are you moving to the next step?

Cox Automotive VVTN45 OP Sep 19, 2019

Not sure, haven’t received feedback yet. Few other opportunities in the works. Did you apply to them?

The Trust for Public Land GhostBeef Sep 19, 2019

No, just curious. Starting my own job search soon.