CS101C Databases for Biologists, Level 1
From Bioinformatics.Org Wiki
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 the Bioinformatics Organization 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 like interfacing the database with the Microsoft Access front end. Mining the data using Perl database interface. Project discussion.
Typical data used to illustrate the concept of databases will be from microarray experiments or sequence operations.
If you are interested in an upcoming course, register using instructions below. (Access to completed courses is available to enrolled students only, because of privacy and confidentiality issues.)
- 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 the course by making a payment using either the on-line registration form (click on the name of the course where it appears in the list of upcoming courses; use this form only for PayPal payments and credit card payments via secured PayPal), or by sending in the registration form (PDF; use this form if paying by US checks, credit card or corporate purchase order).
Please also check the course tuition rates and discounts.
Registration deadline: When full
Tuition & discounts
- Live instruction held on-line
- For-profit & government: $500 USD
- Non-profit & self-pay: $300 USD
- Live instruction held on-site
- For-profit & government: $600 USD
- Non-profit & self-pay: $400 USD
- On-demand instruction held on-line
- For-profit & government: $300 USD
- Non-profit & self-pay: $200 USD
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).
The necessary software, lecture notes and exercises will be provided.
Live instruction held on-line
On-line/live courses use the WebEx on-line meeting system. Access information will be provided prior to the start of the course. Unless otherwise noted, each lecture begins at 16:00 GMT and runs for about an hour, depending on the topics covered.
For those who cannot attend the lectures at those times, the lectures will be recorded and placed on the course website as AVI video files each day, within one day. Students will also be able to communicate with the instructor and other students via the course forums. Lecture attendance is therefore not required.
Since this will be an interactive, hands-on workshop, all attendees will need a computer with a broadband Internet connection (1 Mbps or faster is strongly recommended for those watching the live lecture), a sound card with speakers, a modern Web browser, and Java. A microphone and webcam are not required but may be used.
This course is certified by the Bioinformatics Organization, Inc., the largest international affiliation in the field, and it will count as 3 "Continuing Scientific Education" (CSE) units (one unit per contact hour) within the Organization. Students completing the course will receive a certificate attesting to that.
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.
Please contact us for questions or additional information.