March 2025
Intermediate to advanced
308 pages
7h 6m
Spanish
Content preview from DuckDB: en funcionamiento
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.
Capítulo 3. Introducción a SQL
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
En el Capítulo 2, aprendiste a importar varias fuentes de datos (CSV, Parquet, Excel y bases de datos) a DuckDB mediante el lenguaje de programación Python. Con ese conocimiento, el siguiente paso en el que debes trabajar es manipular los datos cargados en DuckDB utilizando SQL. Al fin y al cabo, utilizar SQL en DuckDB es una de las principales características de DuckDB. Por eso, en este capítulo nos centraremos en el uso de SQL en DuckDB. En concreto, este capítulo se centrará en dos áreas:
Utilizar la CLI (interfaz de línea de comandos) de DuckDB para trabajar con bases de datos DuckDB sin necesidad de utilizar un lenguaje de programación como Python.
Utilizar SQL con bases de datos DuckDB. En lugar de proporcionar una exploración exhaustiva de SQL, nos centraremos en el aprendizaje a través de ejemplos prácticos.
Con esto, ¡entremos de lleno!
Uso de la CLI de DuckDB
La CLI de DuckDB es una herramienta que permite a los usuarios interactuar con DuckDB directamente desde la línea de comandos. En el Capítulo 2, viste cómo interactuar con DuckDB utilizando Python. Sin embargo, hay ocasiones en las que simplemente quieres trabajar con las bases de datos directamente, como cuando creas nuevas tablas, importas datos de distintas fuentes de datos y realizas tareas relacionadas con las bases de datos. En esos casos, es mucho más eficiente ...
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.