Pull Your Own Data: An Introduction to SQL

, Director of Community @ FirstMark Capital

Add to Cart $20
Get 20% off with Membership

Save 20% With Membership

Become a member to get unlimited access to hundreds of select classes and 20% off all other online classes.

Learn More

About the Class

SQL is the computer language used to access data in most databases. And, according to this blog post, "it’s been one of the greatest skills I could have ever acquired as a marketing / business guy at a startup."

This class is intended for those with absolutely no SQL experience whatsoever, but want to learn. Here are some common symptoms that can be cured by learning SQL:

  • you are always asking Engineers to get data for you
  • Excel can’t handle all of the data you’re working with
  • you’re a web designer that wants to start working with databases
  • you like to learn new things

By the end of the class you'll be able to write basic to intermediate queries, which means: 

  • You can get raw data for yourself -- quickly
  • You can perform sophisticated analysis of millions of rows of data
  • You can calculate your sales by month, you most profitable product, your most loyal customer, and so on

Here is what we will cover in the class:

  • How SQL databases are structured
  • The types of information that databases store
  • How to access rows in a database
  • How to filter a database for only those rows that meet certain criteria
  • How to join information across multiple tables in a database
  • How to perform mathematical operations that analyze and summarize data

We'll be using a sample set of e-commerce data to write the data queries that you can later apply to any set of data, once you get your hands on it!

All you need to bring is a laptop -- we'll practice SQL using a web-based database. Note: SQL is a language used in MySQL, Oracle, Postgres, etc. Each system implements SQL slightly differently, but the basic queries we'll be covering will work on any of these systems.

More Information

No prior knowledge is required for this class. You only need a computer with internet access.

Level: Beginner

School: Technology

Master real-world
skills taught by
industry leaders.

Hundreds of classes
for $9.95 a month.

Start 7-Day Trial

At a Glance

  • Non-Membership Class
  • 3 Video Lessons
  • 285 Students
  • 93% Positive Reviews (15)
  • Self-Paced Online Class
  • 14-Day Money Back Guarantee

Class Project

Write Basic Data Queries

View all projects

About the Teacher

Dan Kozikowski

Dan Kozikowski

Director of Community @ FirstMark Capital

I’m the Director of Community at FirstMark Capital. I’ve taught nearly 400 students on Skillshare and am a Master Teacher, a distinction which only a small group of teachers have. My c...

93% Positive Reviews

Arun Thamizhvanan

Arun Thamizhvanan

Simple and very effective way of learning to pull your own data from SQL

View all reviews

Add to Wishlist