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.