Import Data into SQL Tables: INSERT INTO, COPY FROM (SQL tutorial for beginners in data science EP7)
In this episode, I’ll show you three different SQL data import methods!
ARTICLE VERSION (RECOMMENDED):
https://data36.com/how-to-import-data...
DOWNLOAD THE CSV FILE WITH THIS COMMAND:
wget sendatree.eu/test_results.csv
00:00 Intro
01:13 adding the new data line by line (INSERT INTO)
06:05 Commit your changes!
06:52 emptying an SQL table (TRUNCATE TABLE)
08:17 Importing data from a .csv file (COPY FROM)
14:57 importing the result of another SQL query (INSERT INTO)
19:58 Conclusion
PREVIOUS EPISODES:
SQL TUTORIAL EP#1 video: • SQL TUTORIAL EP#1: BASICS (SELECT, WHERE, ...
The whole SQL tutorial series: • SQL for Data Science and Analytics Tutoria...
LINKS MENTIONED IN THE EPISODE:
SQL cheat sheet: https://data36.com/newsletter
Learn SQL (10+ tutorial articles): https://data36.com/learn-sql-for-data...
7-day SQL online course: https://data36.com/sql-for-aspiring-d...
Learn BASH: https://data36.com/learn-data-analyti...
Article about Importing Data into SQL tables: https://data36.com/how-to-import-data...
SQL server setup video: • How to INSTALL PostgreSQL for learning and...
Newsletter: https://data36.com/newsletter
Free mini-course: https://data36.com/how-to-become-a-da...
--------------------------------------------------------
Check my website: https://data36.com
Get access to more data science tutorials, join the inner circle: https://data36.com/inner-circle
Find me on Twitter: / data36_com
On this page of the site you can watch the video online Import Data into SQL Tables: INSERT INTO, COPY FROM (SQL tutorial for beginners in data science EP7) with a duration of hours minute second in good quality, which was uploaded by the user Data36 - Online Data Science Courses 16 February 2021, share the link with friends and acquaintances, this video has already been watched 5,586 times on youtube and it was liked by 60 viewers. Enjoy your viewing!
