SQL Essentials

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.