SQL Advanced Tutorial

Next

SQL > SQL Advanced

The tutorial shows advanced capabilities of the SQL structured query language. This tutorial covers several advanced topics and relies on a consistent set of example data.

Advanced SQL topics include:

Example Data

The following example data is used through out this tutorial to illustrate the advanced capabilities of SQL:

Table: Region

region_nbrregion_name
100East Region
200Central Region
400West Region

Table: Branch

branch_nbrbranch_nameregion_nbremployee_count
108New York10010
110Boston1006
212Chicago2005
404San Diego4006
415San Jose4003

Table: Branch_Sale

branch_nbrsale_datesale_amount
1082006-01-011000.0000
1082006-02-072500.0000
1102006-01-01500.0000
2122006-01-01342.0000
4042006-01-01200.0000
4042006-02-03310.0000
4152006-01-0142.0000

Copyright© 1999-2015, First Place Software, Inc.