Data Analytics: SQL for newbs, beginners and marketers
4.1 (1,277 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,869 students enrolled

Data Analytics: SQL for newbs, beginners and marketers

Dominate data analytics, data science, and big data
4.1 (1,277 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,869 students enrolled
Last updated 6/2020
English [Auto]
Current price: $41.99 Original price: $59.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Know how to answer all of their marketing-related questions using a SQL query
  • Understand what a relational database is
  • How to install SQL on Mac, Linux, or Windows
  • How to create a table
  • How to import data into a table
  • How to query a table
  • How to insert into, update, and delete from a table
  • Speed things up using indexes
  • Join tables together to merge data
  • Aggregate data using count, sum, and average
  • Determine where in the sales funnel customers are being lost
  • Chart your year over year revenue
  • Group and sort sales by location
  • Use SQL on Spark
  • Install Spark
  • Create a Spark cluster on AWS EC2
  • You should you how to open a terminal / command line shell. All the examples will be done here.

It is becoming ever more important that companies make data-driven decisions.

With big data and data science on the rise, we have more data than we know what to do with.

One of the basic languages of data analytics is SQL, which is used for many popular databases including MySQL, Postgres, SQLite, Microsoft SQL Server, Oracle, and even big data solutions like Hive and Cassandra.

I’m going to let you in on a little secret. Most high-level marketers and product managers at big tech companies know how to manipulate data to gain important insights. No longer do you have to wait around the entire day for some software engineer to answer your questions - now you can find the answers directly, by yourself, using SQL!

In this course, SQL for marketers, we'll start from the basics - installing SQL onto your Mac, Linux, or Windows machine and explaining what a relational database is. Next, we'll look at basic tasks like creating tables and loading data into those tables. We will look at a wide variety of SQL commands and I will show you how to speed things up using indexes.

Once you know all the SQL commands we will start doing advanced examples - answering questions marketers and business people often have, like where are customers dropping off in our sales funnel? And which of our locations has the highest revenue?

In the last section, we'll do Advanced SQL queries on Spark, the big data framework that is the successor to MapReduce and also runs on top of Hadoop. I will teach you how to install Spark, create a cluster very quickly on Amazon EC2, and run SQL queries, allowing you to apply everything you learned up until this point in a big data environment.

Do you want to know how to optimize your sales funnel using SQL, look at the seasonal trends in your industry, and run a SQL query on Hadoop? Then join me now in my new class, SQL for marketers! Dominate data analytics, data science, and big data!

TIPS (for getting through the course):

  • Watch it at 2x.

  • Take handwritten notes. This will drastically increase your ability to retain the information.

  • Ask lots of questions on the discussion board. The more the better!

  • Write code yourself, don't just sit there and look at my code.

Who this course is for:
  • This course is for not only marketers but anyone who wants to be able to answer data-related questions on their own
  • Students who want a different approach to learning SQL
  • Professionals who are exposed to data but can't yet leverage its power
  • Developers who build web-applications but don't yet know how to use a database backend
  • Product managers who want to make data-driven decisions
Course content
Expand all 30 lectures 01:28:58
+ What is a relational database? Basic commands
8 lectures 18:24
Basic commands
Querying a table
Creating a table
Importing Data on Windows
Modifying a table’s structure
Suggestion Box
+ Indexes and speed comparison
2 lectures 05:43
Speeding things up with indexes
Index Example in the Console
+ Modifying a table's data
2 lectures 04:20
Insert / Update / Delete
What is CRUD?
+ Joining tables
2 lectures 03:39
Joining or Merging tables together
Joins in the console
+ Aggregating, grouping, and sorting. Real marketing queries.
3 lectures 08:07
Count, Distinct, Sum, Min, Max, Avg
Group by, Sort, Limit
Funnels, YOY revenue, and Sales by Location
+ Advanced: SQL on Spark (Optional)
2 lectures 07:15

How to install Spark locally, how to load data into Spark for making SQL queries, and some boilerplate code for writing any SQL query on a Spark table.

Spark SQL
Create your own Spark cluster on Amazon EC2
+ Further Knowledge, Practice and Exercises
4 lectures 16:34
How to load the extra dataset (tab-separated tables)
The "IN" Keyword
The "BETWEEN" Keyword
Interview Question-Style Exercises
+ Appendix / FAQ
1 lecture 10:24
How to Succeed in this Course (Long Version)