SQL Essentials

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.
 

The volume of data being generated is astonishing in its own right, what is truly mind-boggling is that we have only just started to make use of it all. It is estimated that only half of a percent of all data collected is ever analyzed.  
 

Goal / Learning Objectives:

• Understand the database structure
• Launch and open a database in SQL Lite
• Understand the SQL query basics
• Review various SQL functions
• Use comparison, logical and arithmetic operators in SQL
• Understand how to work with multiple tables using SQL joins

Topics Outline:

• SQL Terminology & Elements of Relational Databases
• Types of data
• SELECT statement
• Install SQLite
• Orientation of the SQLite environment
• Queries -- comments, structure of a basic query, syntax and using the ORDER BY clause
• Comparison, logical and arithmetic operators
• Use the WHERE, LIKE, DATE(), AND, OR and CASE statements
• Understand Joins and how they interact with Relational Database Structure
• Use a Left Outer Join in SQLite
• Types of functions in SQL and add calculations
• Aggregate functions and nesting functions -- Use the ROUND() functions with GROUP BY, WHERE, and HAVING clauses
   

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.