SQL Bootcamp
11

Sunday, 11 December

10 am – 6 pm EST

GA NYC (Manhattan), Classrooms (4th floor)

10 East 21st Street
New York , NY 10010
$280 USD
Regular Ticket

Sold Out!

Get on the waitlist

Be the first to know if a spot becomes available.

Add me to the waitlist

Questions? Read our FAQs

SQL Bootcamp

11

Sunday, 11 December

10 am – 6 pm EST

GA NYC (Manhattan), Classrooms (4th floor)

10 East 21st Street
New York , NY 10010
$280 USD
Regular Ticket

Sold Out!

Get on the waitlist

Be the first to know if a spot becomes available.

Add me to the waitlist

Questions? Read our FAQs

About This Workshop

SQL provides powerful but reasonably simple tools for data analysis and handling. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. We will use a combination of lecture and in-class exercises to ensure that students leave with a working grasp of SQL fundamentals.

Takeaways

  • Background on SQL
  • Basic SELECT-FROM-WHERE statements
  • LIMIT clauses
  • Math operations and constant expressions in SELECT statements
  • Booleans and complex conditions in the WHERE clause
  • Pattern matching in the WHERE clause
  • NULL values
  • JOIN operations
  • Grouping and aggregations
  • HAVING clauses
  • ORDER BY clauses
  • Subqueries

Prereqs & Preparation

Basic technical aptitude and orientation to computers, and curiosity to learn new tools. Willingness to learn about a text-based/principle driven analytic tool with little real GUI support, and determination to push through the natural frustration of confronting new concepts.

We will be pausing to let students run and write queries of their own, so students should bring laptops with an installed SQL implementation Instructions for installing PostgreSQL / pgAdmin3 and connecting to AWS will be distributed prior to class.

About the Instructor

Jeremy Flattau Photo

Jeremy Flattau has worked at the intersection of social science and data science for the last seven years. He has led multiple non-profit organizations, started and directed his own data analytics firm, and worked for numerous organizations that make data-driven decisions, including the National Academy of Sciences and the New York City Department of Education. Jeremy currently serves as the Head of Data Quality and Content at Placemeter.
Jeremy has degrees from Brown University in political science and New School University in international development. In his free time, he enjoys cycling, rock climbing, and watching English football.

Refund Policy

Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 days before the scheduled event date. No refunds will be given after this timeframe.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.