March 2025
Intermediate to advanced
654 pages
16h 24m
Spanish
Content preview from Aprender PHP, MySQL y JavaScript, 7.ª edición
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 9. Dominar MySQL
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
El Capítulo 8 te ha proporcionado una buena base en la práctica del uso de bases de datos relacionales con el Lenguaje de Consulta Estructurado. Has aprendido a crear bases de datos y las tablas que las componen, así como a insertar, consultar, modificar y eliminar datos.
A continuación, tenemos que ver cómo diseñar bases de datos para conseguir la máxima velocidad y eficacia. Por ejemplo, ¿cómo decides qué datos colocar en cada tabla? A lo largo de los años, se han desarrollado una serie de directrices que -si las sigues- garantizan que tus bases de datos serán eficientes y capaces de crecer a medida que las alimentes con más y más datos.
Diseño de bases de datos
Es muy importante que diseñes correctamente una base de datos antes de empezar a crearla; de lo contrario, es casi seguro que tendrás que volver atrás y modificarla dividiendo algunas tablas, fusionando otras y moviendo varias columnas para conseguir relaciones sensatas que MySQL pueda utilizar fácilmente.
Sentarse con una hoja de papel y un lápiz (o un equivalente digital) y escribir una selección de las consultas que crees que tú y tus usuarios probablemente haréis es un excelente punto de partida. En el caso de la base de datos de una librería online, algunas de tus preguntas podrían ser:
-
¿Cuántos autores, libros y clientes hay en la base de datos?
-
¿Qué autor escribió ...
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.