March 2025
Intermediate to advanced
308 pages
7h 2m
Italian
Content preview from DuckDB: installazione e avvio
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Capitolo 3. Primi passi su SQL
Questo lavoro è stato tradotto utilizzando l'AI. Siamo lieti di ricevere il tuo feedback e i tuoi commenti: translation-feedback@oreilly.com
Nel Capitolo 2 hai imparato come importare diverse fonti di dati (CSV, Parquet, Excel e database) in DuckDB attraverso il linguaggio di programmazione Python. Con queste conoscenze, il prossimo passo da fare è manipolare i dati caricati in DuckDB utilizzando SQL. Dopotutto, l'utilizzo di SQL in DuckDB è una delle caratteristiche principali di DuckDB. Per questo motivo, in questo capitolo ci concentreremo sull'utilizzo di SQL in DuckDB. In particolare, questo capitolo si concentrerà su due aree:
Utilizzo della DuckDB CLI (interfaccia a riga di comando) per lavorare con i database DuckDB senza dover utilizzare un linguaggio di programmazione come Python.
Utilizzare SQL con i database DuckDB. Piuttosto che fornire un'esplorazione esaustiva di SQL, ci concentreremo sull'apprendimento attraverso esempi pratici.
Con questo, tuffiamoci subito nel vivo!
Usare la CLI di DuckDB
La DuckDB CLI è uno strumento che permette agli utenti di interagire con DuckDB direttamente dalla linea di comando. Nel Capitolo 2 hai visto come interagire con DuckDB utilizzando Python. Tuttavia, ci sono casi in cui vuoi semplicemente lavorare con i database direttamente, ad esempio quando crei nuove tabelle, importi dati da diverse fonti ed esegui operazioni relative ai database. In questi casi, è molto più efficiente utilizzare direttamente ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.