Skip to content Skip to site navigation Skip to service navigation

Beginner's SQL Workshop

Class Sessions

Date Delivery Method Cost
  • Mon Dec 5, 9:00 am to 12:00 pm
  • Wed Dec 7, 9:00 am to 12:00 pm
Live Online - 2 sessions $450

Class Code

ITS-2528

Class Description

Effective immediately in response to COVID-19, most Technology Training classes will be delivered online until further notice.

In advance of each session, Tech Training will provide you with a Zoom link to your class, 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.

Prerequisites:

  • 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


University IT Technology Training classes are only available to Stanford University staff, faculty, students and Stanford Hospitals & Clinics employees. A valid SUNet ID is needed in order to enroll in a class.