Database system principles and applications "is an important basic course for computer majors in vocational colleges, with strong theoretical and practical significance. To meet the requirements of professional training, the article analyzes the positioning and teaching content of the course "principles and applications of database systems". By combining the CDIO-OBE concept with course practice, not only can students proficiently master the basic knowledge points related to databases, but also avoid the boring psychology of students caused by dry teaching methods. Through project decomposition, team collaboration, online discussions, and micro classes, the theoretical and practical teaching links have been closely combined, improving the current experimental teaching system, and promoting the improvement of the experimental teaching level of this course.