VF中SQL复杂查询的四步教学法研究  

A Four-step Teaching Method Research on Complex SQL Queries in VF

作　　者：贾丽萍[1] 

机构地区：[1]山西师范大学临汾学院,山西临汾041000

出　　处：《重庆三峡学院学报》2014年第3期125-127,共3页Journal of Chongqing Three Gorges University

摘　　要：查询是SQL的核心,而复杂查询是学生学习的难点.根据多年教学经验,从查询涉及的字段、字段来自哪些表、表之间的关联、查询条件分析四个方面阐述了SQL复杂查询的四步教学法.该教学方法不仅对简单查询进行复习巩固,而且为后续表单查询打下坚实的基础.Query is the core of SQL, and complex query, the difficult point in learning for students. Based on years of teaching experience, this paper elaborates the four-step teaching method： fields involved in query, tables in which the fields come from, relations among the tables, and query condition analysis. This teaching method can both consolidate simple query, and lays a solid foundation for the follow-up form query.

关 键 词：SQL 多表联接查询 嵌套查询 

分 类 号：G642[文化科学—高等教育学]