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
Nesta página do site você pode assistir ao vídeo on-line Import Data into SQL Tables: INSERT INTO, COPY FROM (SQL tutorial for beginners in data science EP7) duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Data36 - Online Data Science Courses 16 Fevereiro 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 5,586 vezes e gostou 60 espectadores. Boa visualização!
