Discover Classes. Earn Rewards.

Intermediate SQL Bootcamp

  • Intermediate
  • 18 and older
  • $250
  • Online Class Livestream, Online, MA
  • 6 hours

Get More Information

Fill out this form and the course provider will contact you with more information about this course.

  • $250
  • GA Boston (Remote Online) @ Online Class Livestream, Online, MA 00000
  • 6 hours

By submitting this form, I consent to CourseHorse providing the information in this form with the course provider which may contact me via email, phone or text.

Class Description

Description

What you'll learn in this sql class:

This class enables students to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis.

This is an intermediate level course. Students who join this course must have an understanding of SQL fundamentals including the use of the following command line functions: SELECT queries that include FROM, WHERE, ORDER BY, LIMIT, familiarity with using GROUP BY and HAVING in SELECT queries, and a general understanding of accessing remote/cloud databases.

If you are a beginner, we recommend that you start with our SQL Bootcamp.

General Assembly’s classes, workshops & events are for recreational purposes and are not regulated by the bureau of proprietary school supervision.

If this class is recorded, students will be sent the recording link within 7 days after class completion by email. Students are encouraged to download and save any shared materials (worksheets, deck if applicable) during class for later reference as they are not be shared by email.

Takeaways

  • JOIN and UNION with Aliasing
  • Primary and Foreign Keys
  • Aggregation and Functions
  • Complex JOINs with multiple tables
  • NULL values and related SQL functions
  • GROUP BY combined with HAVING
  • CASE and COALESCE

Preparation

Students need to download pgAdmin and connect to AWS.

  • You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection.
  • This class will occur completely online using Zoom.
  • Class setup information will be emailed to all students signed up around 24 hours before (and again an hour before) your class launches.
  • Each individual class participant must have purchased a ticket.

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

School Notes:
For students enrolling in 12 week part time and immersive classes, it is not recommended that you book more than one class simultaneously.

Refund Policy

If you can't make it to a class/workshop, please email us at [email protected] at least 7 days before the scheduled event date. No refunds will be given after this timeframe.


In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at General Assembly (2,637)

Similar Classes

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

General Assembly

At General Assembly you get the tech skills, career advice and networking opportunities needed to be job ready for a career in coding or data or ux design, in as little as three months, with little or no previous experience.

Since 2011 General Assembly has graduated more than 40,000 students...

Read more about General Assembly

CourseHorse Approved

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

General Assembly

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...