SQL Bootcamp Remote (Online)
10

Thursday, 10 December

11 am – 5 pm EST

GA Dallas (Livestream)

Online Class
Livestream
$250 USD
Regular Ticket
$250 USD
Total

Questions? Read our FAQs

SQL Bootcamp Remote (Online) | December 10

Matt Brems Photo


Managing Partner and Principal Data Scientist, BetaVector

10

Thursday, 10 December

11 am – 5 pm EST

GA Dallas (Livestream)

Online Class
Livestream
$250 USD
Regular Ticket
$250 USD
Total

Questions? Read our FAQs

About This Workshop

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy.

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.

We strongly recommend that participants sign up at least 48 hours before the Bootcamp start time to ensure sufficient time for pre-work and set-up.

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation 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 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.

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 advanced SQL commands [OR, GROUP BY, HAVING] and conditional operators [ =,!=,>,<, IN, NOT IN, and BETWEEN] to filter 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

About the Instructor

Matt Brems Photo

Managing Partner and Principal Data Scientist,
BetaVector

Matt is currently Managing Partner and Principal Data Scientist at BetaVector. His full-time professional data work spans finance, education, consumer-packaged goods, and politics and he earned General Assembly's 2019 "Distinguished Faculty Member of the Year" award. Matt earned his Master's degree in statistics from Ohio State. Matt is passionate about responsibly putting the power of machine learning into the hands of as many people as possible and mentoring folx in data and tech careers. Matt also volunteers with Statistics Without Borders and currently serves on their Executive Committee as the Marketing & Communications Director.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

Community Code of Conduct

Your registration for or attendance at any General Assembly offering indicates your agreement to abide by this Community Code of Conduct policy and its terms.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.