Discover Classes. Earn Rewards.

SQL Bootcamp: Learning the Language

  • Beginner
  • 18 and older
  • $349
  • 10 E 21st St, New York, NY
  • 7 hours

Get More Information

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

  • $349
  • GA NYC Manhattan (3rd Floor) @ 10 E 21st St 3rd Fl, New York, NY 10010
  • 7 hours
  • 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 sql class:

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.


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.

Prereqs & Preparation

  • A basic technical aptitude, orientation to computers, and curiosity to learn new tools will make you successful in this bootcamp. No prior knowledge of SQL is required.
  • Download the DB Browser that is compatible with your operating system.
  • You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection.
  • 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.
  • Each individual course participant must have purchased a ticket

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: Learning the Language

    Anonymous review on 10/21/2019
    Nigel was a great instructor and made the material fun and easy to understand. Highly recommend!
  • SQL Bootcamp: Learning the Language

    Reviewed by Jenny Z. on 10/20/2019
    Nigel was a great instructor. I feel like I have a good basic foundation for SQL after this class.
  • SQL Bootcamp: Learning the Language

    Reviewed by Yangsin L. on 10/8/2019
    Nigel is a great instructor! He doesn't use coding jargon and breaks down every step. His class provides the opportunity to work hands-on with SQL and practice both together as a group and independently. If you're looking for a no-fuss, straightforward class to learn SQL, this is it.
  • SQL Bootcamp: Learning the Language

    Anonymous review on 9/29/2019
    Rachel is a great instructor! Very friendly and engaging, a lovely person. The "SQL Bootcamp: Learning the Language" was full of practical examples and instruction throughout. My only gripe was the pacing of the class could be better or it needs an additional hour to get through all of the material in one day. Too much time was spent on the easier concepts earlier in the day (I thought there were too many examples of simple to understand concepts) versus the more difficult concepts later on, which seemed to be rushed in the last hour of class (you can't cover JOINS in one hour). There was no dedicated "lab" time as well. I would also recommend she prints out or provides an electronic version of the examples shown on the front board at the start of class because when she switched to the view of her computer to walk the class through the examples, I could never remember what the example was since it was no longer in front of me. General Assembly also really needs to fix the climate control. It was uncomfortably cold all day!
  • SQL Bootcamp: Learning the Language

    Anonymous review on 9/23/2019
    Nigel was great! very knowledgable, explained things well, and had good energy - if I had to critique anything it would be not spending enough time practicing JOINS, but understand it's difficult with the amount of time we had to work with
  • SQL Bootcamp: Learning the Language

    Reviewed by stephanie b. on 8/7/2019
    I took the SQL Bootcamp one day crash course and learned a lot in a day! Nigel is very sharp, well versed in the subject and great at teaching it in a precise way that makes it stick! I highly recommend this course to anyone looking to learn SQL in a short period of time.
  • SQL Bootcamp: Learning the Language

    Reviewed by Pauline H. on 6/6/2019
    Nigel was a great teacher! He explained SQL concepts well and infused humor into the class. On my part, the basics of SQL was easy to follow, but wished we had more time to practice and learn joining of tables.
  • SQL Bootcamp: Learning the Language

    Anonymous review on 2/6/2019
    I took the course with two coworkers and we were disappointed with our experience. Our instructor did not send out any instructions until 11:54 pm the night before so we had to spend time in class downloading the database. In class the day of, the instructor seemed to be rushing through the slideshow telling us he would email it to us later. We did not have enough time to complete the sample questions and he blew through the explanation of those as well again telling us he'd email it to us later. At the time it felt like we had a lot to cover so it seemed like it was justified. However at about 4 pm he told us it was time to take a 15 minute break and that we might as well just leave after and 'beat rush hour' because the homework assignment he was giving us would take at least an hour and fifteen minutes to do. My coworkers and I decided to go to nearby cafe and finish it together. We could only do six out of the eight homework problems because it turns out he did not actually teach us everything we needed to do. We emailed Nigel about it around 5:30 to ask if we were missing something and he has yet to respond. Looking back on what the course promised its clear he skipped over chunks of it in order to leave early.
  • SQL Bootcamp: Learning the Language

    Reviewed by Christian G. on 12/20/2018
    The instructor was high energy and focused on helping making sure students were engaged. The first half of the class had a good pace and moved through the core topics with exercises that reinforced the learning. The second half of the class went too quickly, covering too many topics which didn't fully build on each other. Since the topics were more complex/abstract it was more difficult to cement those learnings. Ultimately the class ended 1 hour early so we didn't get to take advantage of the full time. I would still recommend the course but it could be improved.
  • SQL Bootcamp: Learning the Language

    Reviewed by Dina H. on 12/14/2018
    Very engaging instructor. Learned a lot in this class and would definitely recommend.
  • SQL Bootcamp: Learning the Language

    Reviewed by KRISTINE R. on 8/7/2017
    Great job!
  • SQL Bootcamp: Learning the Language

    Reviewed by Yuna J. on 1/29/2020
  • SQL Bootcamp: Learning the Language

    Reviewed by Natasha F. on 1/30/2019
  • SQL Bootcamp: Learning the Language

    Reviewed by Amrita M. on 12/13/2018
  • SQL Bootcamp: Learning the Language

    Reviewed by Kerry C. on 8/27/2018
See 2 More Course Reviews
loading...
See reviews for other classes at General Assembly
loading...
Hide Reviews

Review Summary by CourseHorse

Students who took the SQL Bootcamp: Learning the Language class had positive things to say about the instructors and the substance of the class. Nigel, the primary instructor, was praised for his ability to make the material fun and easy to understand. Students felt that they walked away with a good basic foundation for SQL and appreciated Nigel's straightforward teaching style. They also enjoyed the opportunity to work hands-on with SQL and practice both as a group and independently. Many students still highly recommended the course and felt that they learned a lot during the day. Direct quotes: - "Nigel is very sharp, well-versed in the subject, and great at teaching it in a precise way that makes it stick!" - "The first half of the class had a good pace and moved through the core topics with exercises that reinforced the learning."

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