Data Science: SQL for Marketers

Course

Online

Save 51%
£ 14 VAT inc.

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

Online

Start date

Different dates availableEnrolment now open

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • SQL
  • Marketing

Course programme

Introduction
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

£ 14 VAT inc.