Discover Classes. Earn Rewards.

2-Day SQL Bootcamp Series

  • Beginner
  • 18 and older
  • $375
  • Online Class Livestream, Atlanta, GA
  • 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
  • GA Atlanta (Remote Online) @ Online Class Livestream, Atlanta, GA 00000
  • 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:

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.

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

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

General Assembly

General Assembly

All classes at this location

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.

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