SQL Bootcamp Remote (Online)
13

Thursday, 13 December

11 am – 6 pm EST

GA D.C. (Online)

Online Class
Livestream
$250 USD
Regular Ticket

Sold Out!

Get on the waitlist

Be the first to know if a spot becomes available.

Add me to the waitlist

Questions? Read our FAQs

SQL Bootcamp Remote (Online)

Celia Fryar Photo


Data Analytics Instructor and Courseware Developer

Craig Fryar Photo


Data Executive, Platform Architect and Technologist, Consultant

13

Thursday, 13 December

11 am – 6 pm EST

GA D.C. (Online)

Online Class
Livestream
$250 USD
Regular Ticket

Sold Out!

Get on the waitlist

Be the first to know if a spot becomes available.

Add me to the waitlist

Questions? Read our FAQs

About This Workshop

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy.

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 — and start using the tool immediately.

Due to pre-work requirements, participants must sign up at least 24 hours before the workshop start time.

Takeaways

  • Understand SQL vocabulary such as tables, schema, functions and JOINS.
  • Understand the differences between different data management systems for SQL databases.
  • Create basic SQL queries by applying Boolean logic, sorting functions, and commenting.
  • Apply SQL aggregate functions [MIN, MAX, SUM, AVG, COUNT].
  • Use advanced SQL commands [OR, GROUP BY, HAVING] and conditional operators [ =,!=,>,<, IN, NOT IN, and BETWEEN] to filter data.

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.
  • This bootcamp is taken completely online.
  • We will provide login information and a link to the platform on the day of the session.
  • You will need a computer and a strong internet connection

Prior to class: Watch this Introduction to SQL video. Download the DB Browser that is compatible with your operating system.

About the Instructors

Celia Fryar Photo

Data Analytics Instructor and Courseware Developer

Celia is a systems engineering and data analytics manager, with over thirteen years’ experience in technical instruction for both onsite and classroom corporate and government end-users, administrators and OEM resellers. She has developed curriculum and taught courses in analytics, SQL, networking and communications while working with companies including Sun Microsystems, AT&T, Texas Department of Public Safety, PG&E, Nike and data.world. 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 likes to scuba dive, make quilts and hang out with her kids.

Student Testimonies:
“I recommend Celia 10/10 to anyone looking to step up their data analytics skills.”

“She enabled me to get a job in data analytics -- with no previous education or experience.”

“Celia strikes a great balance of being a teacher, mentor, and technical expert.”

“She taught me the skills I needed to brush up on for a new position at work.”

Craig Fryar Photo

Data Executive, Platform Architect and Technologist,
Consultant

Craig Fryar is the former Global Director of Enterprise Strategy for Tableau. Prior to that he served as Head of Global Business Intelligence at Wargaming.net, an award-winning online game developer and publisher, and one of the leaders in the free-to-play MMO market.

Prior to Wargaming, Fryar was the Director of Analytics at BioWare, a division of Electronic Arts, where he launched, staffed and managed the analytics and reporting teams to inform data-driven design and executive decisions for global AAA computer and console software titles, including Star Wars: The Old Republic and Mass Effect 3.

He has also served in various executive positions leading highly-effective teams within innovative analytics and data services, hardware, software, simulations, biotech products and R&D.

Fryar holds a degree in Business and Communications from Texas Tech University.

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.