Skip to content Skip to site navigation Skip to service navigation

SQL Essentials

Class Sessions

Date Delivery Method Cost
  • Tue Dec 7, 9:00 am to 12:00 pm
  • Thu Dec 9, 9:00 am to 12:00 pm
Live Online - 2 sessions $450
  • Mon Feb 14, 1:00 pm to 4:00 pm
  • Wed Feb 16, 1:00 pm to 4:00 pm
Live Online - 2 sessions $450

Class Code


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 class covers how to create or delete database and tables, and how to grant/revoke access. Data insertion, deletion, or modification will be practiced.

Note: Instructions will be sent to learners prior to the class for how to install MySQL (Command line and MySQLWorkbench) as hands-on exercises will be practiced.

To ensure learners have the software installed, there will be a short Zoom session dedicated for software installation and any installation issues.


Topics covered in this class include:

  • Introduction to databases and MySQL
  • SQL Commands Types (DDL, DML, DCL, TCL)
  • Creating users and grant/revoke accesses
  • Creating schemas and tables
  • Inserting, deleting, and updating data
  • Data Retrieval using the SELECT statement
  • SQL conversion functions: CASE, DATE_FORMAT, NULLIF, COALESCE, etc.
  • Sorting and filtering data, wildcard filtering, and regular expressions.
  • Manipulating and aggregating data: SUM, AVG, MAX, MIN, COUNT, and DISTINCT
  • Working with Subqueries
  • Joining tables: Inner versus Outer Joins; Left/Right Joins; and Full Outer Joins
  • UNION, INTERSECT, and MINUS Operators


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.