摘要
SQL分组查询是SQL数据查询语句的一个教学难点。首先分析了学生在学习分组查询时存在的主要问题,然后结合实际教学经验,提出了一种通过对分组查询实例的执行过程进行分析来学习分组查询的教学方法,初步实践表明可以有效提高SQL分组查询的教学效果。
Group query statement of SQL in Database Course Teaching is both difficult and important.This paper first analyzes the main problems when students studying the group query statement,and then,in combination with the teaching experience,proposes a new didac tics based on analyzing the executing processes of group query examples.The tentative practice has proves that the new didactics can im prove teaching effectively.
出处
《电脑知识与技术》
2012年第8X期5752-5754,共3页
Computer Knowledge and Technology
关键词
分组查询
教学法
聚集函数
笛卡尔积
视图
group query
didactics
aggregation function
cartesian product
SQL view