SQL for Marketers and Marketing and Digital Analysts
3.9 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
43 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL for Marketers and Marketing and Digital Analysts to your Wishlist.

Add to Wishlist

SQL for Marketers and Marketing and Digital Analysts

Data is lifeblood of marketing - Learn SQL using mySQL to help you get the data for Marketing amd Digital Analysis..
3.9 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
43 students enrolled
Created by Anil Batra
Last updated 8/2017
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Write and Understand SQL to pull the data for marketing
  • Understanding of how data is stored in databases
View Curriculum
Requirements
  • Basic computer skills
Description

Data is a requirement these days to run effective marketing campaigns. Application of Big Data starts with understanding the fundamentals of data and SQL. 

Marketers and Marketing Analysts generally depend on the tools or IT department to help them pull the data for marketing purposes. IT leaves you hanging because they have other priorities as a results Marketing Analysts have to know how write SQL on their own so that they are not dependent on IT. This course is for those marketers who would like to know how to use SQL to conduct their marketing analysis.  

If you are trying for a job as a Marketing Analysts then this course is a must for you. This will help your resume shine and put you ahead of other similar candidates. The more you can handle technology and data these days the better it differentiates you from the rest of the pack.

The course uses MYSQL to show how SQL works but all the leanings and syntax are applicable to other databases such Microsoft SQL Server and Oracle as well.

Who is the target audience?
  • Marketers, Marketing Analysts, Digital Analyst, Web Analyst
Students Who Viewed This Course Also Viewed
Curriculum For This Course
18 Lectures
01:03:02
+
Introduction
1 Lecture 01:20

Marketers and Marketing Analysts generally rely on others to run SQL queries and get data. By learning SQL you will be doing a huge help to yourself so that you are not waiting on IT.  This will also allow you to understand what data is available.  This course is designed for Marketers by a Marketer. I won't do a lot of technical speak, just enough for you to understand.  In addition to learning SQL, you will learn how you can apply it your marketing USE CASES. If your use case is not covered, I will be happy to add it.

Preview 01:20
+
Installation and Overview of SQL Environment (MySQL)
3 Lectures 05:47

This lecture will show you where to download MySQL. We will be using MySQL in this course. Anything that is taught in this course is applicable to other database such as MS SQL Server, Oracle etc.

Preview 00:50

First step of learn SQL is to get familiar with the interface on where you will be writing SQL. This lecture teaches you exactly that.

Preview 03:35

This lecture will walk you through MySQL interface. This is where you will practice your SQL queries.

Preview 01:22
+
Database Fundamentals
2 Lectures 06:07

Learn about various elements of a database and learn what does relational database means. 

How databases are structured
03:09

Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.

Understanding a schema in MySQL
02:58
+
Selecting the Data
4 Lectures 15:38

SELECT is the statement that you will end up using majority of the time.  Learn how to write a SELECT statement to find the data that you are looking for.

Preview 02:39

Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.

Narrowing down your result set with WHERE clause
05:33

This lecture will show you how to sort the result set to give you the order that you need.

Sorting your result set
04:01

You will learn how to use numeric and date values to narrow down your result set along with string values to get exactly the result set that you need. You will learn about =, >,<, >=, <= and between clauses.

Using Numeric and Date Values to narrow down your result set
03:25
+
Other Key SQL Statements
3 Lectures 08:10

This lecture shows you how to add new data to your database using SQL.

Preview 01:06

Marketing database are full of erroneous data. This lecture will teach you how to fix the data issues when you find them.

Preview 03:23

Sometimes you have to delete some records. This lecture will show you how to do it.

Deleting records
03:41
+
Some advanced Select Statements
2 Lectures 11:16

Counting and summing are two common functions that Marketers need to do to identify their targets. Learn the syntax in this lecture.

Aggregating the data to do sum and count
04:32

You will learn how to join multiple tables and use of table alias.

Joining multiple tables to get desired result set
06:44
+
Marketing Use Cases
2 Lectures 12:40

This is one of the top questions that marketers need to figure out?  They want to know which customers are paying us the most money. Learn how to do this via SQL.  You will also learn a new  SQL syntax to find out TOP records.

Who are the top or bottom customers?
07:31

How many products do we have in each category?
05:09
+
Using data from the database in other programs
1 Lecture 02:04

Learn how to take the output of your SQL query and export it in CSV or Excel format.

Exporting data to CSV or Excel file
02:04
About the Instructor
Anil Batra
3.9 Average rating
27 Reviews
1,096 Students
2 Courses
Speaker, Instructor - Digital Marketing and Analytics Leader

Anil is a seasoned Digital Marketing and Analytics professional with 15 years of experience. He has worked with companies ranging from Fortune 50 to startups and has helped them improve marketing results. His customers include Microsoft, SmartMoney, ESPN, T-Mobile, Hoovers, RealNetworks, Starbucks, and TheStreet. He holds a B. Tech in Electronics and Communication Engineering from India and an MBA from University of Washington, Seattle.

Anil has taught and trained several Marketing and Analytics folks in past nine years of teaching at UBC, University of Washington and Bellevue College, and speaking engagements at various conferences as well as his blog. He teaches Digital Marketing, Digital Analytics, Google Analytics, Tableau and Social Media courses. He also served on the Board of Digital Analytics Association (DAA) and was instrumental in starting the DAA Symposiums.