SQL Bootcamp
20

Saturday, 20 July

10 am – 5 pm EDT

GA Boston

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

Questions? Read our FAQs

SQL Bootcamp

Nirav Shah Photo


Founder, OnPoint Insights

20

Saturday, 20 July

10 am – 5 pm EDT

GA Boston

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

Questions? Read our FAQs

About This Workshop

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. We will use a combination of lecture and in-class exercises to ensure that participants leave with a working grasp of SQL fundamentals.

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

  • Background on SQL
  • Basic 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
  • JOIN operations
  • Grouping and aggregations
  • HAVING clauses
  • ORDER BY clauses
  • Subqueries

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.

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

About the Instructor

Nirav Shah Photo

Founder,
OnPoint Insights

Nirav Shah is the Founder of OnPoint Insights, a data analytics, software services and staff augmentation consultancy based in Boston. He has 15 years of industry experience - mainly in consulting on data analytics, big data modeling, control systems, process analytics and software tools, off-line and real-time data solutions, and training customers in data analytics,dashboards and data visualization. He is an expert in Dashboards and Visualization using Tableau and other Multivariate Data Analytics software .

He consults and teaches in applying data analytics for manufacturing, operations, supply chain, process control strategies with clients to improve manufacturing process and operational efficiency. He has implemented real- time process monitoring data analytics and fault detection systems for leading bio-pharma customers and clients from other industries such as chemical, pulp and paper, food and beverages. He helps customers in providing better process insights using data driven solutions.

He is also an Adjunct Professor at the University of Massachusetts in Boston where he teaches Multivariate Data Analytics, a graduate level class in Engineering Department, teaches Business Analytics and Dashboard Visualization at a technical collegeand conducts Data Science BootCamps and Workshops at General Assembly Boston. He has taught courses and conducted workshops to industry clients on Multivariate Data Analysis, Design of Experiments and Batch Process Analytics for ten years. He has spoken at leading data science conferences (ODSC East - 2018 & 2019, ODSC India - 2018, Global AI). He has been a panelist on various Data Science and AI panels.

He completed his dual Masters in Chemical and Computer Engineering from the University of Massachusetts and an MBA in Entrepreneurship from Babson College - both in Greater Boston.

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.