Questions about this class?
Get help now from an expert!
Course Details
$975 30 seats left
Start Date:

Tue, Jun 20, 10:00am - Jun 22, 5:00pm Eastern Time ( 3 sessions )

Next start dates (4)

Midtown, Manhattan
185 Madison Ave 3rd Fl
Btwn E 34th & E 35th Streets
New York, New York 10016
Purchase Options
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 30

What you'll learn in this data science course:

Learn SQL fundamentals including data types and queries.

Why SQL?

Upwards of 90% of time on data wrangling is spent cleaning and manipulating data. With SQL you can easily address these challenges with English-like queries to a database. The gap between the supply and demand of people skilled in SQL is huge. As nearly every industry is moving toward being more data-driven, having this skill will give you a larger role in decision-making wherever you work.

You’ll be introduced to foundational concepts like tables, data types, and queries. Once you understand the basics of viewing tables, you’ll be introduced to more advanced querying techniques like filtering and aggregating. You will be able to drill down into specific cases or step back and see larger patterns. You’ll also learn how to combine information from different tables using join statements and views. The final day of the course will cover advanced techniques like creating subqueries and using timestamp functions.

This course will use Postgres, an advanced open-source database. Concepts from this course will apply equally to other databases such as MySQL and SQL Server, with the minor syntax differences noted during class.

What You’ll Learn:

  • Explore and alter data using a graphical user interface
  • Write queries to search through tables programmatically
  • Understand different data types and converting between them
  • Combine information across tables with join statements
  • Advanced techniques like subqueries and timestamp functions

Learn more about SQL Bootcamp at Practical Programming.

Still have questions? Ask the community.

Refund Policy

To reschedule or cancel, email us at [email protected]

All courses include a non-refundable registration fee (10% of the undiscounted course price).

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee.
  • Cancellations within 11 business days are not permitted; however, students may reschedule up to 4 business days before the class start date.

Note: Any refunds must be requested within 180 days from the original payment date; courses rescheduled within 11 business days of the start date are not eligible for refunds.


Google Map

Practical Programming

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Start Dates (5)
Show all 3 sessions
  • Tue, Jun 20 at 10:00am - 5:00pm
  • Wed, Jun 21 at 10:00am - 5:00pm
  • Thu, Jun 22 at 10:00am - 5:00pm
Show all 3 sessions
  • Tue, Aug 01 at 10:00am - 5:00pm
  • Wed, Aug 02 at 10:00am - 5:00pm
  • Thu, Aug 03 at 10:00am - 5:00pm
Show all 6 sessions
  • Mon, Aug 07 at 6:00pm - 9:00pm
  • Wed, Aug 09 at 6:00pm - 9:00pm
  • Mon, Aug 14 at 6:00pm - 9:00pm
  • Wed, Aug 16 at 6:00pm - 9:00pm
  • Mon, Aug 21 at 6:00pm - 9:00pm
  • Wed, Aug 23 at 6:00pm - 9:00pm
Show all 3 sessions
  • Tue, Sep 26 at 10:00am - 5:00pm
  • Wed, Sep 27 at 10:00am - 5:00pm
  • Thu, Sep 28 at 10:00am - 5:00pm
Show all 3 sessions
  • Sat, Oct 28 at 10:00am - 5:00pm
  • Sat, Nov 04 at 10:00am - 5:00pm
  • Sat, Nov 11 at 10:00am - 5:00pm
Save to WishList
Questions about this class?
Get help now from an expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Practical Programming (378)

Similar Classes

School: Practical Programming

Practical Programming

Practical Programming classes and workshops for everyone who wants to learn how to code from scratch or practice Python. You will learn how to start using Python, problem solving with algorithms and make dynamic web applications.

No coding experience needed, anyone who would like to learn how to code...

Read more about Practical Programming

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?
Booking this class for a group? Find great private group events here