SQL Bootcamp
29

Saturday, 29 July

10 am – 4 pm EDT

GA D.C., 1776

1133 15th Street NW, 8th Floor
Washington, D.C. 20005
$200 USD
Regular Ticket
$200 USD
Total

Questions? Read our FAQs

SQL Bootcamp

Troy Crosby Photo


Software Engineer , Contactually

29

Saturday, 29 July

10 am – 4 pm EDT

GA D.C., 1776

1133 15th Street NW, 8th Floor
Washington, D.C. 20005
$200 USD
Regular Ticket
$200 USD
Total

Questions? Read our FAQs

About This Workshop

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.

*45 minutes to an hour will be allocated for lunch at 12:30pm. You have the option to pack a lunch, help yourself to our peanut butter and jelly station, or find something in the vicinity.

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

A basic technical aptitude, orientation to computers, and curiosity to learn new tools will make you successful in this bootcamp. No prior knowledge of SQL is required.

Prior to class:
Watch this Introduction to SQL video.

Download Sqlectron.
- Students using Windows should download the Sqlectron-Setup-1.15.0.exe file.
- Students using a Mac should downloads the Sqlectron-1.15.0.dmg file. -- Mac users may need to allow installation of non-app-store programs in their System Preferences

About the Instructor

Troy Crosby Photo

Software Engineer ,
Contactually

Troy is a DC-area native and a University of Maryland alumnus. Currently a Software Engineer at Contactually, he also has experience with government contracting, Amazon.com, and The Washington Post. Troy is passionate about creating products and continued growth of the DC tech scene.

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.