Self-consolidating concrete, in simple terms, is a concrete mix that does not need to be mechanically vibrated. It is common in drilled shafts where mechanical vibration methods are impractical because of the depths.
The mix will typically use smaller aggregates and admixtures (water reducers/plasticizers) as the higher viscosity allows the mix to have better flow characteristics which subsequently will not leave voids. Segregation of the mix, where the aggregate particles "separate" from the cement paste, is the biggest concern to be avoided: We don't want all the aggregate dropping to the bottom of the pour during placement whereby the cement paste is displaced to the top, we want the entire matrix to remain in-tact.
Hope this helps - Cheers!!!