IUPUI

This workshop lasts 3.5 hours.

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.

What You'll learn

• 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

What you need to know

• understand and work with database relationships

If you don't have those skills, consider first taking the workshop:

• Windows: Basic Computing Skills