Oracle 12c/11g SQL & PL/SQL Course

Oracle TrainingOracle 12c/11g SQL & PL/SQL

by Certstaffix® Training

Length: 5 day(s)      Public Class Price: $2850/person (USD)      Group Onsite Price: Request Quote      Course Category: Oracle


Oracle Training
This 5-day course teaches how to access Oracle 12c/11g databases through SQL statements and construct PL/SQL programs. Oracle Database 12c/11g SQL offers complete coverage of the latest database features and techniques. Find out how to write SQL statements to retrieve and modify database information, use SQL*Plus and SQL Developer, work with database objects, write PL/SQL programs, use performance optimization techniques, incorporate XML, and more. This course ontains everything you need to know to master Oracle PL/SQL.

Oracle Versions That Can Attend: 12c and 11g
Course Taught With: Oracle 12c Software and Courseware
Course Description: Print It | Download PDF | Email It

  Group Classes for Organizations - Onsite at Your Office How It Works

Have a group of employees needing the same training? Onsite training at your office is a great solution.  

  • An expert Instructor will come to your office
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Public Corporate Classes - Live Online: Our Location or Yours How It Works

Certstaffix® Training public classes are instructor-led, live online training you attend in a local computer lab or from your home/office. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software you are being taught
  • Interaction with all students in the class at other locations
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options. You must register at least 15 days before class.

 Register ➥   June 22, 2020     
 Register ➥   March 2, 2020     

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Related Certifications

Oracle Database 12c Administrator Certified Associate Certification


Suggested Follow-Ons


Course Topics

Section 1: An Introduction to SQL
Chapter 1 An introduction to relational databases and SQL
An introduction to client/server systems.........................................4
The hardware components of a client/server system......................................................4
The software components of a client/server system.......................................................6
Other client/server architectures ....................................................................................8
An introduction to the relational database model.........................10
How a table is organized............................................................................................... 10
How tables are related...................................................................................................12
How columns in a table are defined.............................................................................. 14
An introduction to SQL and SQL-based systems .........................16
A brief history of SQL.................................................................................................. 16
A comparison of Oracle, DB2, Microsoft SQL Server, and MySQL........................... 18
The SQL statements.........................................................................20
An introduction to the SQL statements........................................................................20
How to work with database objects..............................................................................22
How to query a single table...........................................................................................24
How to join data from two or more tables....................................................................26
How to add, update, and delete data in a table .............................................................28
How to work with views ...............................................................................................30
SQL coding guidelines .................................................................................................32
An introduction to PL/SQL ..............................................................34
How to work with stored procedures............................................................................34
How to work with user-defined functions.....................................................................36
How to work with triggers............................................................................................36
How to use SQL from an application program ..............................38
Three data access models .............................................................................................38
Java code that retrieves data from an Oracle database.................................................40

Chapter 2 How to use Oracle SQL Developer and other tools
How to work with an Oracle database ............................................48
How to start and stop the database service...................................................................48
How to use the Database Home Page ...........................................................................50
How to use SQL*Plus....................................................................................................52
How to use SQL Developer to work with a database ....................54
How to create a database connection............................................................................54
How to export or import database connections............................................................54
How to navigate through the database objects.............................................................56
How to view the column definitions for a table............................................................58
How to view the data for a table ...................................................................................58
How to edit the column definitions...............................................................................60
How to use SQL Developer to run SQL statements ......................62
How to enter and execute a SQL statement ..................................................................62
How to work with the Snippets window.......................................................................64
How to handle syntax errors.........................................................................................66
How to open and save SQL statements.........................................................................68
How to enter and execute a SQL script.........................................................................70
How to use the SQL Reference manual..........................................72
How to view the manual ...............................................................................................72
How to look up information..........................................................................................72

Section 2 The essential SQL skills
Chapter 3 How to retrieve data from a single table
An introduction to the SELECT statement.....................................80
The basic syntax of the SELECT statement.................................................................80
SELECT statement examples .......................................................................................82
How to code the SELECT clause.....................................................84
How to code column specifications..............................................................................84
How to name the columns in a result set......................................................................86
How to code string expressions ....................................................................................88
How to code arithmetic expressions.............................................................................90
How to use scalar functions..........................................................................................92
How to use the Dual table.............................................................................................94
How to use the DISTINCT keyword to eliminate duplicate rows ...............................96
How to use the ROWNUM pseudo column to limit the number of rows....................98
How to code the WHERE clause ...................................................100
How to use the comparison operators.........................................................................100
How to use the AND, OR, and NOT logical operators..............................................102
How to use the IN operator.........................................................................................104
How to use the BETWEEN operator..........................................................................106
How to use the LIKE operator....................................................................................108
How to use the IS NULL condition............................................................................ 110
How to code the ORDER BY clause.............................................. 112
How to sort a result set by a column name................................................................. 112
How to sort a result set by an alias, an expression, or a column number................... 114
How to code the row limiting clause............................................. 116
How to limit the number of rows................................................................................ 116
How to return a range of rows .................................................................................... 116
Chapter 4 How to retrieve data from two or more tables
How to work with inner joins .........................................................122
How to code an inner join...........................................................................................122
When and how to use table aliases.............................................................................124
How to work with tables from different schemas.......................................................126
How to use compound join conditions........................................................................128
How to use a self-join..................................................................................................130
Inner joins that join more than two tables.................................................................. 132
How to use the implicit inner join syntax...................................................................134
How to work with outer joins .........................................................136
How to code an outer join...........................................................................................136
Outer join examples....................................................................................................138
Outer joins that join more than two tables.................................................................. 140
How to use the implicit outer join syntax................................................................... 142
Other skills for working with joins ................................................144
How to combine inner and outer joins........................................................................144
How to join tables with the USING keyword............................................................. 146
How to join tables with the NATURAL keyword...................................................... 148
How to use cross joins ................................................................................................150
How to work with unions................................................................152
The syntax of a union ................................................................................................. 152
Unions that combine data from different tables......................................................... 152
Unions that combine data from the same table ..........................................................154
How to use the MINUS and INTERSECT operators ................................................156
Chapter 5 How to code summary queries
How to work with aggregate functions.........................................162
How to code aggregate functions................................................................................ 162
Queries that use aggregate functions..........................................................................164
How to group and summarize data ...............................................166
How to code the GROUP BY and HAVING clauses ................................................. 166
Queries that use the GROUP BY and HAVING clauses............................................ 168
How the HAVING clause compares to the WHERE clause ...................................... 170
How to code complex search conditions .................................................................... 172
How to summarize data using Oracle extensions....................... 174
How to use the ROLLUP operator.............................................................................. 174
How to use the CUBE operator .................................................................................. 176
Chapter 6 How to code subqueries
An introduction to subqueries ......................................................182
How to use subqueries ................................................................................................ 182
How subqueries compare to joins............................................................................... 184
How to code subqueries in search conditions ............................186
How to use subqueries with the IN operator .............................................................. 186
How to compare the result of a subquery with an expression .................................... 188
How to use the ALL keyword.....................................................................................190
How to use the ANY and SOME keywords...............................................................192
How to code correlated subqueries.............................................................................194
How to use the EXISTS operator ...............................................................................196
Other ways to use subqueries.......................................................198
How to code subqueries in the FROM clause............................................................. 198
How to code subqueries in the SELECT clause .........................................................200
Guidelines for working with complex queries .............................202
A complex query that uses subqueries........................................................................202
A procedure for building complex queries.................................................................204
Two more skills for working with subqueries ..............................206
How to code a subquery factoring clause ...................................................................206
How to code a hierarchical query...............................................................................208
Chapter 7 How to insert, update, and delete data
How to create test tables ...............................................................214
How to create the tables for this book ........................................................................ 214
How to create a copy of a table................................................................................... 214
How to commit and rollback changes ..........................................216
How to commit changes.............................................................................................. 216
How to rollback changes............................................................................................. 216
How to insert new rows..................................................................218
How to insert a single row .......................................................................................... 218
How to insert default values and null values..............................................................220
How to use a subquery to insert multiple rows...........................................................222
How to update existing rows .........................................................224
How to update rows ....................................................................................................224
How to use a subquery in an UPDATE statement......................................................226
How to delete existing rows...........................................................228
How to delete rows......................................................................................................228
How to use a subquery in a DELETE statement ........................................................228
Chapter 8 How to work with data types and functions
The built-in data types....................................................................232
Data type overview .....................................................................................................232
The character data types.............................................................................................234
The numeric data types...............................................................................................236
The temporal data types .............................................................................................238
The large object data types.........................................................................................240
How to convert data from one type to another............................242
How to convert characters, numbers, and dates.........................................................242
Common number format elements .............................................................................244
Common date/time format elements..........................................................................246
How to convert characters to and from their numeric codes......................................248
How to work with character data...................................................250
How to use the common character functions .............................................................250
How to parse a string ..................................................................................................254
How to sort a string in numerical sequence ...............................................................256
How to sort mixed-case columns in alphabetical sequence.......................................256
How to work with numeric data.....................................................258
How to use the common numeric functions...............................................................258
How to search for floating-point numbers..................................................................260
How to work with date/time data...................................................262
How to use the common date/time functions.............................................................262
How to parse dates and times.....................................................................................264
How to perform a date search.....................................................................................266
How to perform a time search ....................................................................................268
Other functions you should know about......................................270
How to use the CASE function...................................................................................270
How to use the COALESCE, NVL, and NVL2 functions.........................................272
How to use the GROUPING function ........................................................................ 274
How to use the ranking functions...............................................................................276
Section 3 Database design and implementation
Chapter 9 How to design a database
How to design a data structure .....................................................286
The basic steps for designing a data structure............................................................286
How to identify the data elements..............................................................................288
How to subdivide the data elements ...........................................................................290
How to identify the tables and assign columns..........................................................292
How to identify the primary and foreign keys............................................................294
How to enforce the relationships between tables .......................................................296
How normalization works...........................................................................................298
How to identify the columns to be indexed................................................................300
How to normalize a data structure................................................302
The seven normal forms .............................................................................................302
How to apply the first normal form ............................................................................304
How to apply the second normal form........................................................................306
How to apply the third normal form...........................................................................308
When and how to denormalize a data structure......................................................... 310
Chapter 10 How to create tables, indexes, and sequences
How to work with tables................................................................. 314
How to create a table................................................................................................... 314
How to code a primary key constraint........................................................................ 316
How to code a foreign key constraint ......................................................................... 318
How to code a check constraint..................................................................................320
How to alter the columns of a table ............................................................................322
How to alter the constraints of a table ........................................................................324
How to rename, truncate, and drop a table.................................................................326
How to work with indexes ..............................................................328
How to create an index ...............................................................................................328
How to drop an index..................................................................................................328
How to work with sequences.........................................................330
How to create a sequence............................................................................................330
How to use a sequence ................................................................................................330
How to alter a sequence .............................................................................................. 332
How to drop a sequence.............................................................................................. 332
The script used to create the AP tables .......................................334
An introduction to scripts...........................................................................................334
How the DDL statements work...................................................................................334
How to automatically generate ID values.....................................340
How to use a sequence as a default value ...................................................................340
How to use the GENERATED clause ........................................................................340
How to use SQL Developer............................................................342
How to work with the columns of a table ...................................................................342
How to work with the data of a table..........................................................................342
How to work with the constraints of a table ...............................................................344
How to work with indexes ..........................................................................................346
How to work with sequences......................................................................................348
Chapter 11 How to create views
An introduction to views................................................................354
How views work..........................................................................................................354
Benefits of using views ...............................................................................................356
How to work with views..................................................................358
How to create a view................................................................................................... 358
How to create an updatable view................................................................................362
How to create a read-only view ..................................................................................362
How to use the WITH CHECK OPTION clause .......................................................364
How to insert or delete rows through a view..............................................................366
How to alter or drop a view ........................................................................................368
How to use SQL Developer............................................................370
How to get information about a view..........................................................................370
How to drop a view.....................................................................................................370
How to alter or create a view ......................................................................................370
Chapter 12 How to manage database security
An introduction to database security...........................................374
How to create an admin user ...................................................................................... 374
How to use SQL Developer to view database objects for a schema........................... 376
How to create end users..............................................................................................378
How to use SQL*Plus to test end users.......................................................................380
System privileges and object privileges......................................................................382
How to manage database security................................................384
How to create, alter, and drop users ...........................................................................384
How to create and drop roles......................................................................................386
How to grant privileges...............................................................................................388
How to revoke privileges ............................................................................................390
How to work with private synonyms..........................................................................392
How to work with public synonyms ...........................................................................394
A script that creates roles and users ...........................................................................396
How to view the privileges for users and roles...........................................................400
How to use SQL Developer............................................................402
How to work with users..............................................................................................402
How to grant and revoke roles....................................................................................404
How to grant and revoke system privileges................................................................406

Section 4 The essential PL/SQL skills
Chapter 13 How to write PL/SQL code
An introduction to PL/SQL ............................................................ 414
An anonymous PL/SQL block in a script................................................................... 414
A summary of statements for working with PL/SQL and scripts.............................. 416
How to code the basic PL/SQL statements ................................. 418
How to print data to an output window ...................................................................... 418
How to declare and use variables ...............................................................................420
How to code IF statements..........................................................................................422
How to code CASE statements...................................................................................424
How to code loops.......................................................................................................426
How to use a cursor.....................................................................................................428
How to use collections................................................................................................430
How to handle exceptions...........................................................................................434
A list of predefined exceptions ...................................................................................436
Other scripting and PL/SQL skills ................................................438
How to drop database objects without displaying errors............................................438
How to use bind variables...........................................................................................440
How to use substitution variables...............................................................................440
How to use dynamic SQL...........................................................................................442
How to run a script from a command line..................................................................444
Chapter 14 How to manage transactions and locking
How to work with transactions......................................................452
How to commit and rollback transactions.................................................................. 452
How to work with save points.....................................................................................454
How to work with concurrency and locking.................................456
How concurrency and locking are related..................................................................456
The four concurrency problems that locks can prevent.............................................. 458
How to set the transaction isolation level ...................................................................460
How to prevent deadlocks...........................................................................................462
Chapter 15 How to create stored procedures and functions
How to code stored procedures....................................................466
How to create and call a stored procedure .................................................................466
How to code input and output parameters.................................................................. 470
How to code optional parameters............................................................................... 472
How to raise errors...................................................................................................... 474
A stored procedure that inserts a row......................................................................... 478
A stored procedure that drops a table.........................................................................482
How to drop a stored procedure..................................................................................484
How to code user-defined functions ............................................486
How to create and call a function ...............................................................................486
A function that calculates balance due .......................................................................488
How to drop a function ...............................................................................................490
How to work with packages...........................................................492
How to create a package .............................................................................................492
How to drop a package................................................................................................494
Advantages of packages..............................................................................................494
How to use SQL Developer............................................................496
How to view and drop procedures, functions, and packages.....................................496
How to edit and compile procedures and functions...................................................498
How to grant and revoke privileges............................................................................498
How to debug procedures and functions ....................................................................500
Chapter 16 How to create triggers
How to work with triggers..............................................................508
How to create a BEFORE trigger for a table ..............................................................508
How to use a trigger to enforce data consistency ....................................................... 510
How to use a trigger to work with a sequence............................................................ 512
How to create an AFTER trigger for a table .............................................................. 514
How to use an INSTEAD OF trigger for a view ........................................................ 516
How to use a trigger to work with DDL statements................................................... 518
How to use a trigger to work with database events .................................................... 518
How to enable, disable, rename, or drop a trigger......................................................520
Other skills for working with triggers...........................................522
How to code a compound trigger................................................................................522
A trigger that causes the mutating-table error............................................................524
How to solve the mutating-table problem...................................................................526
How to use SQL Developer............................................................528
How to view, rename, or drop a trigger......................................................................528
How to enable or disable a trigger ..............................................................................528
How to edit a trigger ...................................................................................................530
How to debug a trigger................................................................................................530

Section 5 Advanced data types
Chapter 17 How to work with timestamps and intervals
An introduction to time zones .......................................................536
Database time zone vs. session time zone .................................................................. 536
How to change the default date format....................................................................... 538
How to change the default time zone.......................................................................... 538
Session settings vs. database settings......................................................................... 538
How to use functions to work with time zones...........................................................540
How to work with timestamps .......................................................542
An introduction to the TIMESTAMP types...............................................................542
How to work with the TIMESTAMP type .................................................................544
How to work with the TIMESTAMP WITH LOCAL TIME ZONE type................546
How to work with the TIMESTAMP WITH TIME ZONE type ..............................548
Common format elements for timestamps..................................................................550
How to use functions to work with timestamps ......................................................... 552
How to work with intervals.............................................................556
An introduction to the INTERVAL types..................................................................556
How to work with the INTERVAL YEAR TO MONTH type .................................. 558
How to work with the INTERVAL DAY TO SECOND type ....................................560
How to use functions to work with intervals..............................................................562
Chapter 18 How to work with large objects
An introduction to large objects ...................................................566
The LOB types............................................................................................................566
APIs for working with LOBs......................................................................................566
How to use SQL to work with large objects.................................568
How to work with CLOBs ..........................................................................................568
How to work with NCLOBs........................................................................................568
How to work with BLOBs........................................................................................... 570
How to work with BFILEs..........................................................................................572
How to specify LOB storage options.......................................................................... 574
How to migrate to the new LOB types....................................................................... 576
How to use Java to work with large objects.................................578
The main method for the sample application ............................................................. 578
How to write an image to a table ................................................................................580
How to read an image from a table.............................................................................584
A utility class for working with databases..................................................................586
How to use PL/SQL to work with large objects...........................590
The methods of the DBMS_LOB package.................................................................590
An example that uses the DBMS_LOB package........................................................592
Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.


Group Training

Have a group of several students needing the same training? Then onsite training is a perfect option for you. We'll come onsite to your office so you don't have to travel. You'll be able to fully customize a course to your needs. Lastly, you can save per student versus our public classes.

How Onsite Training Works

  • An expert Instructor will come to your office and personally train the students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • If a course has a hands‐on lab, we provide access to the configured course software and files.
    (Requires a high‐speed internet connection and certain open ports on your firewall. You can perform a Connection Assessment Test here)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Quote

Oracle 12c/11g SQL & PL/SQL Class Reviews

Here are a sample of Oracle class reviews from past students that have attended our Oracle training courses.



This 5-day course teaches how to access Oracle 12c/11g databases through SQL statements and construct PL/SQL programs. Oracle Database 12c/11g SQL offers complete coverage of the latest database features and techniques. Find out how to write SQL statements to retrieve and modify database information, use SQL*Plus and SQL Developer, work with database objects, write PL/SQL programs, use performance optimization techniques, incorporate XML, and more. This course ontains everything you need to know to master Oracle PL/SQL.

Oracle Versions That Can Attend: 12c and 11g
Course Taught With: Oracle 12c Software and Courseware


Certstaffix® Class Reviews

Student Average:
4.85 out of 5 from 11 students

4.56 out of 5

The course was very useful and Mr. Jerry Richard presented the information clearly and effectively. I gained useful knowledge in SQL and PL/SQL.


- attended our Oracle 12c SQL & PL/SQL class

5.00 out of 5

Mr. Richard has an excellent teaching style. Normally I do not like virtual but he made it easy for me to learn and keep up. and was willing to take the time to make sure we all understood. The examples were a great help.


- attended our Oracle 12c SQL & PL/SQL class

4.62 out of 5

If you have prior experience with the subject, this is for you. But if you are really new on this, it can be challenging because the pace of this class is a little to fast for novices. the content, the book and professor Tom were great in general. maybe if the company change the length in time of this course would be perfect


- attended our Oracle 12c SQL & PL/SQL class

4.94 out of 5

I really enjoyed the class and learned a lot. Dr. Richard is a great instructor and very knowledge.


- attended our Oracle 12c SQL & PL/SQL class

5.00 out of 5

I hope to get Dave again for my upcoming DBA course with Certstaffix in Nov 2017. He was clear, patient (because I was slower than the other students), and kept us interested.


- attended our Oracle 12c SQL & PL/SQL class

4.94 out of 5


- attended our Oracle 12c SQL & PL/SQL class

5.00 out of 5


- attended our Oracle 12c SQL & PL/SQL class

4.76 out of 5


- attended our Oracle 12c Database Administration class

4.88 out of 5


- attended our Oracle 12c Database Administration class

4.86 out of 5


- attended our Oracle 12c Database Administration class

4.82 out of 5


- attended our Oracle 12c SQL & PL/SQL class



Please contact us if we do not yet have any reviews or you would like more.

Oracle Courses By City:

AB - Calgary       FL - Sarasota       NB - Moncton       PA - Scranton-Wilkes Barre      
AB - Edmonton       FL - Tallahassee       NB - Saint John       PA - York      
AK - Anchorage       FL - Tampa       NC - Asheville       PR - Puerto Rico      
AL - Birmingham       FL - Winter Park       NC - Charlotte       QC - Montreal      
AL - Huntsville       GA - Augusta       NC - Greensboro       RI - Providence      
AL - Mobile       GA - Columbus       NC - Raleigh       SC - Greenville      
AL - Montgomery       GA - Peachtree Corners       NC - Winston-Salem       SC - Myrtle Beach      
AR - Bentonville       GA - Savannah       ND - Bismarck       SC - North Charleston      
AR - Little Rock       HI - Honolulu       ND - Fargo       SD - Sioux Falls      
AZ - Phoenix       IA - Des Moines       NE - Lincoln       SK - Regina      
AZ - Tucson       IA - Iowa City       NE - Omaha       SK - Saskatoon      
BC - Vancouver       ID - Boise       NH - Bedford       TN - Chattanooga      
CA - Bakersfield       IL - Chicago       NJ - Bridgewater       TN - Knoxville      
CA - Fresno       IL - Rockford       NM - Albuquerque       TN - Memphis      
CA - Los Angeles       IN - Bloomington       NM - Las Cruces       TN - Nashville      
CA - Merced       IN - Evansville       NM - Santa Fe       TX - Amarillo      
CA - Modesto       IN - Fort Wayne       NS - Halifax       TX - Austin      
CA - Napa       IN - Indianapolis       NV - Henderson       TX - Beaumont      
CA - Oakland       IN - South Bend       NV - Reno       TX - Corpus Christi      
CA - Oxnard       KS - Topeka       NY - Albany       TX - Dallas      
CA - Rancho Cucamonga       KY - Lexington       NY - Buffalo       TX - El Paso      
CA - Sacramento       KY - Louisville       NY - New York City       TX - Fort Worth      
CA - Salinas       LA - Baton Rouge       NY - Rochester       TX - Houston      
CA - San Diego       LA - Lafayette       NY - Syracuse       TX - Killeen      
CA - San Jose       LA - New Orleans       OH - Beaver Creek       TX - Laredo      
CA - Santa Maria       LA - Shreveport       OH - Cincinnati       TX - Longview      
CA - Santa Rosa       MA - Burlington       OH - Cleveland       TX - Lubbock      
CA - Stockton       MA - Springfield       OH - Columbus       TX - McAllen      
CB - Caribbean       MA - Westborough       OH - Toledo       TX - Midland      
CB - Kingston       MB - Winnipeg       OH - Youngstown       TX - San Antonio      
CB - Nassau       MD - Largo       OK - Oklahoma City       TX - Tyler      
CO - Boulder       MD - Laurel       OK - Tulsa       TX - Waco      
CO - Colorado Springs       ME - Portland       ON - Ottawa       UT - Ogden      
CO - Denver       MI - Ann Arbor       ON - Toronto       UT - Salt Lake City      
CT - Cheshire       MI - Flint       OR - Beaverton       VA - Charlottesville      
CT - New Haven       MI - Grand Rapids       OR - Bend       VA - Glen Allen      
CT - Stamford       MI - Lansing       OR - Eugene       VA - Harrisonburg      
DE - Wilmington       MI - Livonia       OR - Medford       VA - Roanoke      
FL - Daytona Beach       MN - Minnetonka       OR - Salem       VA - Virginia Beach      
FL - Fort Lauderdale       MO - Columbia       PA - Allentown       VT - Burlington      
FL - Fort Myers       MO - Kansas City       PA - Erie       WA - Seattle      
FL - Gainesville       MO - St. Louis       PA - Harrisburg       WA - Spokane      
FL - Jacksonville       MS - Biloxi       PA - Malvern       WI - Eau Claire      
FL - Lakeland       MS - Jackson       PA - Philadelphia       WI - Green Bay      
FL - Miami       MT - Billings       PA - Pittsburgh       WI - Madison      
FL - Naples       MT - Montana       PA - Reading       WI - Milwaukee      
FL - Pensacola