CS101C Databases for Biologists, Level 1
From Bioinformatics.Org Wiki
Taught in the context of biological research, this course helps biologists learn 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. This course is certified by the Bioinformatics Organization, Inc., the largest international affiliation in the field, and it will count as 8 "Continuing Scientific Education" (CSE) credits (one credit per contact hour) within the Organization. Students completing the course will receive a certificate attesting to that.
- Day 1: Fundamentals of databases and deciding what to store, and how to install a database
- Day 2: Creating and designing a database. Populating the database with sample data
- Day 3: Data retrieval and manipulation concepts using SQL queries (Select, Update, Delete, Insert)
- Day 4: Additional topics like interfacing the database with the Microsoft Access front end. Mining the data using Perl database interface.
- Day 5: Project discussion
Typical data used to illustrate the concept of databases will be from microarray experiments or sequence operations.
This course has been offered several times. Access to completed courses is available to enrolled students only, because of privacy and confidentiality issues. If you are interested in an upcoming course, register using instructions below.
- Onsite course at CIT, National Institutes of Health, July 31 - Aug 1, 2006 (entire course covered in two sessions)
- Onsite course at CIT, National Institutes of Health, Dec 20 - 21, 2006 (entire course covered in two sessions)
Registration comprises of two steps. First, create an online account to access the educational section of our website. Second, register for this course by making a payment using either the online registration form (click on the scheduled course above; use this form only for credit card payments via secured PayPal), or by sending in the mail-in registration form (~150 kB PDF, use this form if paying by US checks, credit card or corporate purchase order). Please check the tuition rates and discounts below.
Registration deadline: When full
- Returning student discount: A 20% (rounded up) discount applies for students who have paid the base tuition (without a similar discount) for a course at Bioinformatics.Org that does not fall in the CS101 range (e.g., CS102A/B) (please use the mail-in registration form rather than PayPal if taking this discount).
- Cluster course discount: A 50% (rounded up) discount (cannot be combined with the 20% discount) applies for students who have paid the base tuition for a course that does fall in the CS101 range (please use the mail-in registration form rather than PayPal if taking this discount).
Tuition (all prices USD):
|Base tuition||If taken with a non-CS101
course at base tuition
|If taken with another CS101
course at base tuition
For full-time students and the unemployed, please inquire about an additional discount (verification required).
Online courses are offered on the ASAP online meeting system. Access information will be provided prior to the start of the course. Each lecture will last 45 to 90 minutes, 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 Flash videos (resolution reduced by 30%) 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 the Adobe Flash plugin. Please check the specific system requirements for your computer. A microphone and webcam is not required for this course. The necessary software, lecture notes and exercises will be provided.
If you have any questions, please send a message to J.W. Bizzaro (login required) or call +1 508 890 8600.