Discover Classes. Earn Rewards.

SQL Bootcamp Series

  • Beginner
  • 18 and older
  • $400
  • 10 E 21st St, New York, NY
  • 14 hours over 2 sessions

Get More Information

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

  • $400
  • GA NYC Manhattan (3rd Floor) @ 10 E 21st St 3rd Fl, New York, NY 10010
  • 14 hours over 2 sessions
  • A computer will not be provided

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 business training:

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence and begin to unleash the full analytical powers of SQL and relational databases.

*Please note: this is a class for total beginners. Those who use(d) SQL regularly should use this course only as a refresher.

Takeaways

  • Understand SQL vocabulary such as tables, schema, functions and JOINS.
  • Understand the differences between different data management systems for SQL databases.
  • Create basic SQL queries by applying Boolean logic, sorting functions, and commenting.
  • Apply SQL aggregate functions [MIN, MAX, SUM, AVG, COUNT].
  • Use CAST to change a column’s type for a query.
  • Use advanced SQL commands [OR, GROUP BY, HAVING] and conditional operators [ =,!=,>,<, IN, NOT IN, and BETWEEN] to filter data.
  • Apply string, date, and math functions to manipulate how data is presented.
  • Apply UNION to tables and columns for merging data.
  • Use JOINS to create relationships between tables to obtain data.
  • JOIN and UNION with Aliasing
  • Complex JOINs with multiple tables
  • NULL values and related SQL functions
  • CASE (IF/THEN)
  • SUBSELECT
Preparation
  • You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection.
  • 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 (MySQL, Postgres, SQL Server; Access is strongly discouraged). Instructions for installing MySQL will be distributed prior to class.
  • This course will occur completely online using Zoom and Slack.
  • Course set up information will be emailed to all students signed up around 24 hours before (and again an hour before) your course launches.

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring COVID-19 very carefully and are adjusting delivery of our programs.

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one.

Registered participants will be notified 24 hours in advance of this program with information on how to log in to the Zoom Meeting Room and other tools you’ll need for the session. Registration for this offering will close 2 hours prior to the session start in order to allow all students ample opportunity to have the technology enabled.

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)

(4.3-star rating across 2,637 reviews)
  • SQL Bootcamp Series

    Anonymous review on 2/17/2020
    Class was overall solid. One suggestion i would make is to relate the class more to business than just theoretical examples. While we did deal with the Iowa Liquor Dataset and had questions framed in "business" type format - they really weren't strong business use cases. Tying it back to the instructors real world working experience would have helped paint a better picture of when to use certain syntax and queries. Additionally, the Second day was heavily Unions and Joins. Joins were extremely complicated and we rushed through them pretty quickly - i had a hard time fully grasping these concepts in comparison to the first day where we thoroughly reviewed each topic in depth. Overall the class helped my understanding of SQL and will help me greatly in my role. Kelly was an upbeat, knowledgeable instructor who made the course enjoyable and fun. I would definitely attend or recommend others to enroll in another class taught by her.
  • SQL Bootcamp Series

    Reviewed by Lauren H. on 10/28/2019
  • SQL Bootcamp Series

    Reviewed by Eliot J. on 10/7/2014
See reviews for other classes at General Assembly
loading...
Hide Reviews

Similar Classes

Questions & Answers (1)

Get quick answers from CourseHorse and past students.

Question from Paul S.
Is this a 2-day course? The wording is kind of confusing.
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi there, yes this is a 2-day course.
Answer Show answer
Cancel

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 NYC educator.

General Assembly

General Assembly

All classes at this location

Google Map

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...