SQL Training Classes in San Francisco Bay Area

This two-day training class introduces students Structured Query Language (SQL), the language integrated into most modern databases. SQL is used in MS Access, Oracle, Microsoft SQL Server, MySQL, and most other commonly used databases. The most basic SQL statements allow you to add new data, deleting, inserting or retrieving existing data from your database. Topics include:

Inserting, Deleting, and Updating Data

using INSERT INTO statements to add new rows to database tables
using DELETE FROM statements to remove rows from tables
using UPDATE WHERE statements to change existing data

Retrieving Data

using SELECT to get data from certain fields and establishing aliases for those fields
limiting the number of rows returned with WHERE clauses
sorting the output of retrieved data
using wildcards to retrieve rows with field data that matches certain patterns
selecting distinct values

Aggregate Functions

grouping rows by fields with common data (e.g., by city)
calculations you can apply to groups: averages, sums, counts, mins and maxes
limiting output to only those groups having certain results (HAVING)

Creating Tables

different data types for fields
assigning primary keys and auto-incremented fields
establishing constraints and foreign keys

Joined Data

collecting different fields from different tables with inner joins
outer joins
cross joins

Advanced Features

stored procedures
views
triggers
transactions

Prerequisites:

Experience with a desktop database such as Filemaker or MS Access