How to create sql script manually to insert data ?

Question

How to create the sql script manually to insert data into database with foriegn keys where the script takes data from excel file and insert them into database at one attempt

 

 Can i get any similar example?

 

Where can i get the tutorial to create the sql scripts?