My Course – SQL for Marketers
I created the go-to course for marketers and growth hackers wanting to learn SQL.Check out some of the reviews below:
“I loved this course. I was able to power through it within 3 hours and have a solid base of understanding for SQL. As a digital marketer, it’s important that I have access to my database and customer information BUT that I do not waste valuable developer resources. This course aims to bridge that gap by teaching you the tools you need to query your SQL database and running your own reports. I can’t recommend this course enough for SQL newbies. I now have a base of understanding of SQL and excited to use it at work this week! Thanks Justin!!” – Ben Hoffman
“This course was an excellent briefer into the complex world of pulling databases. I have been working in the world of online marketing for a while now, and I have been experimenting/dabbling with more technical skills. The most I have ever gotten into SQL was building Rails apps and accessing the console in order to pull data, but I never got into writing much longer queries to pull specific data. I highly recommend this course for any marketer that would like to grow in their technical expertise, as I believe that in the end, it will separate average marketers from excellent ones.” – Sheldon Smickley
Want the Course and Access to Pre-built SQL Statements You can Use for Data Analysis? The complete Bundle is $149.
Get the Complete Bundle NowWant to take your time and learn by doing? The Basic Course is $49.
Get the Basic Bundle NowResources
Below are the best SQL resources I’ve found online. These will be useful for further familiarizing yourself with SQL, understanding how you can use this powerful tool, and playing with some of the many technical resources out there.
http://snyderartdesign.com/tag/snyder-art-2-0/page/4/ Book – SQL for Marketers
expediently Web Resources:
- Udemy blog post on SQL queries
- Udemy blog post on why marketers should learn SQL
- Moz on why marketers should be technical
- Why to learn SQL and become a better marketer
Technical Resources:
- SQL Query builder by yours truly. This is a great tool to help you build SQL queries, even with very little knowledge.
- Tool to set up and manage a local SQL install (MAMP)
- Data generation tool that allows you to create fake user data to play around with in a test SQL database
- SQL validator
- SQL query tool Ideone
- Blog post about how to list all tables and describe all tables in SQL and Postgres
- Blog post from Chartio on how to perform a cohort analysis using SQL
- SQL Joins Explained by Chartio
- Sourcing cohort analysis data with SQL
Tutorials: