SQL Bootcamp
24

Saturday, 24 June

10 am – 5 pm CDT

GA Austin, WeWork Congress

600 Congress Avenue, 14th Floor
Austin, TX 78701
$175 USD
Regular Ticket
$175 USD
Total

Questions? Read our FAQs

SQL Bootcamp

24

Saturday, 24 June

10 am – 5 pm CDT

GA Austin, WeWork Congress

600 Congress Avenue, 14th Floor
Austin, TX 78701
$175 USD
Regular Ticket
$175 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
  • ORDER BY clauses
  • Data filtering and aggregations
  • GROUP BY clauses
  • NULL values
  • JOIN operations

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 (PostgresSQL). Instructions for installing SQL will be distributed prior to class.

About the Instructor

Celia Fryar Photo

Celia is a systems engineering and data analytics manager, with over eleven years’ experience in technical instruction for both onsite and classroom corporate and government end-users, administrators and OEM resellers. She has taught topics like application software, networking and communications and administration while working with companies including Sun Microsystems, AT&T, Polaroid, Texas Department of Public Safety, PG&E, and Nike. She has managed, mentored and trained technical systems engineers, software developers, and application support specialists and contributed to network engineering certification training. When not elbow deep in data or in front of the classroom, she is likely learning about global cultures and music.

Degree: BBA, Systems Analysis from University of Texas, Arlington
Systems and Software: Windows, OSX, Microsoft Office Suite, SQL, Tableau.

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.