Skip to content Skip to site navigation Skip to service navigation

Beginner's SQL Workshop

New session times will be displayed below upon confirmation.

Most Technology Training classes will be delivered online until further notice.

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.



This course covers basic database setup and writing SQL queries to select, filter, and aggregate data and combine multiple data tables. As a workshop, there will be a heavy emphasis on practice and interactive exercises.


  • Prior experience with any programming language is not required, but helpful
  • MySQL Workbench software (free download) required. Information on how to download will be sent to enrollees.

Training Goal
Participants will have the opportunity learn how to do basic SQL queries and set up a sample database. There will be a heavier focus on retrieving data effectively from an existing data warehouse environment owned by someone else rather than setting up your own and administering it.

Learning Objectives

  • Learn to write SQL queries to select, filter, and aggregate data
  • Learn to write SQL queries that join multiple data tables together

Breakdown of Topics:

  • SQL overview: dialects, tables & schemas, data types
  • Sample database setup
  • Selecting data: SELECT, FROM, LIMIT
  • Filtering data: WHERE, AND/OR, IN/BETWEEN/LIKE, DISTINCT, NULL values
  • Ordering data: ORDER BY
  • Aggregating data: COUNT, AVG, MIN, MAX, SUM, GROUP BY, HAVING
  • Joining tables with a join key
  • Types of joins: INNER, OUTER, LEFT, RIGHT
Lionel Levine

Lionel Levine is an independent educator with over 5 years of training experience. Lionel has developed and taught courses and seminars at the undergraduate and graduate levels, in topics ranging from computer programming, algorithms, Data Science, Machine Learning, and Population Health.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training

University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.