2A An Active X Interactive SQL Tutorial David K. Dennis, Otterbein …

Short Description
provides a basic tutorial of SQL, focusing on the SELECT statement. It surveys … contained in the paper’s SQL tutorial of the SELECT statement. …

Website: www.aiseducators.com | Filesize: 12kb

Content
2A An Active X Interactive SQL Tutorial
David K. Dennis, Otterbein College
George H. Bodnar, Duquesne University
SQL is a foundation technology for the study of information systems. This paper
provides a basic tutorial of SQL, focusing on the SELECT statement. It surveys
existing Internet resources for learning SQL. Its main feature is that it provides a
new, free Internet-based Active X control that functions as an interactive SQL
Tutorial. The Active X control can be used to actually process/run the examples
contained in the paper’s SQL tutorial of the SELECT statement. It can also be
used to process any SELECT statements against the included database. The
database contains four tables: orders, order details, inventory, and accounts
receivable (i.e., customers). These tables collectively provide a rich set of data
for active learning of SQL concepts and terminology….