Lets consider an example (here I use Stata, but the logic works the same in any other package):
. sysuse nlsw88, clear
(NLSW, 1988 extract)
. reg wage c.tenure##c.tenure grade i.race
Source | SS df MS Number of obs = 2,229
-------------+---------------------------------- F(5, 2223) = 66.51
Model | 9640.89034 5 1928.17807 Prob > F = 0.0000
Residual | 64447.0774 2,223 28.991038 R-squared = 0.1301
-------------+---------------------------------- Adj R-squared = 0.1282
Total | 74087.9678 2,228 33.2531274 Root MSE = 5.3843
------------------------------------------------------------------------------
wage | Coef. Std. Err. t P>|t| [95% Conf. Interval]
-------------+----------------------------------------------------------------
tenure | .2773182 .0677307 4.09 0.000 .1444962 .4101402
|
c.tenure#|
c.tenure | -.0070752 .0036278 -1.95 0.051 -.0141894 .0000389
|
grade | .6792721 .0461853 14.71 0.000 .5887013 .7698429
|
race |
black | -.7517506 .2649033 -2.84 0.005 -1.271234 -.2322669
other | .6315991 1.06455 0.59 0.553 -1.456017 2.719215
|
_cons | -2.106807 .6357411 -3.31 0.001 -3.353516 -.8600988
------------------------------------------------------------------------------
Adding the quadratic term tenure$^2$ (c.tenure#c.tenure) to the model means that the effect of tenure changes when you get more tenure. When you have 0 years of tenure, the slope is such that your hourly wage would increase by 28 cents for an additional year of tenure if the slope would remain unchanged, which it doesn't. (Hourly wage is in dollars, so a .28 dollar change is a 28 cents change.) Each additional year of tenure reduces the slope by .7 cents. In this case the coefficient of the square term is negative, so the relationship is concave. It usually helps to see this relationship as a graph:
. qui margins, at(grade=12 race=1 tenure=(0/26))
. marginsplot
Variables that uniquely identify margins: tenure

Initially you get a higher wage as you get more tenure, but the gain decreases and even becomes negative after say 20 years of tenure. We can be more precise about when this occurs:
. nlcom -_b[tenure]/(2*_b[c.tenure#c.tenure])
_nl_1: -_b[tenure]/(2*_b[c.tenure#c.tenure])
------------------------------------------------------------------------------
wage | Coef. Std. Err. z P>|z| [95% Conf. Interval]
-------------+----------------------------------------------------------------
_nl_1 | 19.59777 5.692054 3.44 0.001 8.441549 30.75399
------------------------------------------------------------------------------
notice the huge confidence interval, this is quite typical, so be careful about interpreting the position of the maximum.