Intermediate SQL Bootcamp
13

Friday, 13 December

10 am – 4 pm EST

GA Boston

125 Summer Street 13th Floor
Boston, MA 02110
$200 USD
Regular Ticket
$200 USD
Total

Questions? Read our FAQs

Intermediate SQL Bootcamp | December 13

Arjun Ray Photo


Developer | Post-Academic | Creative

13

Friday, 13 December

10 am – 4 pm EST

GA Boston

125 Summer Street 13th Floor
Boston, MA 02110
$200 USD
Regular Ticket
$200 USD
Total

Questions? Read our FAQs

About This Workshop

This workshop will build upon the skills developed in the SQL Bootcamp. The program uses a combination of lecture and in-class exercises to ensure that participants leave with a working grasp of the SQL skills covered in class. Participants will immediately be able to apply their skills at work.

Important Note: Prior to class, you must have PostgreSQL and PGadmin installed. To do so, please follow these instructions for installation.

Interested in seeing this class held privately at your organization? Email us at bospartnerships@ga.co to request more info.

Takeaways

  • Understanding of advanced SQL concepts
  • JOIN operations
  • UNION Statements
  • Subqueries
  • String Comparisons
  • Optimizing Queries
  • SQL in the Enterprise

Preparation

  • Prior to class, please install PostgreSQL and PGadmin. Instructions for installation can be found here. There are multiple ways to install SQL. However, please follow the instructions found in the link to be prepared for the start of class.
  • Familiarity with SQL concepts including: SELECT-FROM-WHERE statements, LIMIT clauses, Math operations and constant expressions in SELECT statements, Booleans and complex conditions in the WHERE clause, Pattern matching in the WHERE clause, NULL values, Grouping and aggregations, HAVING clauses, and ORDER BY clauses.

About the Instructor

Arjun Ray Photo

Developer | Post-Academic | Creative

Arjun spent many years in academia working on neuroscience and genomics research before switching to programming, which has proven to be much more rewarding for him. He codes in Python, R, Perl, Ruby, Javascript, and a few other languages, and loves writing elegant, reusable code as well as trying to wrap his brain around low level programming languages and high level computer science concepts.

His coding expertise lies in fullstack web application development, probabilistic modeling, data visualization, and statistical inference. He’s been a professional touring musician, a recording studio owner/engineer, a teacher, an art curator and music festival organizer over the years. He also loves cooking, creative writing, long distance biking, pretty much all animals, and long comma-separated lists of nouns. As a TA, he aims to become the best teacher that he can be as well as test the limits of his own knowledge.

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.

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.