Skip to content Skip to site navigation Skip to service navigation

SQL Essentials

Class Sessions

Date Location Cost
  • Tue Sep 28, 9:00 am to 12:00 pm
  • Thu Sep 30, 9:00 am to 12:00 pm
Live Online $450

Class Code

ITS-2521

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.