Journal of Information Systems Education (JISE)

Volume 18

Volume 18 Number 4, Pages 399-402

Winter 2007

Teaching Tip
Teaching Advanced SQL Skills: Text Bulk Loading

David Olsen
Karina Hauser

Utah State University
Logan, UT 84322, USA

Abstract: Studies show that advanced database skills are important for students to be prepared for today's highly competitive job market. A common task for database administrators is to insert large amounts of data into a database. This paper illustrates how an up-to-date advanced database topic, namely bulk insert, can be incorporated into a database class. It gives detailed examples on how to import different file types and discusses associated issues.

Keywords: SQL, Bulk insert, Database systems

Download this article: JISE - Volume 18 Number 4, Page 399.pdf

Recommended Citation: Olsen, D. & Hauser, K. (2007). Teaching Tip: Teaching Advanced SQL Skills: Text Bulk Loading. Journal of Information Systems Education, 18(4), 399-402.