MySQL Workbench: Data Modeling & Development Course

SQL Training Online & Onsite

Attend Our Classes From Home - No Software Needed - Learn More...

SQL TrainingMySQL Workbench: Data Modeling & Development

by Certstaffix® Training

Length: 4 day(s)      Public Class Price: $2280/person (USD)      Group Class Price: Request Quote      Course Category: SQL


SQL Training
MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The course covers the interface and explains how to accomplish each step by illustrating best practices visually.

Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. 

Complete coverage
Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances
Course Description: Print It | Download PDF | Email It

  Public Classes - Live Online at Your Location or OursHow It Works

Certstaffix® Training public classes are instructor-led, live online training you attend from your home or work or in one of our local computer labs. 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/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options.

 Register ➥   June 22, 2021     
 Register ➥   March 2, 2021     

  Group Classes for Organizations - Onsite or Online How It Works

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.  

  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • 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

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Course Topics

Part I Configuration
1. Installing and Configuring
2. Creating and Managing Connections

Part II Data Modeling
3. Data Modeling Concepts
4. Creating and Managing Tables and Relations
5. Creating and Managing Routines
6. Reverse Engineering

Part III SQL Development
7. Editing Data
8. Managing SQL Scripts

Part IV Server Administration
9. Instances
10. Creating and Managing Users and Roles
11. Imports and Exports
12. Migrating Databases

Part V Appendixes and Glossary
A. Mastery Check Answers
B. Extending MySQL Workbench
C. Setting Up SQL Server

Glossary
Index
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 employees needing the same training? Onsite training at your office or group live online classes are great solutions.

How Group Training Works





  • An expert Instructor will either come to your office or deliver a private live online class to your 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

MySQL Workbench: Data Modeling & Development Class Reviews

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



MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The course covers the interface and explains how to accomplish each step by illustrating best practices visually.

Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. 

Complete coverage
Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances


Certstaffix® Class Reviews

Student Average:
4.77 out of 5 from 254 students

4.73 out of 5

Wonderful content and instructor. Sheila also assisted me in getting scheduled for the class.I would highly recommend!


- attended our SQL Querying - Basic class

4.71 out of 5

Try to reference the the text more, we did not seem to use the text at all


- attended our SQL Querying - Basic class

4.95 out of 5

This was the best virtual training class I have taken. Instructor kept everyone involved and could tell if anyone was struggling. It required everyone to keep up with the class as if they were in the classroom.The only thing I would say is that I didn't feel this was "Advanced" material. The concepts that were in this class should already be known if you're taking an advanced SQL class. Wish there was a more advanced class maybe more stored procedure driven?


- attended our SQL Querying - Advanced class

4.66 out of 5

This was the best course that I have taken online. Very organized and professionally managed.


- attended our SQL Querying - Basic class

4.41 out of 5

This is the second SQL course I've taken with Serge Belich. He does a great job of explaining the database logic as well as how the topics can be applied in the real world. Serge starts with basic syntax then increases the complexity so you understand how each step impacts the end result. The course is engaging and extremely hands on. I was very pleased with the course and instructor - would definitely recommend to others!


- attended our SQL Querying - Advanced class

5.00 out of 5

This is my second course through Certstaffix and I would gladly sign up for others in the future.


- attended our SQL Querying - Advanced class

4.82 out of 5

This class was great and I feel confident that I can use most of what I have learned in my work environment! I think it would have helped if there was a short summary/review in the beginning to differentiate functions, statements, commands, etc. I still don't understand why some are blue or pink and why some need parenthesis while others don't. However, I have a feeling that with practice and reviewing the manual, I will catch on to the trend and figure this out.


- attended our SQL Querying - Basic class

5.00 out of 5

The SQL Query for beginners course was great. The teacher did a wonderful job in balancing between allowing the students to work on the queries by themselves and stepping in to assist. Also great sense of humor and very willing to answer any questions along the way. Definitely would recommend Cerstaffix.


- attended our SQL Querying - Basic class

4.63 out of 5

The presenter was awesome.


- attended our SQL Querying - Basic class

4.85 out of 5

The only issue I had was I already knew much of the material. Otherwise it was a really good course.The instructor was excellent!


- attended our SQL Querying - Basic class

5.00 out of 5

The instructor, Michelle Buchecker, was very informative and engaging. I highly recommend her!


- attended our SQL Querying - Basic class

4.76 out of 5

The instructor, Michelle Buchecker, was outstanding. She explained things in detail and did not make anyone feel bad when their mistakes or questions seemed odd. She made the class engaging and interesting and was very thorough in explaining everything. It was a good mix of tracing and exercises.


- attended our SQL Querying - Basic class

4.98 out of 5

The instructor was very clear and easy to understand as to the various subjects and tasks assignments.


- attended our SQL Querying - Basic class

4.96 out of 5

The instructor was patient and careful enough not to call anyone out when they were struggling.


- attended our SQL Querying - Basic class

5.00 out of 5

the instructor was great and not boring!


- attended our SQL Querying - Basic class

4.61 out of 5

The Instructor was fantastic!


- attended our SQL Querying - Advanced class

4.50 out of 5

The instructor was clearly knowledgeable and able. However, I feel the course description made the class out to be more advanced than it was. I still learned some things and enjoyed it, it was just less technical than expected.


- attended our SQL Querying - Advanced class

4.85 out of 5

The instructor Serge was a very informative and great instructor. Would recommend him again.


- attended our SQL Querying - Basic class

4.94 out of 5

The instructor Serge B. was very engaging and extremely patient.


- attended our SQL Querying - Basic class

4.83 out of 5

The instructor did a good job of teaching the material. The course was a good blend of learning and hands on learning with the labs. Instructor organized the material and facilitated the course well.


- attended our SQL Querying - Basic class

4.55 out of 5

The course was excellent and Michelle Buchecker did a great job. My only suggestion would be to make some of the examples in the power point slides more realistic and thus easier to wrap your mind around. For example, instead of having "Table 1" with "Column A", if a specific scenario was used it might make it a little easier to understand. That is a very minor critique though as the course and instructor were fantastic!


- attended our SQL Querying - Basic class

5.00 out of 5

The book is great. Michelle was awesome very knowledgeable and wanted to make sure that we understood. It would be nice if we had some take home problems to get more practice .


- attended our SQL Querying - Basic class

4.28 out of 5

Thank you, Michelle for your patience!


- attended our SQL Querying - Basic class

4.91 out of 5

Serge was fantastic! He presented the material clearly and made the whole learning experience fun. I picked up quite a few new things that will help me with my work in the future.


- attended our SQL Querying - Advanced class

4.53 out of 5

Serge was by far the best instructor. For example, two so far have explained indexed and non indexed in SQL to the class, and Serge was the third. He was the first one to use a visual example *first* and then explain from there. That was the first time an instructor literally used a visual in every explanation. Highly effective. Moreover, he knows what he is teaching *and* he knows how to teach. Two very different things.


- attended our SQL Querying - Advanced class

4.88 out of 5

Serge was awesome. He taught clearly and at a great pace that kept your attention. I am excited to practice my new understanding of SQL.


- attended our SQL Querying - Basic class

4.27 out of 5

Serge was an awesome teacher. Very knowledgeable and patient. Maybe an extra day with leisure testing/quizzing to help attendees retain the knowledge


- attended our SQL Querying - Basic class

4.65 out of 5

Serge was a good instructor. Had plenty of personality to keep me engaged and interested.


- attended our SQL Querying - Basic class

4.83 out of 5

Serge ran a very good class. learned a ton & I hope there will be other advanced SQL class in the future


- attended our SQL Querying - Advanced class

4.71 out of 5

Serge did an excellent job demonstrating the processes of SQL.


- attended our SQL Querying - Basic class

4.88 out of 5

Serge Belich was well informed and prepared instructor who routinely confirmed all students were on task with what he was instructing and had excellent command of the material and online classroom environment. I appreciated his "no man left behind," approach to teaching. Before this class even ended I had already decided to look for other classes he teaches.


- attended our SQL Querying - Basic class

4.60 out of 5

Serge Belich is an amazing instructor!! I took the Basic and Advanced SQL training course with him and he has a great personality, fun + interactive teaching style, and made the class experience such a great time. He is one of the best instructors I have ever come across for material like this.


- attended our SQL Querying - Advanced class

4.90 out of 5

Serg was an awesome instructor! Can we search courses through the site that he may also teach?


- attended our SQL Querying - Advanced class

4.52 out of 5

Presenter/Instructor (Michelle) was excellent


- attended our SQL Querying - Advanced class

4.00 out of 5

Overall great course.


- attended our SQL Querying - Basic class

4.92 out of 5

no improvements necessary


- attended our SQL Querying - Basic class

4.88 out of 5

My instructor John was amazing. He did an outstanding job


- attended our SQL Querying - Basic class

4.96 out of 5

Microsoft book if possible. not mandatory


- attended our SQL Querying - Advanced class

4.35 out of 5

Michelle was was very clear and well spoken. This was my first look at SQL and I now have the confidence to take a second at my real job.


- attended our SQL Querying - Basic class

5.00 out of 5

Michelle was excellent. She was very patient with those of use that didn't quite understand certain parts and helped us to better understand. She certainly knows the product which makes her a good teacher.


- attended our SQL Querying - Basic class

4.58 out of 5

Michelle was a wonderful trainer! The course was interactive, and organized in a logical manner. Would definitely return (for more advanced training of course, since I feel like I've mastered this content). Thanks!


- attended our SQL Querying - Basic class

4.80 out of 5

Michelle M was my instructor and she was thorough, knowledgeable and helpful. She guided the students and managed the pace of the class so that we were able to get in enough practice time with the different concepts that were covered.


- attended our SQL Querying - Basic class

4.82 out of 5

Michelle is an excellent teacher! I found the material extremely beneficial and her style of teaching was very engaging. I'm looking forward to the advanced class next.


- attended our SQL Querying - Basic class

4.93 out of 5

Michelle Buchecker was a great facilitator. She explained everything very well, was quick to respond to questions and assist when needed. She never showed frustration with 1 or 2 individuals that needed constant attention.


- attended our SQL Querying - Basic class

5.00 out of 5

Michelle B. was an excellent instructor!


- attended our SQL Querying - Advanced class

5.00 out of 5

Loved the class, and hope to be able to take the advanced class with Jeff in the future!


- attended our SQL Querying - Basic class

4.87 out of 5

Love these courses! Instructor was great.I will definitely be looking into python courses through Certstaffix.Only thing that would improve the class would be an easier way for us to send ourselves the notes we took


- attended our SQL Querying - Advanced class

5.00 out of 5

John was great! He was knowledgeable, enthusiastic, and he explained everything in a easy way.


- attended our SQL Querying - Basic class

4.93 out of 5

John is an excellent instructor and clearly has a knack for explaining things in a fun and easy to understand manner. Hope to take another of his courses in the future.


- attended our SQL Querying - Basic class

4.88 out of 5

Jeffry Pilch is an excellent instructor. The class was informative and beneficial to me. I would highly recommend this course.


- attended our SQL Querying - Advanced class

4.00 out of 5

It's good Keep it Up!


- attended our SQL Querying - Basic class

4.78 out of 5

It is great that I didn't have to download anything - I like the remote PC usage.


- attended our SQL Querying - Advanced class

4.64 out of 5

Instructor went at a perfect pace just enough time to complete everything/take notes. Gave plenty of time for questions, always quick to answer. Surprised at how much I learned and was able to quickly apply.


- attended our SQL Querying - Basic class

4.77 out of 5

Instructor was great, I learned a lot


- attended our SQL Querying - Basic class

4.96 out of 5

Instructor was excellent.


- attended our SQL Querying - Basic class

4.35 out of 5

Instructor very competent, pleasing voice, assisted with offline conversation, flexible to varying needs. Not all topics presented in syllabus were presented.


- attended our SQL Querying - Basic class

4.83 out of 5

instructor kept the teaching lively and was able to answer any technical question ions I had adequately


- attended our SQL Querying - Basic class

4.59 out of 5

Including the sample query as part of the exercise was very helpful. Without having the sample having been already created in the environment, you had to search the book for syntax and there wasn't really a lot of time to allow fully searching a book we just received prior to the course. The instructor did a good job in noticing the need to supplement the slides to incorporate the sample into the exercise.


- attended our SQL Querying - Basic class

5.00 out of 5

I would love to have this class continued! It was a wonderful Class and awesome Instructor!


- attended our SQL Querying - Advanced class

4.90 out of 5

I would like to recieve the course book at least 2 weeks ahead of time


- attended our SQL Querying - Basic class

5.00 out of 5

I was happy with the content as well as the level of knowledge the instructor had. He set the right pace depending on the level of difficulty of the material. This was great as I have been in other online training (not Cetstaffix) where the instructor may have spent too much time early on and then we seem to fly through the more complex material. Thank you!


- attended our SQL Querying - Basic class

4.96 out of 5

I really enjoyed Serge Belich as the trainer he was welcoming, friendly and allowed a lot of time for questions and learning checks. In addition, balanced the time between lecture, lab, and SQL concepts very well. I would take courses with him again.


- attended our SQL Querying - Basic class

4.40 out of 5

I love my instructor Serge Belich, he was great!!


- attended our SQL Querying - Basic class

4.78 out of 5

I had not previously participated in an online class and was unsure of what to expect. This class exceeded any expectations I might have had. My location in Burlington, MA was comfortable and I appreciated the privacy of the space.Michelle Buchecker was extremely knowledgeable and had superb presentation skills. I particularly admired how she handled the lab activities and the varying ability levels of the participants.


- attended our SQL Querying - Basic class

4.80 out of 5

Great instructor! Knowledgeable and skilled at teaching adults


- attended our SQL Querying - Basic class

4.94 out of 5

Great instructor!


- attended our SQL Querying - Basic class

5.00 out of 5

great course, learned so much in these 2 days. Michelle was a great instructor


- attended our SQL Querying - Basic class

4.83 out of 5

Great Class!!


- attended our SQL Querying - Basic class

4.55 out of 5

Great business model. Works very well.


- attended our SQL Querying - Advanced class

4.53 out of 5

Great 1 day class. Picked up some new information that'll help me continue to learn SQL. I would have been okay with more information presented, but the amount of content was good.


- attended our SQL Querying - Advanced class

4.76 out of 5

Going into the training I was very skeptical about this type of learning environment; however, it turned out to be excellent. I liked the fact Michelle could see our work and provide guidance. I also liked that fact that she made us think about our coding rather than just lecturing or providing the answer. I also like how prompt she was in returning from breaks. There really was no wasted time.


- attended our SQL Querying - Basic class

4.67 out of 5

For an entry level class this course covered a lot. It covered way more than I will be using for my current position. I got all I needed and a lot more.


- attended our SQL Querying - Basic class

4.86 out of 5

Excellent course. Professor was excellent in regards to presentation of the material. What can typically be very dry information was presented in a fun and informative way. The book was not utilized but I will definitely reference it as I expand my roles with my company. I will most definitely look to take the Advanced SQL course down the line.


- attended our SQL Querying - Basic class

5.00 out of 5

Coursework was appropriate and logical followup to basic course. Skilled and knowledgeable instructor, experience teaching in this environment showed.


- attended our SQL Querying - Advanced class

4.83 out of 5

Course was great, I learned alot over the course of 2 days!


- attended our SQL Querying - Basic class

4.72 out of 5

Course was good and demonstrated useful code. My favorite part of Serge's instruction was his explanations and analogies - I felt like he did a great job applying each concept to a business scenario, so it wasn't just code in a vacuum like some courses. At the beginning I felt a self-paced online SQL course/forums would be a better fit for me...but Serge provided some perspectives I would have missed. I loved Serge's accent, his energy, and his expertise. I kinda wish this class were longer than one day so he could *really* show us some stuff! Thanks!


- attended our SQL Querying - Advanced class

5.00 out of 5

Certstaffix employees and instructor were very friendly and helpful


- attended our SQL Querying - Basic class

5.00 out of 5

Both courses have been exceptional. Perfect for my learning style. I have been able to use SQL quite a bit since the basic class last fall. This was easy to build upon what we learned previously. Very logical. Already thinking of ways to apply on our data. Thank you.


- attended our SQL Querying - Advanced class

5.00 out of 5

Although my previous experience with SQL is above the basic level the course was still valuable. I learned SQL on a different platform than the primary platform used on the job. The course contained some topics about functions that I don't use often but can be useful. The examples of how they can be used are very helpful. The interaction with other students and the instruction was very good and it was almost as good as being in the same room. Nice job!


- attended our SQL Querying - Basic class

4.79 out of 5


- attended our SQL Querying - Basic class

4.58 out of 5


- attended our SQL Querying - Basic class

4.57 out of 5


- attended our SQL Querying - Basic class

4.59 out of 5


- attended our SQL Querying - Basic class

4.51 out of 5


- attended our SQL Querying - Basic class

4.72 out of 5


- attended our SQL Querying - Advanced class

4.65 out of 5


- attended our SQL Querying - Basic class

4.29 out of 5


- attended our SQL Querying - Basic class

4.71 out of 5


- attended our SQL Querying - Basic class

4.88 out of 5


- attended our SQL Querying - Advanced class

4.24 out of 5


- attended our SQL Querying - Basic class

4.76 out of 5


- attended our SQL Querying - Basic class

4.82 out of 5


- attended our SQL Querying - Basic class

5.00 out of 5


- attended our SQL Querying - Basic class

4.93 out of 5


- attended our SQL Querying - Basic class

5.00 out of 5


- attended our SQL Querying - Basic class

4.76 out of 5


- attended our SQL Querying - Basic class

4.94 out of 5


- attended our SQL Querying - Basic class

5.00 out of 5


- attended our SQL Querying - Basic class

4.94 out of 5


- attended our SQL Querying - Basic class

5.00 out of 5


- attended our SQL Querying - Basic class



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


View all SQL training reviews

SQL Courses By City:

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