Discover Classes. Earn Rewards.

2-Day SQL Bootcamp Series

  • Beginner
  • 18 and older
  • $375
  • 444 N Wabash Ave, Chicago, IL
  • 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.

  • $375
  • General Assembly Ch @ Rent 24 @ 444 N Wabash Ave 5th Fl, Chicago, IL 60611
  • 14 hours over 2 sessions

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:

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

Registered students 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 class will close 2 hours prior to the session start in order to allow all students ample opportunity to have the technology enabled.

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

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

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.

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

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 (2)

Get quick answers from CourseHorse and past students.

Question from Lindsey P.
Hi there, I am interested in taking this SQL bootcamp class in chicago. My company uses Postgres SQL and the program Numeracy. I want to be 100% confident that this is what is being taught to ensure it's relevant. Also, will this class teach joins and subqueries?
Answer from Darwin V. CourseHorse StaffCourseHorse Staff
General Assembly does teach Postgres as part of this boot camp. They teach SQL using PgAdmin, not Numeracy. While PgAdmin does not have to autocomplete features like Numeracy, you will learn the syntax to use a tool like Numeracy. They cover joins and would be able to incorporate subqueries into the boot camp if you decide to take this workshop and it's something you're interested in learning more about.
Answer Show answer
Cancel
Question from T
Is this course for beginners and those who have no prior knowledge of any script or programming?
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 Chicago 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...