This is why Structured Query Language (SQL) is so powerful - it allows you to see all your customers’ data and make decisions based on accurate analysis. Knowing how to use SQL is literally a marketing superpower, and that’s exactly what this course will teach you!
The concepts and queries in this course are used every day by the marketing teams at successful companies like eBay, Moz and HubSpot.
An introduction to what the course is about and why it's important
A video introducing the importance of SQL
Videos explaining what, why and how SQL works for marketers
Modules explaining how SQL changes marketers' lives
A case study and some advice for writing your first query
How SQL is similar and different to SQL
Modules demonstrating how to write queries
How to query databases using SQL
A couple of exercises to get you practicing using queries
How to script and report using SQL
A video wrapping up the course
An video explanation of how to use Chartio to perform data analysis
A video explaining how to use the Google query creator introduced in Section 3, Unit 3
Justin formerly ran growth at developer-tools company Exceptional (acquired by Rackspace in March of 2013). At Exceptional, he was responsible for growth and revenue across three separate developers tools products - Exceptional, Airbrake and RedisToGo.
While there, he built and managed an inside sales team in Vegas, cut churn by more than 60%, tripled organic traffic, improved conversion rates through a series of A/B tests and doubled average revenue per customer. In this role selling to developers, he also taught himself how to program (poorly), use tools like SQL and R, and familiarised himself with the entire stack of web technologies.
He has also founded two other companies, one of which was acquired.
Justin is also the co-author of Traction Book, a book about how startups can get traction. For the book, he interviewed Jimmy Wales (founder of Wikipedia), Paul English (founder of Kayak), Dharmesh Shah (HubSpot founder) and pulled together an actionable framework for how startups should think about getting traction and distribution.