Skip to content Skip to site navigation Skip to service navigation

SQL Essentials

Class Sessions

Date Location Cost
  • Fri Jan 22, 9:00 am to 4:00 pm
Live Online $400

Class Code

ITS-2521

Class Description

Effective immediately in response to COVID-19, all 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) prior to the class 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

     


About the Instructor: Arafat Mokhtar

Arafat Mokhtar is a Business Intel Engineer at Stanford School of Medicine, who supports the Human Resources Group with data collections, validation, cleansing, and analytics to provide actionable data insights used by leadership management to make data-driven decisions on the organization workforce. He develops code to automate data analytics processes, proposes data solutions, and develops measurable business metrics.

 

Arafat holds a Ph.D. in Particle Physics and spent several years as a postdoctoral fellow at SLAC National Accelerator Laboratory. He has 10+ years of teaching experience and conducted a number of Python and R training sessions for Stanford Technology Training Programs.
 



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.