❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [July 18th, 2023]
This course, SQL Fundamentals for Marketing Digital and Web Analytics, is designed to teach the fundamentals of data and SQL to marketers and marketing analysts. It is ideal for those who are already familiar with SQL and are looking to use it to conduct marketing analysis. The course uses MYSQL to demonstrate how SQL works, but the learnings and syntax are applicable to other databases such as Microsoft SQL Server and Oracle.
This course is a must-have for web analytics, digital analytics, and marketing analytics. It will help marketers and marketing analysts become independent of IT departments and make data-driven marketing decisions. It will also help resumes stand out and put candidates ahead of other similar applicants.
The instructor for this course is an experienced digital marketer and analyst with over 15 years of experience. He has trained people from diverse backgrounds and has worked with companies such as Microsoft, Starbucks, Wall Street Journal, ESPN, and T-Mobile. He holds an engineering degree and an MBA, and is an online instructor for the University of British Columbia, University of Washington, Bellevue College, and the Digital Analytics Association.
Course Syllabus
Introduction
Installation and Overview of SQL Environment (MySQL)
Database Fundamentals
Selecting the Data
Other Key SQL Statements
Some advanced Select Statements
Marketing Use Cases
Using data from the database in other programs
Database Manipulation
