Search research articles

ABOUT JoVE

Overview Leadership Blog JoVE Help Center

AUTHORS

Publishing Process Editorial Board Scope & Policies Peer Review FAQ Submit

LIBRARIANS

Testimonials Subscriptions Access Resources Library Advisory Board FAQ

RESEARCH

JoVE Journal Methods Collections JoVE Encyclopedia of Experiments Archive

EDUCATION

JoVE Core JoVE Business JoVE Science Education JoVE Lab Manual Faculty Resource Center Faculty Site

Terms & Conditions of Use

Search research articles

Related Experiment Videos

Structured Query Language (SQL) fundamentals.

D Curtis Jamison¹

¹George Mason University, Manassas, Virginia, USA.

Current Protocols in Bioinformatics

|April 23, 2008

Summary

This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by

Same author

Microarrays and RNA-Seq identify molecular mechanisms driving the end of nephron production.

BMC developmental biology·2011

Same author

Ontogenomic study of the relationship between number of gene splice variants and GO categorization.

Bioinformatics (Oxford, England)·2010

Same author

The EDGE hypothesis: epigenetically directed genetic errors in repeat-containing proteins (RCPs) involved in evolution, neuroendocrine signaling, and cancer.

Frontiers in neuroendocrinology·2008

Same author

Statistical geometry based prediction of nonsynonymous SNP functional effects using random forest and neuro-fuzzy classifiers.

Proteins·2008

Same author

SpliceMiner: a high-throughput database implementation of the NCBI Evidence Viewer for microarray splice variant analysis.

BMC bioinformatics·2007

Same author

The distribution of SNPs in human gene regulatory regions.

BMC genomics·2005

Same journal

Protein Sequence Analysis Using the MPI Bioinformatics Toolkit.

Current protocols in bioinformatics·2020

Same journal

Exploring Manually Curated Annotations of Intrinsically Disordered Proteins with DisProt.

Current protocols in bioinformatics·2020

Same journal

Network Building with the Cytoscape BioGateway App Explained in Five Use Cases.

Current protocols in bioinformatics·2020

Same journal

Expanding the Perseus Software for Omics Data Analysis With Custom Plugins.

Current protocols in bioinformatics·2020

Same journal

Exploring Non-Coding RNAs in RNAcentral.

Current protocols in bioinformatics·2020

Same journal

How to Illuminate the Dark Proteome Using the Multi-omic OpenProt Resource.

Current protocols in bioinformatics·2020

See all related articles

Learn to use Structured Query Language (SQL) with the MySQL package for relational database management. This guide simplifies complex data analysis through straightforward SQL queries and database interaction.

Area of Science:

Computer Science
Data Management

Background:

Relational databases are the standard for data storage.
Structured Query Language (SQL) is essential for database interaction.

Purpose of the Study:

To demonstrate using the MySQL package for relational database creation.
To illustrate interaction with relational databases via SQL.

Main Methods:

Utilizing the MySQL package.
Employing Structured Query Language (SQL) for data manipulation.

Main Results:

Successful creation and interaction with a relational database.
Demonstration of complex data analysis using simple SQL syntax.

Conclusions:

Related Experiment Videos

SQL provides a powerful yet accessible method for sophisticated data analysis.
The MySQL package facilitates efficient relational database management.