SQL Bootcamp
25

Saturday, 25 February

10 am – 4 pm PST

GA Seattle

1218 Third Avenue, 3rd Floor
Seattle , WA 98101
$150 USD
Regular Ticket
$150 USD
Total

Questions? Read our FAQs

SQL Bootcamp

25

Saturday, 25 February

10 am – 4 pm PST

GA Seattle

1218 Third Avenue, 3rd Floor
Seattle , WA 98101
$150 USD
Regular Ticket
$150 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.

Please install PostgreSQL prior to class.

About the Instructor

Matthew Morris Photo

I love answering tough questions. Researching and finding impossible answers is a thrill for me. I have been working with data for 16 years in many roles revolving around the same thing; Make the data meaningful and consumable for the client; Show them something cool. I believe nobody knows the business better than the business and am I an advocate for the business community being trained, listened to and guided into the world of advanced analytics.

Languages: SQL(Expert), PigLatin(Intermediate level), Python(Basic level)
Applications: Cloudera, Tableau, Essbase Application Manager, Showcase, Captivate, Articulate
Learning: Python, JavaScript, Predictive Analytics, R

Experience: Advanced Analytics, Business Intelligence, Technical Training, Business Liaison

Areas of Business: Merchandising, Human Resources, Accounting, Marketing

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.