Pull Your Own Data: An Introduction to SQL

, Director of Community @ FirstMark Capital

Add To Cart
This class is no longer available.

Enrollment Closed

Unfortunately, this class is no longer available on Skillshare. Don't fret! There are hundreds of other classes out there for you to take.

Find a class

Class Project

Write Basic Data Queries

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

At a Glance

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

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

Matt Branigan

Matt Branigan

Very easy to understand and logically structured for someone who is not familiar with coding and syntax.

View all reviews