Structured Query Language (SQL) is still the de facto database query language widely used in industry and taught in almost all university level database courses. The role of SQL is further strengthened by the emergence of NewSQL systems which use SQL as their query language as well as some NoSQL systems, e.g., Cassandra and DynamoDB, which base…

NoSQL databases have been used in organizations for decades. Few database textbooks on the market, however, have suitable materials about NoSQL beyond general introductions for typical business students. In fact, users of the typical NoSQL systems on the software market need to have certain computer programming skills. This teaching tip introduces…

The purpose of this teaching case is to develop a hands-on exercise on graph processing using a hybrid system. The paper provides a background on graph databases and how graph processing is supported in a hybrid system, SAP HANA. It also details step-by-step instructions on how to create, modify, and process a graph database using SAP HANA. The…

The aim of this paper is to provide sufficient detail that other members of the IS community can incorporate the business game "Flowers for the World" (or FFTW for short) into their IS teaching portfolio. The game promotes experiential (active) learning and has been used to support discussions or project work in such diverse subjects as…

In this paper, we describe how database instructors can teach Relational Algebra and Structured Query Language together through programming. Students write query programs consisting of sequences of Relational Algebra operations vs. Structured Query Language SELECT statements. The query programs can then be run interactively, allowing students to…

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…

Recent advances in genomics and structural biology have resulted in an unprecedented increase in biological data available from Internet-accessible databases. In order to help students effectively use this vast repository of information, undergraduate biology students at Drake University were introduced to bioinformatics software and databases in…

This paper presents a goal-based scenario approach to teaching introductory database concepts to undergraduates using two different scaffolding methods. One method, termed "worked-out examples," attempts to reduce extraneous cognitive load by requiring students to complete increasingly complex missing parts of worked out examples. The other…

This article describes the experience of teaching structural bioinformatics to third year undergraduate students in a subject titled "Biomolecular Structure and Bioinformatics." Students were introduced to computer programming and used this knowledge in a practical application as an alternative to the well established Internet bioinformatics…

This book is designed to provide a quick introduction to LinkWay (one of a new generation of hypermedia programs) for teachers who are familiar with other computer applications, but who may not have worked with hypermedia applications. The book serves as a tutorial that quickly introduces the basic elements of LinkWay, thereby making more…

Collaborations between business and academia provide valuable opportunities for students to connect classroom learning with practical work experience. To effectively reach a significant number of students, one approach is to meld a real-world business project and classroom assignment into a realistic business scenario that can be addressed by…

This case provides a real-world semester long project-oriented case study for students enrolled in an electronic commerce course that has a significant development component. The case provides the technical framework in the form of functional requirements for students to design and build a fully functional transaction processing e-commerce Web…

This book demonstrates, for teachers at all levels, applications of technology tools for the effective learning and teaching of mathematical skills and concepts as suggested by the National Council of Teachers of Mathematics (NCTM). It focuses on the use of general-purpose computer tools in the mathematics classroom, with an emphasis on problem…

This publication contains 25 subjects appropriate for use in a competency list for the occupation of computer programmer/analyst, 1 of 12 occupations within the business/computer technologies cluster. Each unit consists of a number of competencies; a list of competency builders is provided for each competency. Titles of the 25 units are as…

"Selected Styles in Web-Based Educational Research" is concerned with the most common research styles in Web-based teaching or learning. It is intended for practitioners, educators and students, who wish to learn how to conduct research in online teaching and learning, and helps define style in educational research methodology. To…