March 2025
Intermediate to advanced
308 pages
7h 21m
French
Content preview from DuckDB : opérationnel
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.
Chapitre 3. Une introduction à SQL
Cet ouvrage a été traduit à l'aide de l'IA. Tes réactions et tes commentaires sont les bienvenus : translation-feedback@oreilly.com
Au chapitre 2, tu as appris à importer diverses sources de données (CSV, Parquet, Excel et bases de données) dans DuckDB grâce au langage de programmation Python. Avec ces connaissances, la prochaine étape sur laquelle tu vas travailler est la manipulation des données chargées dans DuckDB à l'aide de SQL. Après tout, l'utilisation de SQL dans DuckDB est l'une des principales caractéristiques de DuckDB. Dans ce chapitre, nous nous concentrerons donc sur l'utilisation de SQL dans DuckDB. Plus précisément, ce chapitre se concentrera sur deux domaines :
Utilisation de l'interface de ligne de commande (CLI) de DuckDB pour travailler avec les bases de données de DuckDB sans avoir besoin d'utiliser un langage de programmation tel que Python.
Utiliser SQL avec les bases de données DuckDB. Plutôt que de proposer une exploration exhaustive de SQL, nous mettrons l'accent sur l'apprentissage à l'aide d'exemples pratiques.
Sur ce, plongeons dans le vif du sujet !
Utilisation de l'interface de programmation de DuckDB
Le CLI DuckDB est un outil qui permet aux utilisateurs d'interagir avec DuckDB directement à partir de la ligne de commande. Au chapitre 2, tu as vu comment interagir avec DuckDB à l'aide de Python. Cependant, il arrive que tu veuilles simplement travailler directement avec les bases de données, par exemple pour ...
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.