NotesFAQContact Us
Collection
Advanced
Search Tips
Showing all 6 results Save | Export
Errors and Complications in SQL Query Formulation
Peer reviewed Peer reviewed
Direct linkDirect link
Taipalus, Toni; Siponen, Mikko; Vartiainen, Tero – ACM Transactions on Computing Education, 2018
SQL is taught in almost all university level database courses, yet SQL has received relatively little attention in educational research. In this study, we present a database management system independent categorization of SQL query errors that students make in an introductory database course. We base the categorization on previous literature,…
Descriptors: Programming Languages, Database Management Systems, Database Design, College Students
An Experimental Investigation of Complexity in Database Query Formulation Tasks
Peer reviewed Peer reviewed
Direct linkDirect link
Casterella, Gretchen Irwin; Vijayasarathy, Leo – Journal of Information Systems Education, 2013
Information Technology professionals and other knowledge workers rely on their ability to extract data from organizational databases to respond to business questions and support decision making. Structured query language (SQL) is the standard programming language for querying data in relational databases, and SQL skills are in high demand and are…
Descriptors: Databases, Programming Languages, Difficulty Level, Ambiguity (Context)
Teaching Tip: Active Learning via a Sample Database: The Case of Microsoft's Adventure Works
Peer reviewed Peer reviewed
Direct linkDirect link
Mitri, Michel – Journal of Information Systems Education, 2015
This paper describes the use and benefits of Microsoft's Adventure Works (AW) database to teach advanced database skills in a hands-on, realistic environment. Database management and querying skills are a key element of a robust information systems curriculum, and active learning is an important way to develop these skills. To facilitate active…
Descriptors: Active Learning, Databases, Computer Software, Educational Benefits
Introduce XBRL to Business Students
Peer reviewed Peer reviewed
PDF on ERIC Download full text
Corkern, Sheree M.; Morgan, Mark I. – American Journal of Business Education, 2012
This paper informs business instructors and educators about XBRL (Extensible Business Reporting Language) so that they can introduce it to their students and expand their students' understanding of how it relates to the accounting profession. Even though the financial community has entered a new age with this standardized reporting language, many…
Descriptors: Business Administration Education, Introductory Courses, Accounting, Programming Languages
The Development of Educational Environment Suited to the Japan-Specific Educational Service Using Requirements Engineering Techniques: Case Study of Running Sakai with PostgreSQL
Peer reviewed Peer reviewed
Direct linkDirect link
Terawaki, Yuki; Takahashi, Yuichi; Kodama, Yasushi; Yana, Kazuo – International Journal of Distance Education Technologies, 2011
This paper describes an integration of different Relational Database Management System (RDBMS) of two Course Management Systems (CMS) called Sakai and the Common Factory for Inspiration and Value in Education (CFIVE). First, when the service of CMS is provided campus-wide, the problems of user support, CMS operation and customization of CMS are…
Descriptors: Foreign Countries, Educational Environment, Educational Practices, Case Studies
A Realistic Data Warehouse Project: An Integration of Microsoft Access[R] and Microsoft Excel[R] Advanced Features and Skills
Peer reviewed Peer reviewed
Direct linkDirect link
King, Michael A. – Journal of Information Technology Education, 2009
Business intelligence derived from data warehousing and data mining has become one of the most strategic management tools today, providing organizations with long-term competitive advantages. Business school curriculums and popular database textbooks cover data warehousing, but the examples and problem sets typically are small and unrealistic. The…
Descriptors: Strategic Planning, Problem Sets, Corporations, Statistics