Taking the course of Database Application Technology as an example, this paper describes the effect of optimizing the overall teaching effect and improving the students' practical ability with hierarchical grouping and cooperative teaching mode in the background of the integration of "teaching, learning and doing" in higher vocational education.