“结构教学法”在SQL查询语句教学中的应用

Application of Structure Teaching Method in SQL Teaching

数据库的原理和应用一直以来都是高校计算机专业课程中的重要组成部分,SQL语句是数据库原理课程教学的重难点。经过笔者多年的教学实践,采用结构教学法改进SQL查询语句的教学方式后,获得了较好的教学效果。本文详细叙述了结构教学法在SQL查询语句教学中的应用方式,比较了在SQL查询语句教学中应用结构化教学法不同阶段的教学效果,结论表明,在SQL查询语句中正确使用“结构教学法”可以增强学生对它功能及用法的理解。

The principle and application of database has always been an important part of computer courses in colleges and universities. SQL is an important and difficult point in the teaching of Database Principle Course. The structured analysis method is used to create a representation system of cognitive development for each layer of clauses and compares the teaching effects of structured teaching method in different stages of SQL query statement teaching. The conclusion shows that the correct use of structured teaching method in SQL query statement can enhance students’ understanding of its function and usage.