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.
Olsen, David and Hauser, Karina
"Teaching Advanced SQL Skills: Text Bulk Loading,"
Journal of Information Systems Education: Vol. 18
Available at: https://aisel.aisnet.org/jise/vol18/iss4/2
When commenting on articles, please be friendly, welcoming, respectful and abide by the AIS eLibrary Discussion Thread Code of Conduct posted here.