Complete SQL Bootcamp for Data Science, Analytics, Marketing

Master SQL for Job Interview Preparation, Data Analysis, Big Data, and Business Intelligence

Register for this Course

$19.99 $199.99 USD 90% OFF!

Login or signup to register for this course

Have a coupon? Click here.

Course Data

Lectures: 32
Length: 2h 07m
Skill Level: All Levels
Languages: English
Includes: Lifetime access, certificate of completion (shareable on LinkedIn, Facebook, and Twitter), Q&A forum

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!



Suggested Prerequisites:

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


Tips for success:

  • Use the video speed changer! Personally, I like to watch 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!
  • Don't get discouraged if you can't solve every exercise right away. Sometimes it'll take hours, days, or maybe weeks!
  • Write code yourself, this is an applied course! Don't be a "couch potato".

Testimonials and Success Stories


I am one of your students. Yesterday, I presented my paper at ICCV 2019. You have a significant part in this, so I want to sincerely thank you for your in-depth guidance to the puzzle of deep learning. Please keep making awesome courses that teach us!

I just watched your short video on “Predicting Stock Prices with LSTMs: One Mistake Everyone Makes.” Giggled with delight.

You probably already know this, but some of us really and truly appreciate you. BTW, I spent a reasonable amount of time making a learning roadmap based on your courses and have started the journey.

Looking forward to your new stuff.

Thank you for doing this! I wish everyone who call’s themselves a Data Scientist would take the time to do this either as a refresher or learn the material. I have had to work with so many people in prior roles that wanted to jump right into machine learning on my teams and didn’t even understand the first thing about the basics you have in here!!

I am signing up so that I have the easy refresh when needed and the see what you consider important, as well as to support your great work, thank you.

Thank you, I think you have opened my eyes. I was using API to implement Deep learning algorithms and each time I felt I was messing out on some things. So thank you very much.

I have been intending to send you an email expressing my gratitude for the work that you have done to create all of these data science courses in Machine Learning and Artificial Intelligence. I have been looking long and hard for courses that have mathematical rigor relative to the application of the ML & AI algorithms as opposed to just exhibit some 'canned routine' and then viola here is your neural network or logistical regression. ...

READ MORE

I have now taken a few classes from some well-known AI profs at Stanford (Andrew Ng, Christopher Manning, …) with an overall average mark in the mid-90s. Just so you know, you are as good as any of them. But I hope that you already know that.

I wish you a happy and safe holiday season. I am glad you chose to share your knowledge with the rest of us.

Hi Sir I am a student from India. I've been wanting to write a note to thank you for the courses that you've made because they have changed my career. I wanted to work in the field of data science but I was not having proper guidance but then I stumbled upon your "Logistic Regression" course in March and since then, there's been no looking back. I learned ANNs, CNNs, RNNs, Tensorflow, NLP and whatnot by going through your lectures. The knowledge that I gained enabled me to get a job as a Business Technology Analyst at one of my dream firms even in the midst of this pandemic. For that, I shall always be grateful to you. Please keep making more courses with the level of detail that you do in low-level libraries like Theano.

I just wanted to reach out and thank you for your most excellent course that I am nearing finishing.

And, I couldn't agree more with some of your "rants", and found myself nodding vigorously!

You are an excellent teacher, and a rare breed.

And, your courses are frankly, more digestible and teach a student far more than some of the top-tier courses from ivy leagues I have taken in the past.

(I plan to go through many more courses, one by one!)

I know you must be deluged with complaints in spite of the best content around That's just human nature.

Also, satisfied people rarely take the time to write, so I thought I will write in for a change. :)

Hello, Lazy Programmer!

In the process of completing my Master’s at Hunan University, China, I am writing this feedback to you in order to express my deep gratitude for all the knowledge and skills I have obtained studying your courses and following your recommendations.

The first course of yours I took was on Convolutional Neural Networks (“Deep Learning p.5”, as far as I remember). Answering one of my questions on the Q&A board, you suggested I should start from the beginning – the Linear and Logistic Regression courses. Despite that I assumed I had already known many basic things at that time, I overcame my “pride” and decided to start my journey in Deep Learning from scratch. ...

READ MORE

By the way, if you are interested to hear. I used the HMM classification, as it was in your course (95% of the script, I had little adjustments there), for the Customer-Care department in a big known fintech company. to predict who will call them, so they can call him before the rush hours, and improve the service. Instead of a poem, I Had a sequence of the last 24 hours' events that the customer had, like: "Loaded money", "Usage in the food service", "Entering the app", "Trying to change the password", etc... the label was called or didn't call. The outcome was great. They use it for their VIP customers. Our data science department and I got a lot of praise.

Lectures

Introduction and Outline

2 Lectures · 13min
  1. Introduction and Outline (07:12) (FREE preview available)
  2. How to Succeed in this Course (05:52)

Survey of SQL databases and Installation of SQLite

3 Lectures · 07min
  1. Overview of SQL databases (02:44)
  2. Installing SQLite on Mac, Linux, and Windows (01:08)
  3. Visual Walkthrough of Windows Installation (03:13)

What is a relational database? Basic commands

8 Lectures · 18min
  1. What’s a relational database? (01:09)
  2. How to load the data used in this class (02:22)
  3. Basic commands (01:07)
  4. Querying a table (02:29)
  5. Creating a table (01:29)
  6. Importing Data on Windows (04:14)
  7. Modifying a table’s structure (02:30)
  8. Suggestion Box (03:03)

Indexes and speed comparison

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

Modifying a table's data

2 Lectures · 04min
  1. Insert / Update / Delete (02:51)
  2. What is CRUD? (01:30)

Joining tables

2 Lectures · 03min
  1. Joining or Merging tables together (02:18)
  2. Joins in the console (01:21)

Aggregating, grouping, and sorting. Real marketing queries.

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

Advanced: SQL on Spark

2 Lectures · 07min
  1. Spark SQL (04:39)
  2. Create your own Spark cluster on Amazon EC2 (02:24)

Further Knowledge, Practice and Exercises

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

Appendix

4 Lectures · 43min
  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)
  4. Where to get discount coupons and FREE deep learning material (05:31)
This website is using cookies. That's Fine