Teaching Advanced SQL Skills: Text Bulk Loading.

Studies show that advanced database skills are important for student to be prepared for the today’s highly competitive job market. A common task for database administrators is to insert large amount of data into a database. This paper illustrates how an up-todate, 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.