SQL Bootcamp
25

Saturday, 25 March

10 am – 4 pm MDT

GA Denver, WeWork LoHi

2420 17th Street, 3rd Floor
Denver, CO 80202
$120 USD
Regular Ticket
$120 USD
Total

Questions? Read our FAQs

SQL Bootcamp

Craig Helton Photo


.NET Developer, Vail Resorts

25

Saturday, 25 March

10 am – 4 pm MDT

GA Denver, WeWork LoHi

2420 17th Street, 3rd Floor
Denver, CO 80202
$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.

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.

We will be pausing to let students run and write queries of their own, so students should bring laptops with an installed SQL implementation (SQLlite,MySQL, Postgres, SQL Server; Access is strongly discouraged). Instructions for installing MySQL will be distributed prior to class.

About the Instructor

Craig Helton Photo

.NET Developer,
Vail Resorts

I grew up in Cincinnati and moved to Arvada 2 years ago. I have been writing software professionally for 4 years and also have several years of data analytics experience. With both of these skill sets, I enjoy using both to optimize web experiences for users and profits for organizations.

Originally starting college as a computer science major, I switched to finance because the debugging process was really bad for me. I did not want to pull out all of my hair looking for a missing semi-colon. Finance introduced me to data analytics and after a couple years, debugging got better and I started re-learning to code. I was able to convince my boss to let me work on the company website and my career as a developer had started. Throughout my Master’s program, I took all the advanced programming classes I could take further growing my love for coding.

In my free time, I enjoy snowboarding, live music and have won awards for playing the saxophone. Now, my only audience is my wife, 2 kids, and our dog.

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.