Teaching Advanced SQL Skills: Text Bulk Loading

Authors

David Olsen, Utah State University
Karina Hauser, Utah State University

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.

Recommended Citation

Olsen, David and Hauser, Karina (2007) "Teaching Advanced SQL Skills: Text Bulk Loading," Journal of Information Systems Education: Vol. 18 : Iss. 4 , 399-402.
Available at: https://aisel.aisnet.org/jise/vol18/iss4/2