Data Science: SQL for Marketers

Course details

• 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… 

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.

• Intro
• Say hi to your fellow students!
• Share your new course with your friends!
• Welcome
• What Is SQL?
• Resources Section
• Example SQL Query

• 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

• Test Database and Downloadable Materials
• Setting up SQL Tools
• Setting Up SQL Tools
• Using SQL Pro

• 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
• Thank You

• SQL- Lecture Slides
• SQL Cheat Sheet
• Become a Technical Marketer Ebook

• Course Quiz