SQL Bootcamp is unfortunately unavailable

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

Course Details
Price:
$375
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:
Mentor-guided, online class
Purchase Options
Save to WishList

1 person saved this class

Book Private Class
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 20
System Requirements: Our educational content is designed for active, motivated, and curious students, so the fact that you’re here is a good start. We've put together a list of some common questions we're asked about our digital subscription. If you still have questions after reading this, please don’t hesitate to reach out at [email protected] – we’re more than happy to help.


Q: Where does this video come from?

A: Our online videos are recorded at our NYC campus, right across from Zaro’s. We handpick the best of our classes + workshops and fresh squeeze them to produce an online offering for students who prefer to learn on their own time, who live far from a GA campus, or who just love pressing rewind.


Q: If I pay for this class, do I own it?

A: When you pay for an online class recording you can view it forever. No need to download.


Q: Can I watch this on my iPhone, iPad, Kindle Fire, or screen TV?

A: Right now you can only watch our online classes on your computer. We’ll soon make it available on mobile devices as well. If you have a big screen TV, can we come over and watch Gossip Girl?

Q: What other kinds of online classes does GA offer?

A: GA currently offers a number of free online livestream classes where you can ask the instructor questions, meet like-minded peers, and hide away from your office mates during lunch. Over the coming months we will slowly roll out an archive of classes that students will be able to purchase.


Q: Is there a default timezone for your live stream listings?

A: All of our live streams are labeled according to New York time (EST/EDT) in accordance with a panel of artisan watchmakers.


Q: I live on the other side of the globe and won't be awake when the live stream airs. What can I do?

A: Select the "live stream + video recording" option when purchasing and watch it whenever you like (after original airing, barring time travel ability.


Q: What is a "replay"?

A: A replay is a pre-recorded live steam that is being rebroadcast. The instructors will not be available to answer questions, but if you send questions to [email protected], we will attempt to pass them along and get them answered if possible (please allow time for delivery, no shipping and handling costs apply).


Q: How can I find out more about GA’s online classes?

A: You should check out our current lineup up of livestream classes. You should also sign-up for our weekly newsletter.


Q: What is GA’s refund policy?

A: We hope all our students enjoy our classes. If, for some reason, you would like to request a refund, please email [email protected] with a brief explanation. We’ll respond as soon as possible. Region-specific policies are listed here.
Class Delivery: Learn anywhere, on your schedule. Each week, you’ll complete a series of videos, quizzes, interactive activities and projects through our online platform, available to access at any time. You will be guided by a mentor, and you will be able to schedule live 1:1 mentoring sessions at a time that works for you both. Additional information on how to log into the online environment will be provided after purchasing the class.
Teacher: Joana Wang

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:

SQL provides powerful but reasonably simple tools for data analysis and handling. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence -- and start using the tool immediately.

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.

Preparation:

  • This Bootcamp is for beginners.
  • 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 register to Mode Analytics before your course begins (directions to do so will be emailed to all students)
  • Each individual course participant must have purchased a ticket

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

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

Similar Classes

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 3750 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,633)

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 that produces a 99.2% job placement rate for...

Read more about General Assembly

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online 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

Oracle Database: SQL Fundamentals

at ONLC Training Centers -

Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This course introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS)....

Monday Jan 31st, 10am - 4:45pm Eastern Time

  (5 sessions)
$2,995

5 sessions

Intermediate SQL for Data Analytics

at Borough of Manhattan Community College -

Dear prospective student, as you are aware New York State has been dealing with a declared state of emergency due to the novel coronavirus-19 outbreak. Please be aware that our future course dates may be delivered in either a traditional classroom face-to-face format or an on-line format or a hybrid model that mixes both live and online course delivery....

Tuesday Feb 1st, 6pm - 9pm Eastern Time

  (10 sessions)
$814

10 sessions

SQL Bootcamp: Learning the Language

at General Assembly -

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

Wednesday Feb 2nd, 8pm - 11:55pm Eastern Time