SQL Fundamentals for Marketing, Digital and Web Analytics

Learn SQL for Marketers with MySQL. Learn the only SQL required for Marketing, Digital and Web Analytics.

3.95 (142 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
3,970
students
1.5 hours
content
Mar 2024
last update
$49.99
regular price

What you will learn

Write and Understand SQL to pull the data for marketing

Grasp Database fundamentals

Understanding of how data is structures and stored in databases

Master common SQL commands used by Marketing analysts

Import data into MySQL from CSV and Excel files

Export data from MySQL into Excel files

Connect MySQL with Tableau for data visualization

Use Databases and SQL with confidence

Learn some common uses cases for Marketing, Web and Digital Analytics

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. 

If you are already familiar with SQL then you can skip this course. This course teaches you all the SQL you need as a Digital Marketing Analyst or  a Web Analyst.  This course won't go into advanced level SQL concepts as that is not required to your job as as a Digital Marketing Analyst/Web Analyst. I strongly believe in short and simple courses that can get you ready in few hours as opposed to days.

However, if you ever get stuck or need something that I don't cover in this course then feel free to reach out to me.

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.

This course is a must have for Web Analytics, Digital Analytics and Marketing Analytics.  This course will put you way ahead of other folks doing or seeking similar jobs. I have used the same course to train members of my team so you can be assured that this is tried and tested curriculum.

Why you should learn from me?

I have been in Digital Marketing and Analytics for over 15 years. I have trained people from diverse backgrounds and have converted them into high performing Digital Marketers and Analysts.  I understand both the technology and marketing side of business.  I have dealt with many analytics technologies way before Google Tag manager existed and know the inner working of Digital Analytics. 

I have extensively worked with companies like Microsoft, Starbucks, Wall Street Journal, ESPN, T-Mobile to name few and helped them Data Driven Marketing Decisions.

In addition, I have developed various course and taught students from all over the world. I am online instructor for University of British Columbia (Canada), University of Washington (USA), Bellevue College (USA) and Digital Analytics Association.

I have an engineering degrees and an MBA.


Content

Introduction

Introduction

Installation and Overview of SQL Environment (MySQL)

Installing mySQL
My SQL Interface

Database Fundamentals

How databases are structured
Understanding a schema in MySQL
Missing Sakila Database and how to solve it

Selecting the Data

Write your first statement to select the data
Narrowing down your result set with WHERE clause
Sorting your result set
Using Numeric and Date Values to narrow down your result set

Other Key SQL Statements

Adding new records to the database
Updating exiting records
Deleting records

Some advanced Select Statements

Aggregating the data to do sum and count
Joining multiple tables to get desired result set

Marketing Use Cases

Who are the top or bottom customers?
How many products do we have in each category?

Using data from the database in other programs

Exporting data to CSV or Excel file
Connecting with Data Visualization Tool (Tableau)

Database Manipulation

Creating a table
Few more table manipulation commands
Importing data from a CSV file - Example uses Affiliate data
Importing data from Excel to mySQL
Bonus Lecture

Screenshots

SQL Fundamentals for Marketing, Digital and Web Analytics - Screenshot_01SQL Fundamentals for Marketing, Digital and Web Analytics - Screenshot_02SQL Fundamentals for Marketing, Digital and Web Analytics - Screenshot_03SQL Fundamentals for Marketing, Digital and Web Analytics - Screenshot_04

Reviews

Jo
October 4, 2023
Veel te beperkt, vreselijke ondertitels, niet vlot gebracht. Dit was een absolute miskoop. Ronduit slaapverwekkend.
Brenda
June 8, 2023
Very good course for getting started with MySQL. Quick lessons get to the point and teach the things that are important. The lessons are short and give you just what you need to know.
Pierre
August 2, 2021
I find the course easy to follow and the instructor speaks slowly and in simple terms. This is really helpful!
Valentina
April 4, 2021
Installation phase was super hard, not a lot of support if you run into issues which there were a lot of us. Professor could have mentioned that these are "connectors" and you need to download the individual softwares in order to run this. Also have mentioned the version he's using. A huge headache, my loss of excitement is great right now.
Suhas
October 14, 2020
the concept of Schema needs to be better explained (Primary keys and Foreign keys) with small example tables. My wife who is an SW developer, explained these terms to me in better detail.
Tatjana
April 2, 2020
Great intro to SQL, helps to gain an understanding of what's possible with it, and feel confident about the direction of further development you should embrace. I'd add also some general information about how schemas work and are created, and also how to use databases remotely. Otherwise, highly recommended for complete beginners, like me.
Joseph
February 4, 2018
Excellent course!! The instructor is very knowledgeable about the subject matter and is able to present the concepts in a way that is easily understandable. The presentation is very detailed yet concise, which is greatly appreciated on a topic which could lend a instructor to be to overly verbose and euphemistic (indirect). I feel ready to implement the techniques and knowledge gained from the course. I highly recommend this course and the instructor.
Chiawen
January 17, 2018
Love this course!!! I hope you will offer more classes with examples of real world SQL, Tableau for Marketing Analytics, Digital and Web Analytics.
Nemani
November 14, 2017
Nice delivery of lectures. Would finish them all today! Some videos have inconsistent audio track volume in between them though.
Mirko
November 7, 2017
Another Awesome SQL class using MySQL to learn how to work with databases. Great class. The instructor gives you the basic foundation to understand how to use MySQL and work with databases. From here you can go to other classes and advance your knowledge and abilities. Great into class for people, esp without any prior DB experience. A+
Viktor
November 2, 2017
I check first few videos and they are really good, he is explaining everything in details and on top of that still everything is clear and understandable.
Mukesh
October 22, 2017
I like the simple approach of this course. I need to understand basic SQL and this course has done a great job. I can now start using SQL!!!
Meng
March 29, 2017
As a product manager, I find this course extremely helpful and relevant to my everyday work. The ability to pull data from the backend to make product or marketing decisions is very critical. Anil jumped straight to the basic skills I need without too much technical non-sense, I can get hands-on learning quickly. The last section is very practical, hope to see more in-depth courses based on learning from use cases.
Pankaj
August 11, 2016
I am IT professional with more than 15 years of IT experience. During my career, I am seeing first time such precised and focused content needed for you to get going fast. This course really touches the very needed skills someone should have to quickly jump to the real problems in industry. The contents are so simplified that anyone who doesn't have IT background can grab the SQL skills quickly. I strongly recommend this course to others.
Rohan
August 10, 2016
This course is really detailed and insightful and teaches us SQL in a very simple and structured way. It's been over 5 years since I worked on SQL and this was a great refresher. I'm sure this will be a great course even for beginners who are trying to learn SQL to become more self sufficient as its very easy to follow.

Coupons

DateDiscountStatus
8/2/201995% OFF
expired

Charts

Price

SQL Fundamentals for Marketing, Digital and Web Analytics - Price chart

Rating

SQL Fundamentals for Marketing, Digital and Web Analytics - Ratings chart

Enrollment distribution

SQL Fundamentals for Marketing, Digital and Web Analytics - Distribution chart
915512
udemy ID
7/26/2016
course created date
8/2/2019
course indexed date
Bot
course submited by