In view of deficiencies in experimental materials and methods in traditional teaching of basic database courses, this paper discusses the extension of experimental materials and teaching methods of database courses that are capable of developing innovative skills. Extension of experimental materials involves two main aspects: extension of database query optimization technology and extension of underlying index structure query; major teaching methods include stratified experimental teaching, group discussion and flipped classroom. Teaching practices demonstrate that the students’database knowledge, professional and innovative skills are improved to a greater degree by extension of experimental materials and methods.