SQL Bootcamp (Online)

Washington D.C. campuses

GA Washington D.C. (1776 8th Floor)
1133 15th Street NW, 8th Floor
Washington DC 20005

SQL Bootcamp (Online)

Washington D.C.

Washington D.C. campuses

GA Washington D.C. (1776 8th Floor)
1133 15th Street NW, 8th Floor
Washington DC 20005

About this workshop series

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 lectures exercises to ensure that students leave with a working grasp of SQL fundamentals.

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.

Prereqs & Preparation

  • 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.
  • Students should install SQL implementation (SQLlite,MySQL, Postgres, SQL Server; Access is strongly discouraged).
  • This bootcamp is taken completely online across two different 3-hour sessions.
  • We will provide login information and a link to the platform on the day of each session.
  • You will need a computer, a strong internet connection, and an open mind to join.
  • If you cannot attend live, the recording for each session will be sent out to those who did not attend live as well as the instructor’s slides.
  • This bootcamp is taking place in Eastern Time.

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.