SQL for Marketers (Udemy.com)

Learn How to Write SQL Queries and Conduct Data Analysis

( 201 Reviews )

Created by: Justin Mares

Produced in 2015

What you will learn

You'll learn how to write SQL queries as well as any developer.
By the end of this course, you'll understand what SQL is and how you can harness it to become a better marketer.
You'll have plug and play code snippets that will allow you to use SQL immediately to gather data about your customers.
You'll have a valuable new skill that will immediately make you a better, more data-driven marketer or growth hacker.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 74 / 100

Course Description

**UPDATED AS OF NOVEMBER 2015 - JOIN 9,000+ SUCCESSFUL STUDENTS!**
Become a technical marketer with this course on using SQL for data analysis. You'll learn:

Initial Setup and SQL Basics
The 6 Components that Make Up Every SQL Query
How to Use SQL to Query Any Database
Pre-built Queries You Can Run Today to Get Info About Your Customers

Technical marketers are in high demand and low supply. Being able to dive into data on your own, with no help from engineering, makes you a much better marketer. This is why SQL is so powerful - it allows you to see any data you want about anything your customers do. Knowing how to use SQL is literally a marketing superpower. As someone who can understand and use SQL, you'll be a (highly paid) marketing unicorn - able to dig into data and also execute high-level marketing campaigns. Many companies - including Udemy! - are now requiring that their marketing leaders have an understanding of SQL. Many marketers have tried to become "technical" - including me - but have failed over and over again after coming across resources meant only for engineers. I know I've had this issue - every SQL tutorial out there was created for developers, not marketers. Other tutorials include topics like creating a database, inserting data, managing tables, and other specifics that database administrators need to know. What if I told you that marketers only need to know a small amount of SQL to use it for analytics... and to run more profitable campaigns? Good news - This is the truth! This course is the best resource for marketers, growth hackers and product managers who want to get more technical and learn SQL. It's what I wish existed when I was going through tutorial after tutorial, sifting through lots of information that didn't apply to me and trying to learn on my own. And - best of all - you don't need to know programming or be technical to take this course. In fact, you don't have to be technical to know how to use SQL! SQL is simple enough that - just by learning a few concepts I'll cover in this course - you'll be able to use it for any kind of data analysis, cohort analysis or campaign breakdown. Everything I've put into this course are the product of years of teaching myself to program, understanding software technology and writing thousands of SQL queries for my own marketing and growth campaigns. The concepts and queries in this course are used every day by the marketing teams at companies like eBay, Moz, Udemy, HubSpot... you name it. I've used my knowledge of SQL to cut churn by more than 60% while running growth at developer-tools startup Airbrake (acquired by Rackspace), and to analyze and improve multiple profitable marketing campaigns. Knowing SQL has given me incredible insight into our customer base, and allowed our marketing team to move much faster than we did when we had to wait for engineering to give us the data we requested. But don't just listen to me. Here's what a few other people have said: "About four weeks back, I learned SQL, and it's been one of the greatest skills I could have ever acquired as a marketing / business guy at a startup." - Dinesh Thiru, Head of Marketing at Udemy "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!" - Benjamin Hoffman, course student Some things you'll learn in this course:

The 6 components that make up every SQL query a marketer will ever use
How to find your most profitable users, and how to make sure you run campaigns that attract more like them
5 key metrics you can measure right away after learning SQL
How to run a cohort analysis
How to discover the "aha" moment in your product that indicates whether a new user will stay an active customer or close their account
Access to pre-built queries you can start using immediately to learn about your customer base

Trust me, this is just a small sample of what you'll learn. By the end of this course you'll be more technical than 90% of marketers out there, and 100% better at your job. I'll also personally respond to any questions you may have as you go through the material, so there's no worry if you think this might be too technical or too confusing. I've included only the essentials marketers need to know, and created the course I wish I had years ago when I was learning this stuff. As a last bonus, I'll personally guarantee your satisfaction. If for any reason you don't think the course was valuable, I'll personally refund your entire purchase amount, no questions asked. See you inside, Justin Mares P.S. If you have (or are looking) to become a better marketer, investing a few dollars in yourself will be the best investment you ever make. And, if you don't like the course, I'll give you a 100% refund - my guarantee. Who this course is for:

This course is for any marketer or product manager who wants an understanding of what their users and customers are doing. SQL is a powerful tool you can use to become data-driven and make critical marketing and product decisions, and this course is the easiest way to learn it.
Marketers
Growth hackers
Product managers
Startup founders
Analytics users

Time: 1h

Instructor Details

Justin Mares

3.7 Rating
201 Reviews

Hi! My name is Justin Mares. I formerly ran growth at developer tools company Exceptional (acquired by Rackspace in March of 2013).

While there, I taught myself how to become a technical marketer and use tools like SQL to run important analyses on our customer data. Along with learning the basics of HTML, CSS and Python, I've found learning to become a more technical marketer has been one of the most valuable investments in myself I've ever made.

In addition, I'm the co-author of Traction Book, a book about how startups can get traction. For the book, we 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.
I also founded an ecommerce company, Kettle & Fire, that's on a multi-million dollar run rate in just a few months.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

3.7

201 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Susan Gallentine on 12/20/2020

Helpful overview of SQL! Being able to practice using the w3school sample database was especially helpful.

By Ian Bower on 8/8/2020

Doesn't seem like much content for the price so far

By Emma Simms on 6/24/2020

Really easy to follow and with lots of exercises to try out the queries yourself. Few points where I got stuck but easy to go back a couple of slides and understand where I was going wrong. Thank you!

By Kamden Schewitz on 6/15/2020

w3 school sql tryit is outdated by 4 versions as of May 2020, did not work.

By Omri Lustig on 4/14/2020

Did not see any value in the first task given to me.

By Renato Ferreira da Purificao on 2/23/2020

Gostei da sequncia dos assuntos e da forma como foram explicados em geral. A parte dos "Join" podia ter sido melhor explicada e mais pausadamente.

By Lee Wilson on 2/23/2020

This was a great introduction to SQL. I have been able to start doing some basic queries (with some help the developers on my team :) that have helped us improve our product!

By Taishi Kawamura on 11/22/2019

This is not what I was expecting. Free SQL courses on YouTube will do enough instead of this course. I feel like I wasted money.

By Sulamita Yang on 10/20/2019

There are a number of poor practices in this exercise. Just one example is in exercise sections, the 'group by' logic being used by the instructor is not sound, as he's pulling various columns he's only grouping by one of them, which can lead to a very misleading table view (e.g. you only group by country to look at highest orders, but in pulling in customername and ID as well, that total number is being iterated multiple times; best practice is you should only be pulling the countryname).

By Ayhan K. Isaacs on 8/18/2019