Stanford University

Due to COVID-19, all classes have moved to an online format and many events at Stanford have been canceled or moved to a virtual format. This calendar may not reflect all changes. Please confirm event status with the event contact before attending.

x

SQL Essentials

When:
Friday, Jan 22, 2021 9:00 AM
Where:
Zoom
More Info:
SQL Essentials

RSVP for this event

Audience:
Faculty/Staff, Students
Sponsor:
University IT Technology Training

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, or students. A valid SUNet ID is needed in order to enroll in a class.

IconsList of icons used on the sitemaillinkedindouble carrot leftarrow leftdouble carrotplayerinstagramclosecarrotquotefacebooktwitterplusminussearchmenuarrowcloudclock