Hey, thank you so much for your beautiful presentation, I'm doing the same Project from Google Data Analytics, I've already done this in Excel and now I wanna do it in SQL. I have a question, can you import those scv files not one by one but all of them at once, maybe through coding like BULK INSERT and if it is possible to choose specific columns from scv during BULK INSERT. I think Importing file like you did it's ok but imagine if there more than 10 or 20 scv files that would be annoying importing them one by one.
mind to know how you create a portfolio? using website or github? i want to show my work portfolio but I am still clueless about how recruit will see my portfolio. i am using this cycling bike data to practice using excel, SQL, python but I plan to choose other data for my portfolio to apply job.
I used the load infile function to write a script that loads all 12 months. It can be one script which is much faster than using the wizard. Just a long script
Hey, thank you so much for your beautiful presentation, I'm doing the same Project from Google Data Analytics, I've already done this in Excel and now I wanna do it in SQL. I have a question, can you import those scv files not one by one but all of them at once, maybe through coding like BULK INSERT and if it is possible to choose specific columns from scv during BULK INSERT. I think Importing file like you did it's ok but imagine if there more than 10 or 20 scv files that would be annoying importing them one by one.
mind to know how you create a portfolio? using website or github? i want to show my work portfolio but I am still clueless about how recruit will see my portfolio. i am using this cycling bike data to practice using excel, SQL, python but I plan to choose other data for my portfolio to apply job.
we can add all data at once?
I used the load infile function to write a script that loads all 12 months. It can be one script which is much faster than using the wizard. Just a long script
how can i do this in R studio?