One of the most important uses of the curves tool is to make fine adjustment in brightness.
The picture shown below is of moss growing on the trunk of a tree. As you can see, the greener parts of the picture with moss are under-exposed, while rest of the bark has been exposed properly (to learn more about getting the proper exposure, check out this article). Now, to selectively increase the brightness of the moss without affecting rest of the image, we need to change lower part of the graph in the curves tool, which denotes darker tones.

click to enlarge
To do this, click on the center of the graph. Photoshop places a dot on this point, called a control point. The control point can be dragged up or down to lighten or darken the tones near control point. When there are multiple control points in a graph, any changes made to the graph will be restricted till the neighbouring contol point. We will use the control point in the center to restrict our changes to darker tones.
Now click somewhere between the center and bottom of the graph. This creates a new control point. Drag this point upwards slowly to see shadow areas getting lighter. Move the control point left and right and adjust it until you get the best tones. You can also move the control point by entering Input and Output values at the bottom of the graph.
Note that while you can change the bottom portion freely, changes above the center control point is very minimal, ensuring that there is little change in highlights. Shown below is the adjusted graph and the resulting image. Compare this with original image.

click to enlarge

click to enlarge