SQL Bootcamp Remote (Online)
22

Friday, 22 November

11 am – 5 pm EST

GA D.C. (Online)

Online Class
Livestream
$250 USD
Regular Ticket
$250 USD
Total

Questions? Read our FAQs

SQL Bootcamp Remote (Online) | November 22

Celia Fryar Photo


Founder, Managing Partner, Data Divers, LLC

Craig Fryar Photo


Data Executive, Platform Architect and Technologist, Consultant

22

Friday, 22 November

11 am – 5 pm EST

GA D.C. (Online)

Online Class
Livestream
$250 USD
Regular Ticket
$250 USD
Total

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.

We strongly recommend that participants sign up at least 48 hours before the Bootcamp start time to ensure sufficient time for pre-work and set-up.

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

  • This Bootcamp is for beginners.
  • This course will occur completely online using Zoom and Slack
  • You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection
  • Pre-work and course set up information will be emailed to all students signed up around 24 hours before (and again an hour before) your course launches
  • Students will be asked to watch this Introduction to SQL video as well as download pgAdmin and connect to AWS (directions will be sent via email)
  • Each individual course participant must have purchased a ticket

About the Instructors

Celia Fryar Photo

Founder, Managing Partner,
Data Divers, LLC

Celia is a data nerd who loves to translate data into business insights, drawing from over 17 years in systems engineering, data communications and data analytics. She's provided technical instruction for corporate and government users, administrators and OEM resellers. She has developed curriculum and taught courses in analytics, SQL, networking and communications and contributed to network engineering certification training. She has managed, mentored and trained technical systems engineers, software developers, and application support specialists. Celia currently serves as Chair of the GA Analytics Product Advisory Board and is a Distinguished Faculty Member. Equipping professionals with market ready skills is her passion and commitment. When not elbow deep in data or in the classroom, she likes to scuba dive or travel to new places!

Craig Fryar Photo

Data Executive, Platform Architect and Technologist,
Consultant

Craig is a data-driven product design and development executive. He is an experienced Chief Data Officer, and previously served as Global Director of Enterprise Strategy at Tableau.

As a BI platform architect, he defined and deployed 2 global-scale data analytics tech stacks and teams. He is a thought-leader in DX, specializing in data transformation road-maps, process, privacy and secure access. His EDW platform design at Wargaming.net collected 300+ billion daily data events that fueled analysis for product design, development, monetization, marketing, competitive intel and executive strategy.

Craig served in data and technology executive positions at a Fortune 500 company, a $1B multi-national and at numerous startups. He is an experienced investor, securing over $30M in early stage funding for data virtualization, virtual reality, AI, gaming, simulations and biotechnology. He currently serves as COO and EVP Data for a FinTech platform that simplifies and accelerates Startup funding. He is a Partner at Data Divers, LLC.

While a Technology Evangelist for database and applications software at Apple, he co-authored the first-ever 3D, online multiplayer, VR video-game called “Spectre”.

Craig lives in Austin with his wife and data-geeky family. He is an advanced PADI diver, golfer, author, eschatologist, instructor and industry speaker, and is widely traveled.

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.