Relational databases and the data they store are increasingly at the core of how we understand our world and make decisions in it. SQL (Structured Query Language) is the standard programming language used for querying databases and answering questions about the data in databases. Most relational databases, such as Access, SQL Server, Oracle, MySQL, Sybase, and FoxPro, can all be queried using SQL. Participants will learn how to use SQL to retrieve a variety of data for building reports or powering Web and desktop applications. This workshop is intended for participants with a good understanding of relational databases but limited to no experience using SQL.

(Description continued below)

Participants will:

• learn basic SQL concepts
• retrieve records from a single table
• use joins to retrieve records from multiple related tables
• use WHERE to search for or limit records returned by a query
• use aggregate functions and field operations
• work with null values in queries

The following workshops are suggested prerequisites to this workshop:

• Windows: Basic Computing Skills

Participants should already be able to:

• understand and work with database relationships