Discover Classes. Earn Rewards.
Course Details
Price:
$975 30 seats left
Start Date:

Mon, Sep 19, 10:00am - Sep 21, 5:00pm Eastern Time (3 sessions)

Next start dates (3)

Location:
Midtown, Manhattan
185 Madison Ave 3rd Fl
34th & Madison
New York, New York 10016
(Map)
Purchase Options
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 30

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

What you'll learn in this data science course:

Learn SQL fundamentals including data types and queries.

Why SQL?

With SQL you can answer questions using a database, the ultimate system of record for most organizations. 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


Still have questions? Ask the community.

Refund Policy
If you withdraw two days before the course start date, any deposit paid will be refunded in full. 

No refunds will be given for cancellations made after that date. If you cannot attend our class or workshop, for which you were charged, you will receive 25% discount for any other course.

Map

Practical Programming

All classes at this location

Start Dates (4)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm Eastern Time TBD 3 $975
This course consists of multiple sessions, view schedule for sessions.
Tue, Sep 20 10:00am - 5:00pm Eastern Time TBD
Wed, Sep 21 10:00am - 5:00pm Eastern Time TBD
10:00am - 5:00pm Eastern Time TBD 3 $975
This course consists of multiple sessions, view schedule for sessions.
Sat, Oct 22 10:00am - 5:00pm Eastern Time TBD
Sat, Oct 29 10:00am - 5:00pm Eastern Time TBD
10:00am - 5:00pm Eastern Time TBD 3 $975
This course consists of multiple sessions, view schedule for sessions.
Tue, Nov 08 10:00am - 5:00pm Eastern Time TBD
Wed, Nov 09 10:00am - 5:00pm Eastern Time TBD
6:00pm - 9:00pm Eastern Time TBD 6 $975
This course consists of multiple sessions, view schedule for sessions.
Wed, Dec 07 6:00pm - 9:00pm Eastern Time TBD
Mon, Dec 12 6:00pm - 9:00pm Eastern Time TBD
Wed, Dec 14 6:00pm - 9:00pm Eastern Time TBD
Mon, Dec 19 6:00pm - 9:00pm Eastern Time TBD
Wed, Dec 21 6:00pm - 9:00pm Eastern Time TBD

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 9750 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge 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?
BOOK NOW
Booking this class for a group? Find great private group events here
Loading...