SQL using MySQL for Marketing and Digital Analysis

Course Summary

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.

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.

Course Curriculum

Introduction
1 Lesson
- Introduction
  Start
Installation and Overview of SQL Environment (MySQL)
2 Lessons
- Installing mySQL
  Start
- mySQL Interface
  Start
Database Fundamentals
3 Lessons
- How Databases are structured
  Start
- Understanding a schema in mySQL
  Start
- New Lecture
  Start
Selecting the Data
4 Lessons
- Write Your First SQL statement to select the data from database
  Start
- Narrowing your result set
  Start
- Sorting your result set
  Start
- Using Numeric and Date Values to narrow down your result set
  Start
Other Key SQL Statements
3 Lessons
- Adding new data to the dataabse
  Start
- Updating existing records in the database
  Start
- How to delete records from the database
  Start
Some advanced Select Statements
3 Lessons
- How to select unique records from the database
  Start
- Aggregating the data to do sum and count
  Start
- Selecting data from multiple tables
  Start
Marketing Use Cases
2 Lessons
- Who are the top or bottom customers?
  Start
- How many products do we have in each category?
  Start
Using data from the database in other programs
2 Lessons
- Connecting with Data Visualization Tool (Tableau)
  Start
- Exporting data to CSV or Excel file
  Start
Database Manipulation
4 Lessons
- Creating a new table
  Start
- Importing Data From Excel into the database
  Start
- Advanced Table Commands
  Start
- Importing data from a CSV file
  Start

Anil Batra

Anil is a Digital Marketing and Analytics professional with 18+ years of experience. He has worked with companies ranging from startups to Fortune 500 and has helped them improve marketing results as well as develop data-driven culture. He has vast experience in Web, Email, Social, Display, Search, Paid Search, and CRM.
He holds a B. Tech in Electronics and Communication Engineering from India and an MBA from the University of Washington, Seattle.

Anil has taught and trained several Marketing and Analytics folks in past 18 years of teaching at UBC, University of Washington, and Bellevue College, and speaking engagements at various conferences as well as his blog. He conducts several training sessions and workshops on various topics in Digital Marketing and Digital Analytics. He has also served on the Board of Digital Analytics Association (DAA) and was instrumental in starting the DAA Symposiums.

Anil has worked and trained teams at companies that include, Microsoft, Estee Lauder, HCL, Finning, ZiplyFiber, T-Mobile, AT&T, Wunderman, Wall Street Journal, ESPN, Starbucks

Anil has taught over 40,000 students from 152 countries.

Course Pricing

Full Access
$97 USD
Buy Now