AIR QUALITY - MySQL WEBINAR SERIES

Please join us for a 2-part MySQL Webinar Series, presented by FHWA’s Baltimore Resource Center Air Quality staff, Kevin Black, Dr. Joon Byun, and Paul Heishman.  This webinar series is based on FHWA’s course titled “Air Quality MySQL Course” and is a general introduction to using the MySQL database for creating input databases for MOVES and for extracting the output data from the MOVES output databases for those who work on transportation-related air quality issues. The course will provide information on the various aspects of the MySQL database including the operations and commands used to select the data of interest. Data can also be manipulated using “automated browsers” that simplify the process of identifying and accessing the data of interest. Information will also provide for the development of specialized identification and access processes using scripts written in the MySQL language.  PLEASE READ THE MySQL SOFTWARE INSTALLATION INFORMATION BELOW!  

The webinar series will be presented over two days.  Sessions 1 and 2 will be presented on December 3, 2015 (1:30 pm – 4:30 PM) and sessions 3 and 4 will be presented on December 10, 2015 (1:30 pm – 4:30 PM).  It will be necessary for you to register individually for EACH webinar utilizing the links below.

 

Air Quality - MySQL Course - Part 1

December 03, 2015 at 1:30 – 4:30 PM EST

Register now for Part 1!


Contents

Session 1. INTRODUCTION TO MySQL
An Overview with Basic Commands

Session 2. CREATING/MANIPULATING DATA
Useful Commands
Exporting/Importing Data from MySQL

 

Air Quality - MySQL Course - Part 2

December 10, 2015 at 1:30 – 4:30 PM EST

Register now for Part 2!

Contents

Session 3. ADVANCED MySQL COMMANDS/SCRIPTS
Advanced Commands
Executing Scripts from External Files
Executing Scripts Using MOVES Interface

Session 4. ACCESSING MySQL DATA - THE EASY WAY
MySQL Query Browser
Executing Scripts from Query Browser
Workbench

NOTE:  After registering, you will receive a confirmation email containing information about joining the webinar.

 

 

PLEASE READ!

 

INSTRUCTIONS TO DOWNLOAD AND INSTALL MySQL ON YOUR COMPUTER:

 

(If you encounter issues when installing the required software, please contact your IT department for support)

 

MySQL should be downloaded and installed on your computer ahead of time. MySQL can be found on EPA’s MOVES Website as part of the entire MOVES2014 suite (see “Downloading MOVES2014” at www.epa.gov/otaq/models/moves/#downloading. Note that MOVES 2014a (a slightly updated version of MOVES2014 but the same model for conformity purposes) may be available by the end of October. However, the MySQL associated with MOVES2014 and MOVES 2014a should be the same. Please reference the attached documents for further information regarding MySQL installation and troubleshooting. If you continue to have troubles, please see the screen shot pictures on pages 13-27 in the MOVES Installation Guide.  If your MySQL seems to be installed, but does not run, please see More Troubleshooting.

 

Make sure you know exactly where you save MySQL on your computer, typically somewhere on your C:/ drive (where you place it on your computer may not be in the same location as the instructors have saved it on their computers).

 

You should have an understanding of DOS (how to access it, what the basic commands are, etc.) and the file structure of your computer’s program files to allow you to find the files needed.  In previous MySQL training sessions, there was some confusion about locating the MySQL Program and its files. Although knowing where on your C: drive the program is located isn’t essential, and probably won’t be a problem, we mention it since it has caused confusion before when some example doesn’t work correctly on a student’s computer and we try to help diagnose the problem.

 

The training slides from earlier presentations are available on the following DOT bulletin board: (https://connectdot.connectsolutions.com/mysql_training_info).  Please use the bulletin board website to access training material since it may be updated before the training begins. Check this bulletin board and download the slides from it a few days before the training. If the training slides are further updated the day of the training, the new material will be posted on this website.

 

If you’d like to “team up” (multiple students/registrants in the same room, using one telephone line) that is OK with us. We have found that when some questions come up, multiple students in the same room can sometimes help one another. Some of our training sessions have large numbers of participants so multiple participants in the same room extends our “instructors” by making you an instructor.

 

MySQL has a GUI “option” referred to as the MySQL Query Browser. We will coverthis in the training, along with a new GUI-type program within MySQL titled “Workbench”. Workbench will eventually replace Query Browser and will be briefly discussed in this course. However, MySQL is still a DOS-based program. You don’t need to recall all those DOS commands from decades ago, but knowing some might be useful.  Help with accessing the DOS operating system command prompt may be found at the following link:  http://www.marama.org/presentations/AccessingtheCMDPrompt.swf.