The Proceedings of the Information Systems Education Conference 2005: §3374 Home Papers/Indices prev (§3373) Next (§3400)

Sat, Oct 8, 11:30 - 11:55, House B Paper (refereed)

Recommended Citation: Wu, P Y, J M Baugh, and V J Harvey. Teaching SQL in Database Management for Adult Continuing Education. In The Proceedings of the Information Systems Education Conference 2005, v 22 (Columbus OH): §3374. ISSN: 1542-7382.

Teaching SQL in Database Management for Adult Continuing Education

Refereed

9 pages

Peter Y. Wu    [a1] [a2]
Department of Computer and Information Systems
Robert Morris University    [u1] [u2]
Moon Township, Pennsylvania, USA    [c1] [c2]

Jeanne M. Baugh    [a1] [a2]
Department of Computer and Information Systems
Robert Morris University    [u1] [u2]
Moon Township, Pennsylvania, USA    [c1] [c2]

Valerie J. Harvey    [a1] [a2]
Department of Computer and Information Systems
Robert Morris University    [u1] [u2]
Moon Township, Pennsylvania, USA    [c1] [c2]

We present a detailed plan to teach SQL for adult continuing education as part of an undergraduate course in Database Management. The course offers 3 credit hours and covers a syllabus fulfilling the requirements of a first database course in the IS 2002 Model Curriculum. It runs for only eight weeks to cater to the study plans of adult students. The teaching plan covers SQL and an introduction to the relational data model for the first three weeks. While these 8-weeks courses are very popular because they significantly reduce the time to complete the course, and thus the respective degree programs, we are concerned about sacrificing content or quality. Our goal is to ensure scope of coverage and quality of delivery in the shortened duration. Our teaching plan comprises 14 modules to cover an introduction to the relational data model and to develop the skills of using SQL. It is complete yet very compact. The small learning modules provide greater flexibility for study schedules, and facilitate more effective on-line use. The critical design factor in each module is the selected SQL features to cover, and the specific learning objectives. The plan then organizes these modules to prepare us for on-line delivery of at least part of the course. We believe our design will engender self-learning, and limit the need of in class lecture time by relying more on the discipline of individual students. The plan appears feasible and practicable for the shortened course duration, while prepares well for on-line delivery.

Keywords: SQL, database management, adult continuing education, on-line delivery

Read this refereed paper in Adobe Portable Document (PDF) format. (9 pages, 406 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (23 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org