What is the fastest way to learn SQL?
What is it?
The Structured Query Language (SQL) is the language used to query databases such as Oracle, Microsoft Access and MySQL.Understanding how to write queries can enable you to extract and process data exactly as you want it from databases such as Ensembl and many others.
The problem
What are the best resources to learn SQL fast?The answer: Selected resources for learning SQL fast
Fortunately, learning enough SQL to write useful queries is not difficult or time-consuming. Below are selected resources that will get you going in no time:- Introductory Web page from Dummies.com: Knowing Just Enough about Relational Databases.
- eBook: Beginning SQL, 2005, by Paul Wilton and John Colby - a great book for learning SQL.
- eBook: Learning SQL, by Alan Beaulieu. - a great way to learn SQL step by step. Also available as a physical book.
- eBook: SQL cookbook, 2006, by Anthony Molinaro - an excellent source of solved examples.
- eBook: Another excellent collection of examples: Access Data Analysis Cookbook, (2007).
- Quick reference card: A life-saver when you are programming and need to quickly refresh your mind. Here's an excellent source: Visibone's MySQL Cheat Sheets.
Other resources
- All Lane catalog resources on SQL.
Source
Lane LibrarianRecord created 12/6/2006.
- Anesthesia
- Biomedical Ethics
- Bioresearch
- Cardiology
- Clinical
- Consumer Health
- Emergency Medicine
- Global Health
- Hematology
- Internal Medicine
- LPCH Heart Center Nursing
- Medical Education
- Multicultural Health
- Neurology
- Nursing
- Obstetrics & Gynecology
- Oncology
- Ophthalmology
- Otolaryngology
- Pathology
- Pediatrics
- Pharmacy
- Physical Medicine & Rehabilitation
- PICU
- Psychiatry
- Pulmonary
- Reference Desk
- Special Programs
- Spiritual Care
- Student (IL)