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:
There are no upcoming dates for this event.