CS101C MySQL for Biologists, Level 1

Taught in the context of biological research, this course teaches biologists how to use the database management system MySQL to store, manage and query biological information. Armed with some knowledge and hands-on experience with a database system, scientists taking a CS101 course at Bioinformatics.org will be able to perform basic data storage tasks and phrase research questions in the context of the database. As a result, they will be able to appreciate and use computers better in their organization and communicate better with their IT group.

No experience is required, although prior experience with any database system (Microsoft Access) will be helpful.

Session 1

Fundamentals of databases and deciding what to store, and how to install a database

Session 2

Creating and designing a database; populating the database with sample data

Session 3

Data retrieval and manipulation concepts using SQL queries (Select, Update, Delete, Insert)

Session 4

Additional topics such as interfacing the database with the Microsoft Access front end and mining the data using Perl database interface; project discussion

This course is taught by Shailender Nagpal, M.S.

Registration

Registration for courses at Bioinformatics.org takes two steps:

Step 1

If you haven't already done so, create an on-line account to access the educational section of our website. Please note that the registration for our educational system is separate from that of the main website; you will require another account.

Step 2

Register for this course by sending in the registration form (PDF; use this form if paying by US checks, credit card or corporate purchase order).

On-demand course held on-line

This course might be taught on-demand, on-line. Please check the list of on-demand courses to see if this course can be taken as such.

An on-demand version provides pre-recorded video lectures. Once registered, you may begin by viewing the first lecture video, and if you have any questions, you may then email the instructor.

Slides are available with both on-demand and live of courses, and many also have examples (such as data and scripts). Assignments are also provided for your edification but are not graded. And, when finished, you may request a certificate of attendance.

On-demand course tuition:

• For-profit & government: $300 USD
• Non-profit & self-pay: $200 USD
• See below for additional discounts.

Students who've taken the on-demand version of this course can access the course page here.

Live course held online

This course might also be taught live, on-line. Please check the calendar to see if it will be held in the near future.

Live, online course tuition:

• For-profit & government: $500 USD
• Non-profit & self-pay: $300 USD
• See below for additional discounts.

Registration deadline: When full

Students who've taken the live course can continue to access their course pages here. (Access to completed courses is available to enrolled students only, because of privacy and confidentiality issues.)

Live course held on-site

We can come to your facility to teach this course. Please contact us for additional information.

Discounts

Additional discounts are available as follows:

• Professional members: 20% discount
• Limited scholarships may also be available for those residing in low-income economies (please inquire).

Certification

This course is certified by Bioinformatics.org, one of the oldest and largest international affiliations in the field, and it will count as 3 "Continuing Scientific Education" (CSE) units (one unit per contact hour) within Bioinformatics.org. Students completing the course will receive a certificate attesting to that.

Refund policy

For any course type, if a student is not satisfied with the conduct or content of a course, they may request a full refund within the first two days of lecture. After two days but within a week, a 50% refund will be granted. After one week, a 100% credit toward another course will be granted. No refunds or credits apply beyond those stated here.

Additional information

Please contact us for questions or additional information.

See also

• Educational services at Bioinformatics.org