Skip to content Skip to site navigation

SQL Essentials

Tuesday, September 28, 2021 - 9:00am to 12:00pm
Zoom

September 28 & 30

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.

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.

 

Event Sponsor

University IT Technology Training

Contact Email

techtraining@stanford.edu

Contact Phone

650-723-4391