Introduction to SQL
- Did you install
Red Hat Linux 7.1 on your computer?
- Did you download and install MySQL locally?
- Is Perl DBI modules installed on your computer?
Why use a database?
- versus a file
- What is Object-based
- What is Object-Oriented
- What is a relational
- DDL (Data Definition
Language) - use to declare the structure of the database to DBMS
- DML (Data Manipulation
- relation = tables
- attribute = columns
- tuples = rows
of Biological Data
A Practical Approach to Database Design
In Class Design Problem:
Class design problem
As you walk down
the hall, you meet XX who tells you:
"We need a new database
as soon as possible to do the following:
and other information for mammalian membrane proteins
with 7 transmembrane domains:
I want to be able
to find information and generate reports based on the
the species of origin
the chromosome of origin
the official gene symbol
sequence accession numbers
protein molecular weight
We will first discuss how to convert this 'vague' request into a draft
schema to refine after talking more with XX.
NOTE: we need to
keep this simple, and do not want to spend multiple days
discussing multiple options of the design. So in preparing for the first
class, don't start worrying for example, about whether the molecular
weight is Mr or mass calculated from the amino acids sequence or ...
Read the Chapter
Tutorial of the full MySQL manual.
Once we have our
schema we can go ahead and start writing the SQL for retrieving, modifying
data, stored procedures. >> NEXT
MySQL and SQL Tutorial/Documentation: