Data Science: SQL for Marketers
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
Are you looking to improve your technical marketing skills? Then take this course and learn how to use SQL for data analysis. Technical Marketers are an asset to any company and this course will equip you with the skills to delve into data independently and discover exactly what your customers are doing, which in turn will make you a much better marketer.Justin Mares will ensure that you understand SQL and can use it to an accomplished level, which will transform your marketing campaigns as you will have a knowledge of your customers through and understanding of the data. Many companies have placed an increased emphasis on SQL and request that there marketing leaders have a strong understanding of it.This course will enable you to write and query any SQL at the same level as any developer, you will also be able to understand SQL and implement in a way that will transform your marketing ability. You will be able to use it as a tool for gaining detailed information about your customers.
Facilities
Location
Start date
Start date
About this course
Over 4 hours of video content as well as 11 PDF resources to enhance your learning experience. The 6 Components that make up every SQL query a marketer will ever use Target your most profitable users, and create campaigns that will attract more like them 5 essential metrics you can use immediately How to effect a cohort analysis
Â
Anyone
None
Reviews
Subjects
- SQL
- Marketing
Course programme
Intro
Say hi to your fellow students!
Share your new course with your friends!
Welcome
What Is SQL?
Resources Section
Example SQL Query
Writing SQL Queries
Test Database
Introduction to Writing SQL Queries
Challenge: Using Select, From and Where
Answer: Using Select, From and Where
The Join Statement
Challenge: Using Join!
Answer: Using Join
Sorting and Limiting
Sorting and Limiting Challenge
Answer: Sorting and Grouping Challenge
Count and Other Functions
Setting up SQL Tools
Test Database and Downloadable Materials
Setting up SQL Tools
Setting Up SQL Tools
Using SQL Pro
Using SQL
Exercise 1: How Many Orders Has Each Customer Placed?
Exercise 1 Answer
Exercise 2: Where Does Your Best Customer Live?
Exercise 2 Answer
Exercise 3: Find the World's Most Popular Language
Exercise 3 Answer
Exercise 4: Find the Most Populous Cities in the World
Exercise 4 Answer
What Other Marketers Have Done With SQL
Conclusion
Conclusion
Thank You
Bonus Content
SQL- Lecture Slides
SQL Cheat Sheet
Become a Technical Marketer Ebook
Quiz
Course Quiz
Data Science: SQL for Marketers