Knowledge and skills

Sherlock Holmes (right) and Dr. Watson, by Sidney Paget.
In the first story, A Study in Scarlet, something of Holmes's background is given. In early 1881, he is presented as an independent student of chemistry with a variety of very curious side interests, almost all of which turn out to be single-mindedly bent towards making him superior at solving crimes. (When he appears for the first time, he is crowing with delight at having invented a new method for detecting bloodstains; in other stories he indulges in recreational home-chemistry experiments, sometimes filling the rooms with foul-smelling vapours.) An early story, "The Adventure of the Gloria Scott", presents more background on what influenced Holmes to become a detective: a college friend's father richly complimented his deductive skills. Holmes maintains strict adherence to scientific methods and focuses on logic and the powers of observation and deduction.
Holmes also makes use of phrenology, which was widely popular in Victorian times but now regarded as pseudo-scientific: In "The Adventure of the Blue Carbuncle", he infers from the large size of a man's hat that the owner is intelligent and intellectually inclined, on the grounds that “a man with so large a brain must have something in it”.
In A Study in Scarlet, Holmes claims he does not know that the Earth revolves around the Sun, as such information is irrelevant to his work. Directly after having heard that fact from Watson, he says he will immediately try to forget it. He says he believes that the mind has a finite capacity for information storage, and so learning useless things would merely reduce his ability to learn useful things. Dr. Watson subsequently assesses Holmes's abilities thus:
  1. Knowledge of Literature – nil.
  2. Knowledge of Philosophy – nil.
  3. Knowledge of Astronomy – nil.
  4. Knowledge of Politics – Feeble.
  5. Knowledge of Botany – Variable. Well up in belladonna, opium and poisons generally. Knows nothing of practical gardening.
  6. Knowledge of Geology – Practical, but limited. Tells at a glance different soils from each other. After walks, has shown me splashes upon his trousers, and told me by their colour and consistence in what part of London he had received them.
  7. Knowledge of Chemistry – Profound.
  8. Knowledge of Anatomy – Accurate, but unsystematic.
  9. Knowledge of Sensational Literature – Immense. He appears to know every detail of every horror perpetrated in the century.
  10. Plays the violin well.
  11. Is an expert singlestick player, boxer and swordsman.
  12. Has a good practical knowledge of British law.

--Sir Arthur Conan Doyle, A Study in Scarlet
At the very end of A Study in Scarlet itself, it is shown that Holmes knows Latin and needs no translation of Roman epigrams in the original—though knowledge of the language would be of dubious direct utility for detective work, all university students were required to learn Latin at that time.
Later stories also contradict the list. Despite Holmes's supposed ignorance of politics, in "A Scandal in Bohemia" he immediately recognises the true identity of the supposed "Count von Kramm". Regarding nonsensational literature, his speech is replete with references to the Bible, Shakespeare, even Goethe. He is able to quote from a letter of Flaubert to George Sand and in the original French.
Moreover, in "The Adventure of the Bruce-Partington Plans" Watson reports that in November 1895 "Holmes lost himself in a monograph which he had undertaken upon the Polyphonic Motets of Lassus"—a most esoteric field, for which Holmes would have had to "clutter his memory" with an enormous amount of information which had absolutely nothing to do with crime-fighting—knowledge so extensive that his monograph was regarded as "the last word" on the subject. The later stories abandon the notion that Holmes did not want to know anything unless it had immediate relevance for his profession; in the second chapter of The Valley of Fear, Holmes instead declares that "all knowledge comes useful to the detective", and near the end of "The Adventure of the Lion's Mane" he describes himself as "an omnivorous reader with a strangely retentive memory for trifles".
Holmes is also a competent cryptanalyst. He relates to Watson, "I am fairly familiar with all forms of secret writing, and am myself the author of a trifling monograph upon the subject, in which I analyse one hundred and sixty separate ciphers". One such scheme is solved using frequency analysis in "The Adventure of the Dancing Men".
Holmes's analysis of physical evidence is both scientific and precise. His methods include the use of latent prints such as footprints, hoof prints and bicycle tracks to identify actions at a crime scene (A Study in Scarlet, "The Adventure of Silver Blaze", "The Adventure of the Priory School", The Hound of the Baskervilles, "The Boscombe Valley Mystery"), the use of tobacco ashes and cigarette butts to identify criminals ("The Adventure of the Resident Patient", The Hound of the Baskervilles), the comparison of typewritten letters to expose a fraud ("A Case of Identity"), the use of gunpowder residue to expose two murderers ("The Adventure of the Reigate Squire"), bullet comparison from two crime scenes ("The Adventure of the Empty House"), analysis of small pieces of human remains to expose two murders (The Adventure of the Cardboard Box) and even an early use of fingerprints ("The Norwood Builder"). Holmes also demonstrates knowledge of psychology in "A Scandal in Bohemia", luring Irene Adler into betraying where she had hidden a photograph based on the "premise" that an unmarried woman will seek her most valuable possession in case of fire, whereas a married woman will grab her baby instead.
Despite the excitement of his life (or perhaps seeking to leave it behind), Holmes retired to the Sussex Downs to take up beekeeping ("The Second Stain") and wrote a book on the subject entitled "Practical Handbook of Bee Culture, with Some Observations upon the Segregation of the Queen".  His search for relaxation can also be seen in his love for music, notably in "The Red-Headed League", wherein Holmes takes an evening off from a case to listen to Pablo de Sarasate play violin.[citation needed]
He also enjoys vocal music, particularly Wagner ("The Adventure of the Red Circle").
The film Young Sherlock Holmes (1985), which speculates about Holmes's youthful adventures, shows Holmes as a brilliant secondary school student, being mentored simultaneously by an eccentric professor/inventor and his dedicated fencing instructor.