Intermediate SQL Bootcamp (Online) is unfortunately unavailable

Thankfully we have 3 other Tech Classes for you to choose from. Check our top choices below or see all classes for more options.

Questions about this class?
Get help now from a knowledge expert!

Intermediate SQL Bootcamp (Online)

at General Assembly - Online

(2652)
Course Details
Price:
$250
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Online
GA Washington D.C. (Remote Online)
Washington, District of Columbia
(Map)
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 20
Teacher: Candace Roberts

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 sql class:

Enabling analysts to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis.

Takeaways
We will be going over the following:

  • 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
  • This course will occur completely online using Zoom and Slack
  • You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection
  • Pre-work and course set up information will be emailed to all students signed up around 24 hours before (and again an hour before) your course launches
  • Students will be asked to download pgAdmin and connect to AWS (directions will be sent via email)
  • Each individual course participant must have purchased a ticket
  • A laptop, Mac or Windows, with a minimum of 8G (16G preferred) available memory and 200 MB available to download applications; Preload pgAdmin and PostgreSQL per instruction PDF. Instructions attached.
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.
  • General understanding of accessing remote/cloud databases.
This is an Intermediate level course. If you are a beginner, we recommend that you start with the SQL Bootcamp Remote (Online)


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.

Still have questions? Ask the community.

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.

Map

Google Map

General Assembly

All classes at this location

Registered students will be notified 48 hours in advance of this program with information on how to log in to the Zoom webinar and Slack messaging apps.

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

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 2500 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 General Assembly (2,637)

School: General Assembly

General Assembly

General Assembly (GA) equips individuals with the in-demand skills needed to build a career in today’s high-growth tech sectors. Their award-winning technical training includes flexible delivery, industry-tested curriculum, and a career services program.

Since their founding in 2011, GA has graduated...

Read more about General Assembly

CourseHorse Approved

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

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

3 Top Choices

Lightroom Classic Library Module

at Capital Photography Center - Downtown, Washington, D.C. 1616 H St NW, Washington, District of Columbia 20006

The Lightroom Classic Library Module - Getting Organized Lightroom is the industry standard for amateurs and professional photographers alike, for organizing and editing our images. At the heart of this powerful program lies the Library Module where we import, organize, sort, rate and tag our images. Spend an afternoon with Marie Joabar learning...

Sunday Aug 14th, 1pm - 5pm Eastern Time

Lightroom In A Day

at Capital Photography Center - Downtown, Washington, D.C. 1616 H St NW, Washington, District of Columbia 20006

Learn Lightroom in a day. We'll look at the 2 most powerful modules, the Library and the Develop Modules. Learn how to use Lightroom to take charge of your digital workflow. This class is designed to make Lightroom easy to understand and put you in control of all it has to offer. It will cover your workflow from beginning to end: from importing and...

Saturday Aug 27th, 9am - 5pm Eastern Time

Creating Books with Lightroom Classic and Blurb

at Capital Photography Center - Merrifield 8130 Porter Rd, Virginia, District of Columbia 22042

Learn to use the Book Module in Lightroom to create precious memory books as gifts. Or, gift yourself with a book to celebrate your own visual journey and share with friends, colleagues and family.  Photographs can take us on a journey.  We will explore in depth Lightroom Book Module to create visual stories that we can then upload to Blurb’s...

Saturday Oct 1st, 2:30pm - 6:30pm Eastern Time