This dissertation presents novel advancements in the field of continuous nonlinear optimization, focusing on the development of efficient second-order methods for second-order conic programs (SOCPs) and continuous nonlinear two-stage optimization problems. The primary focus is on the theory and computations of Sequential Quadratic Programming (SQP) methods, which are widely used...