Data Analytics: SQL for newbs, beginners and marketers

Dominate data analytics, data science, and big data

Register for this Course

$19.00 $120.00 USD 84% OFF!

Login or signup to register for this course

Have a coupon? Click here.

Course Data

Lectures: 31
Length: 01h 52m
Skill Level: All Levels
Languages: English
Includes: Lifetime access, 30-day money back guarantee

Course Description

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!



NOTES:

All the code for this course can be downloaded from my github:

https://github.com/lazyprogrammer/sql_class

Make sure you always "git pull" so you have the latest version!



HARD PREREQUISITES / KNOWLEDGE YOU ARE ASSUMED TO HAVE:

  • You should you how to open a terminal / command line shell. All the examples will be done here.


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.

Lectures

Why you should stop depending on engineers and learn SQL

  1. Why you should stop depending on engineers and learn SQL (01:48) (FREE preview available)
  2. Outline of this course (01:44)
  3. How to Succeed in this Course (03:13)

Survey of SQL databases and Installation of SQLite

  1. Overview of SQL databases (03:31)
  2. Installing SQLite on Mac, Linux, and Windows (01:07)
  3. Visual Walkthrough of Windows Installation (03:13)

What is a relational database? Basic commands

  1. What’s a relational database? (01:08)
  2. How to load the data used in this class (02:19)
  3. Basic commands (01:08)
  4. Querying a table (02:25)
  5. Creating a table (01:29)
  6. Importing Data on Windows (04:13)
  7. Modifying a table’s structure (02:29)

Indexes and speed comparison

  1. Speeding things up with indexes (03:08)
  2. Index Example in the Console (02:37)

Modifying a table's data

  1. Insert / Update / Delete (02:48)
  2. What is CRUD? (01:30)

Joining tables

  1. Joining or Merging tables together (02:19)
  2. Joins in the console (01:21)

Aggregating, grouping, and sorting. Real marketing queries.

  1. Count, Distinct, Sum, Min, Max, Avg (01:18)
  2. Group by, Sort, Limit (02:02)
  3. Funnels, YOY revenue, and Sales by Location (04:34)

Advanced: SQL on Spark

  1. Spark SQL (04:36)
  2. Create your own Spark cluster on Amazon EC2 (02:24)

Further Knowledge, Practice and Exercises

  1. How to load the extra dataset (tab-separated tables) (06:19)
  2. The IN Keyword (02:39)
  3. The BETWEEN Keyword (01:42)
  4. Interview Question-Style Exercises (05:51)

Appendix

  1. How to Succeed in this Course (Long Version) (10:25)
  2. What order should I take your courses in? (part 1) (11:19)
  3. What order should I take your courses in? (part 2) (16:07)