MySQL is a database management system (DBMS) used for storing and querying data. It has an interactive mode for executing queries as well as a batch mode for executing multiple statements, making it ideally suited for rapid prototyping and automation.

Introduction: MySQL is a database management system (DBMS) used for storing and querying data. It has an interactive mode for executing queries as well as a batch mode for executing multiple statements, making it ideally suited for rapid prototyping and automation.


Why learn MySQL? MySQL is ideally suited for bioinformatics because it is easy to learn and useful for storing data in a structured environment that can be used for querying later. Connectors allow you to insert or retrieve data through Perl, R, Python, Matlab and other languages, allowing biologists to build powerful, automated workflows.

Logistics: This online MySQL course is divided into 4 sessions and comes with pre-recorded videos, handouts, reference cards, examples, data, scripts and quizzes. Enrollees can contact the instructor with questions and get help on the projects. The main topics are listed below. Homework assignments will involve running commands learned in the live lectures.


Requirements: There are no degree prerequisites for this course, but basic knowledge of computers is essential.


Price: $1200 for Commercial/Government enrollees and $600 for Academic researchers and students.


Syllabus:

  • - Getting started with the MySQL DBMS. Installing MySQL
  • - Deciding what to store
  • - Creating and designing a database
  • - Populating a database with sample data
  • - Data retrieval and manipulation concepts using SQL queries (Select, Update, Delete, Insert)
  • - Installing connectors through ODBC and JDBC
  • - Interfacing with the database from Microsoft Access

Introduction: MySQL is a database management system (DBMS) used for storing and querying data. It has an interactive mode for executing queries as well as a batch mode for executing multiple statements, making it ideally suited for rapid prototyping and automation.


Why learn MySQL? MySQL is ideally suited for bioinformatics because it is easy to learn and useful for storing data in a structured environment that can be used for querying later. Connectors allow you to insert or retrieve data through Perl, R, Python, Matlab and other languages, allowing biologists to build powerful, automated workflows.


Logistics: This online MySQL course is divided into 4 sessions and comes with pre-recorded videos, handouts, reference cards, examples, data, scripts and quizzes. Enrollees can contact the instructor with questions and get help on the projects. The main topics are listed below. Homework assignments will involve running commands learned in the live lectures.


Requirements: MySQL Level 1 or equivalent is required.


Price: $1200 for Commercial/Government enrollees and $600 for Academic researchers and students.


Syllabus:

  • - Good database practices, special notes, shortcuts, basic commands you may have forgotten
  • - Joins, triggers and indexes, Mysql variables, scripting
  • - ER diagrams, database administration, permissions, configuration, backup
  • - The 5 normal forms for database design, referential integrity, data normalization
  • - Performance and efficiency: Database optimization
  • - Case studies