SQL in Biomedical Databases?

Question

What are the main features, advantages and benefits of the database querying tool Standard Query Language or SQL? In what sorts of setting is it most often used? What are its advantages over other database querying tools??? Please give examples of how SQL may be used in retrieving information from, for example, a database of symptoms of, and approved medicines for, acute malaria.

Answer 1

SQL is used in almost every database system, from Oracle to IBM's DB2. Even MS SQL server and Access. It is a common way for folks to extract data. It certainly beats the old way of coding for each DB system in a different way.

Select disease, symptom, diagnosis, occur_dt
from your_table
where upper(disease) like 'MALARIA'

Answer 2

is this a trick question ?

SQL is used to query and manipulate data in a normalized relational database. SQL statements are very easy to write, not case sensitive and the database is secure. a user just gcan't stumble upon a SQL database and view and/or edit data. ythe data is stored the database in a nice safe centralized server somewhere and the client application on the workstation

Answer 3

ask youself this:

how likely is it if you are spoonfed answers for your homework, that you will learn the material.
what do you think are the main features of SQL?
what do you think are the main benefits of SQL?
what do you think are its advantages...
why not try to give some thought to your problem and by all means ask such general question but at least make an effort to answer your own homework

Answer 4

OH FRACK - they left you in charge of the keys to the Kryptonite cabinet again, did they?

STRUCTURED query language, not standard.

You are not qualified to ask this question - use excel instead.

You want real sql? swallow this:

select t_leac,t_bpid,
cast(sum(t_amth_1 * (substring (convert (char(2),(((2 + 10 * (cast(t_dbcr as integer)-1))))),1,1)
- cast(t_dbcr as integer))) as money)
from ttfgld106440
where t_leac in ('1381','1398','1480','2410','2412','2460','2465')
and t_catg not in (1,9)
group by t_leac,t_bpid
go