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
In questa pagina del sito puoi guardare il video online Import Data into SQL Tables: INSERT INTO, COPY FROM (SQL tutorial for beginners in data science EP7) della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Data36 - Online Data Science Courses 16 febbraio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 5,565 volte e gli è piaciuto 60 spettatori. Buona visione!
