SQL Bootcamp
21

Saturday, 21 January

10 am – 3 pm EST

GA D.C., 1776

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

Questions? Read our FAQs

SQL Bootcamp

Troy Crosby Photo


Software Engineer , Contactually

21

Saturday, 21 January

10 am – 3 pm EST

GA D.C., 1776

1133 15th Street NW, 8th Floor
Washington , D.C. 20005
$120 USD
Regular Ticket
$120 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 students leave with a working grasp of SQL fundamentals.

*Half 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 sandwich bar, or find something in the vicinity.

Takeaways

  • Background on databases & database structure
  • Connecting to a remote database
  • Finding basic data with SELECT, FROM, WHERE, & ORDER BY
  • Performing mathematical operations in SELECT statements
  • Handling NULL, string matching, & large sets with the WHERE operator
  • Combining data from multiple tables with INNER and OUTER JOINS
  • Calculating statistics with aggregate functions, GROUP BY, and HAVING
  • Using subqueries to build more powerful expressions

Prereqs & Preparation

Prior to class, students should download and be able to run the Sqlectron SQL client from here: https://github.com/sqlectron/sqlectron-gui/releases/latest

Students using Windows should download the ".exe" file. Students using a Mac should downloads the ".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

Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 days before the scheduled event date. No refunds will be given after this timeframe.

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.