OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Course image
Coursera logo

Estructuras y gestión de bases de datos con MySQL

Taught by Meta Staff

Desarrollar un conocimiento práctico del sistema de gestión de bases de datos MySQL (DBMS). Adquirir conocimientos de SGBD, como creación, consulta y manipulación de datos. Adquirirá más experiencia con sentencias SQL, cláusulas y tipos de datos.

Al final de este curso, usted será capaz de:

- Utilizar el SGBD MySQL para construir y modificar bases de datos relacionales con SQL

- Agregar registros a una base de datos MySQL

- Realizar consultas intrincadas sobre registros de bases de datos con filtros y agrupaciones

Read more

Desarrollar un conocimiento práctico del sistema de gestión de bases de datos MySQL (DBMS). Adquirir conocimientos de SGBD, como creación, consulta y manipulación de datos. Adquirirá más experiencia con sentencias SQL, cláusulas y tipos de datos.

Al final de este curso, usted será capaz de:

- Utilizar el SGBD MySQL para construir y modificar bases de datos relacionales con SQL

- Agregar registros a una base de datos MySQL

- Realizar consultas intrincadas sobre registros de bases de datos con filtros y agrupaciones

- Crear uniones y uniones simples dentro de una base de datos

- Crear relaciones entre tablas utilizando claves primarias y externas

- Demostrar la capacidad de completar un proyecto de normalización de bases de datos

Obtendrá experiencia con las siguientes herramientas y software:

- MySQL DBMS

- Uniones y uniones

- Sentencias SQL, cláusulas y tipos de datos

- Claves primarias y externas

- Normalización de bases de datos

Enroll now

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until March 12, 2027
Save 40% Off 3 Months
Access thousands of top-rated learning programs with a Coursera Plus monthly subscription and take 40% off 3 months for a limited time.
Take
40%
off
Get offer

What's inside

Syllabus

Introducción a MySQL
En este módulo, aprenderá a utilizar MySQL DBMS para construir, modificar y consultar bases de datos relacionales con SQL.
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Los alumnos que son nuevos en las bases de datos relacionales se beneficiarán sobre manera de este curso introductorio
Aquellos que buscan desarrollar sus habilidades en MySQL y SQL encontrarán este curso valioso
Los profesionales de la industria de datos, como analistas y científicos de datos, pueden utilizar este curso para mejorar sus conocimientos sobre MySQL

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Fundamentos sólidos de mysql

Según los estudiantes, este curso ofrece una base sólida y práctica para trabajar con bases de datos MySQL. Destacan las explicaciones claras sobre SQL, la creación y manipulación de datos, así como la importancia de los ejercicios prácticos. Es ideal para quienes buscan una introducción completa a la gestión de datos, incluyendo sentencias SQL, uniones y la normalización de bases de datos. Algunos mencionan que, si bien es exhaustivo para los fundamentos, podría ser una introducción desafiante sin experiencia previa.
La instalación de MySQL es un paso inicial crucial.
"La necesidad de instalar MySQL DBMS en mi máquina fue el primer paso, y aunque se explica, es algo a considerar."
"Aprecio que el curso se enfoque en herramientas de uso real como MySQL Workbench."
"Si no estás familiarizado con instalaciones de software, podría requerir un poco de paciencia al principio."
Ofrece una base exhaustiva en SQL y bases de datos.
"Adquirí un conocimiento sólido sobre la creación, consulta y manipulación de datos con MySQL."
"Me ayudó a entender las sentencias SQL, las cláusulas y los tipos de datos desde cero."
"La sección sobre claves primarias y foráneas, y uniones, fue muy clara y necesaria."
Cubre la gestión de MySQL con actividades prácticas.
"Este curso me proporcionó las herramientas para empezar a trabajar con MySQL inmediatamente."
"Los ejercicios prácticos fueron clave para consolidar mi comprensión de SQL y la gestión de datos."
"Pude aplicar lo aprendido en el proyecto de normalización, lo cual fue muy útil."
Puede ser intensivo para principiantes sin experiencia previa.
"Aunque el contenido es bueno, el ritmo puede ser un poco rápido si no tienes ninguna base en programación o bases de datos."
"Recomiendo tener una comprensión básica de conceptos de programación antes de iniciar, para aprovecharlo al máximo."
"Como novato, tuve que pausar y repasar varias veces para asimilar los conceptos más complejos."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Estructuras y gestión de bases de datos con MySQL with these activities:
Revisar conceptos básicos de SQL
Refresca tus conocimientos sobre los conceptos básicos de SQL antes de comenzar el curso para garantizar una base sólida.
Show steps
  • Repasa los tipos de datos y operadores.
  • Practica escribiendo consultas simples para recuperar y manipular datos.
Recordar conceptos de algebra relacional
Refresca tus conocimientos sobre conceptos de álgebra relacional para comprender mejor las operaciones de base de datos.
Show steps
  • Revisa los conceptos básicos de conjuntos y relaciones.
  • Practica operaciones de álgebra relacional, como proyección, selección y unión.
Organizar notas de clase y materiales del curso
Mejora tu retención y comprensión organizando y revisando regularmente tus notas de clase y otros materiales del curso.
Show steps
  • Recopila y organiza tus notas de clase, diapositivas de presentación y materiales de lectura.
  • Crea un sistema para categorizar y almacenar los materiales.
  • Revisa tus notas y materiales periódicamente para reforzar tu aprendizaje.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Resolver consultas SQL
Mejora tus habilidades de consulta SQL resolviendo una colección de problemas desafiantes.
Show steps
  • Revisa los conceptos básicos de SQL.
  • Practica escribiendo consultas para recuperar datos de tablas.
  • Aprende a utilizar cláusulas avanzadas, como JOIN y GROUP BY.
  • Resuelve problemas de consulta de nivel principiante a intermedio.
  • Participa en concursos o desafíos de codificación para poner a prueba tus habilidades.
Formar un grupo de estudio
Mejora tu comprensión y retención discutiendo conceptos, resolviendo problemas y apoyándote mutuamente en un grupo de estudio.
Show steps
  • Encuentra a otros estudiantes interesados en formar un grupo de estudio.
  • Establece un horario y lugar regulares para reunirse.
  • Revisa los materiales del curso juntos, discute conceptos y resuelve problemas.
  • Apoyarse mutuamente y hacerse responsables.
Crear un diagrama de base de datos
Refuerza tu comprensión de las relaciones entre las tablas creando un diagrama de base de datos para un escenario de la vida real.
Show steps
  • Identifica las entidades y sus atributos.
  • Determina las relaciones entre las entidades.
  • Crea un diagrama de entidad-relación.
  • Convierte el diagrama de entidad-relación a un diagrama de base de datos.
Explorar características avanzadas de MySQL
Amplía tus conocimientos sobre MySQL explorando sus características avanzadas, como vistas, procedimientos almacenados y funciones.
Show steps
  • Revisa la documentación oficial de MySQL sobre características avanzadas.
  • Sigue tutoriales en línea o videos sobre el uso de estas características.
  • Implementa estas características en tus proyectos de práctica.
  • Participa en foros o comunidades en línea para obtener ayuda y orientación.
Desarrollar un sistema de gestión de inventario
Aplica tus habilidades de MySQL construyendo un sistema de gestión de inventario funcional que te permita almacenar, rastrear y administrar elementos.
Show steps
  • Define los requisitos y el alcance del proyecto.
  • Diseña el esquema de la base de datos.
  • Implementa la base de datos y la interfaz de usuario.
  • Prueba y depura el sistema.
  • Documenta tu proyecto.

Career center

Learners who complete Estructuras y gestión de bases de datos con MySQL will develop knowledge and skills that may be useful to these careers:
Database Administrator
Database Administrators ensure that all data is processed, stored, and retrieved efficiently. They also manage cloud-based data, and as a result, must have a working knowledge of cloud computing. This course can help you prepare to excel in this role because it offers guidance in managing databases, including how to update and insert data, and how to create databases using MySQL DBMS. Furthermore, this course provides instruction on performing SQL queries, joins, and unions - operations regularly performed by Database Administrators.
See salaries and explore the career path for Database Administrator
Database Designer
Database Designers create and maintain the structure of databases. They design and implement database schemas to meet the needs of their organization. This course can help you on your journey to becoming a Database Designer. The course offers instruction on building and modifying databases using the MySQL DBMS. In addition, this course provides guidance on normalizing databases, a key concept in database design.
See salaries and explore the career path for Database Designer
Data Architect
Data Architects are responsible for designing and managing an organization's data architecture to ensure that it meets the business needs. They translate business requirements into technical specifications. This course can help you become a Data Architect because it provides instruction on creating and modifying databases using the MySQL DBMS. Additionally, the course provides guidance on normalizing databases, which is a core concept of data architecture.
See salaries and explore the career path for Data Architect
Data Analyst
Data Analysts study data to determine its impact on business. You will need to identify the right data to answer questions and, subsequently, present the information in a way that supports decision-making. This course can help you build a foundation in using the MySQL DBMS to complete tasks necessary for this role. For instance, a Data Analyst is required to perform complex queries using SQL to manage and manipulate data, and this course offers instruction in conducting intricate queries. In addition, a Data Analyst should be able to build relational databases. This course can help you with that as well.
See salaries and explore the career path for Data Analyst
Business Analyst
Business Analysts identify business needs by researching and understanding how businesses operate. They use the knowledge they gain to recommend ways to improve operational efficiency. This course can help you become a Business Analyst by teaching you the basics of using SQL. Business Analysts must be able to translate business requirements into technical specifications, and knowledge of SQL is a valuable tool for doing this.
See salaries and explore the career path for Business Analyst
Data Engineer
Data Engineers design and build data pipelines to ensure that data is processed effectively and efficiently. They must be able to create complex data models and manage data quality. This course may be useful to you if you want to become a Data Engineer because it provides a solid foundation in using the MySQL DBMS, including performing queries and analyzing data.
See salaries and explore the career path for Data Engineer
Computer Systems Analyst
Computer Systems Analysts study existing computer systems and procedures, and design enhancements for them. They must be able to understand business processes to design efficient systems. This course can be useful if you wish to pursue this career path because it offers instruction on using the MySQL DBMS. Understanding databases can be helpful when making recommendations for improving a business's computer systems or procedures.
See salaries and explore the career path for Computer Systems Analyst
Software Engineer
Software Engineers apply the principles of computer science and software design. They are responsible for the full lifecycle of software development. This course can help you on this career path because it provides a basis in building and modifying databases, which is a key component of some software development projects. The course further teaches the concepts of joins and unions, which could be useful to you if you are working on a project where data integration is required.
See salaries and explore the career path for Software Engineer
Data Scientist
Data Scientists use complex and advanced algorithms and machine learning techniques to solve business problems. They translate data into actionable plans for businesses. This course may aid you in your journey to becoming a Data Scientist because it provides a foundation in accessing and managing data. Furthermore, this course may be useful to you because it offers instruction on normalizing databases, which can play a role in preparing data for advanced analytical techniques.
See salaries and explore the career path for Data Scientist
Information Systems Manager
Information Systems Managers plan, implement, and manage an organization's information systems. They must be able to understand business processes to design efficient systems. This course may be useful as you pursue a career as an Information Systems Manager because it offers guidance on using the MySQL DBMS to build databases. Understanding databases can be helpful when managing information systems.
See salaries and explore the career path for Information Systems Manager
Project Manager
Project Managers coordinate teams and manage projects to ensure they are completed on time, within budget, and to the specifications of stakeholders. This course may be useful if your career goal is to become a Project Manager because it offers guidance on creating and maintaining databases, a common task for project management.
See salaries and explore the career path for Project Manager
Systems Engineer
Systems Engineers design, develop, and maintain computer systems and networks. They must be able to understand business processes to design efficient systems. This course may be useful as you pursue a career as a Systems Engineer because it offers guidance on using the MySQL DBMS to build databases. Understanding databases can be helpful when making recommendations for improving a business's computer systems or networks.
See salaries and explore the career path for Systems Engineer
Technical Writer
Technical Writers create user guides, instruction manuals, and other documentation to explain technical concepts. They must be able to translate complex information into easily understandable language. This course may be useful if you wish to pursue this career path because it offers instruction on performing SQL queries and creating joins and unions. This knowledge may help you to understand the technical details of products or services that you will be writing about.
See salaries and explore the career path for Technical Writer
Web Developer
Web Developers are responsible for the creation and maintenance of websites. They translate designs into code and create interfaces for client-side and server-side applications. This course can help you if you wish to pursue this career path because it offers a foundation in using the MySQL DBMS to store and retrieve data. This is a useful skill to have if you are working on a project where data must be stored on a website or in a web application.
See salaries and explore the career path for Web Developer
Information Security Analyst
Information Security Analysts protect an organization's computer networks and systems. They use ethical hacking techniques to find vulnerabilities before malicious actors can exploit them. This course may be useful as you pursue a career as an Information Security Analyst. The course teaches the basics of using MySQL DBMS to build databases, which is useful for managing security logs. Additionally, the course provides instruction on SQL queries, which may help you audit logs or identify potential security risks.
See salaries and explore the career path for Information Security Analyst

Reading list

We've selected eight books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Estructuras y gestión de bases de datos con MySQL.
Cover image
MySQL 5.0 Certification Study Guide
Save
Provides a comprehensive overview of MySQL, covering basic to advanced topics, including database design, SQL queries, and performance tuning. It's a useful resource for both beginners and experienced MySQL users.
(English) Mysql 5 Certification Study Guide
Paperback
$$
Cover image
Head First PHP & MySQL
Save
Is an excellent introduction to SQL, covering the basics of data manipulation, retrieval, and management. Its interactive approach makes it a great choice for beginners.
(English) Head First PHP & MySQL: A Brain-Friendly Guide
Paperback
$$
(中文) Head First PHP & MySQL (Chinese Edition)(Chinese...
Paperback
$$$
(English) Head First PHP & MySQL: A Brain-Friendly Guide
Kindle Edition
$$
Cover image
Practical SQL, 2nd Edition
Save
Provides a collection of practical recipes for solving common SQL problems. It's a valuable resource for MySQL users who need to quickly find solutions to specific tasks.
(English) Practical SQL, 2nd Edition: A Beginner's Guide to...
Paperback
$$
(English) Practical SQL, 2nd Edition: A Beginner's Guide to...
Kindle Edition
$$
Cover image
MySQL Cookbook
Save
Provides a comprehensive guide to MySQL administration, covering topics such as installation, configuration, backup, and recovery. It's an essential resource for anyone responsible for managing MySQL databases.
(English) MySQL Cookbook: Solutions for Database Developers...
Paperback
$$
(English) MySQL Cookbook
Paperback
$$$
(English) My SQL Cookbook: Solutions and Examples for MySQL...
Paperback
$$$$
Cover image
High Performance MySQL
Save
Provides in-depth coverage of MySQL performance optimization techniques. It's a valuable resource for anyone who wants to improve the performance of their MySQL databases.
(English) High Performance MySQL: Optimization, Backups, and...
Paperback
$$
(English) High Performance MySQL: Optimization, Backups,...
Paperback
$$
(中文) High Performance MySQL ( 3rd Edition ) (MySQL...
Paperback
$$
Cover image
SQL Antipatterns, Volume 1
Save
Identifies and explains common SQL antipatterns, which are bad practices that can lead to performance problems or security vulnerabilities. It's a valuable resource for anyone who wants to write high-quality SQL code.
(English) SQL Antipatterns, Volume 1: Avoiding the Pitfalls...
Paperback
$$
(English) SQL Antipatterns, Volume 1
Kindle Edition
$$
Cover image
Database Systems: The Complete Book
Save
Provides a comprehensive overview of database systems, covering topics such as database design, query processing, and transaction management. It's a valuable resource for anyone who wants to understand the fundamentals of databases.
(English) Database Systems: The Complete Book
Kindle Edition
$$$
(English) Database Systems The Complete Book
Paperback
$$
(English) Database Systems: The Complete Book
Hardcover
$$$$
(English) Goal Student Access Code Card for Database Systems:...
Printed Access Code
$$
Cover image
Database Dreaming Volume I
Save
Provides a comprehensive overview of database systems, covering topics such as database design, query processing, and transaction management. It's a valuable resource for anyone who wants to understand the fundamentals of databases.
(English) Database Dreaming Volume I: Relational Writings...
Paperback
$$
(English) Database Dreaming Volume I: Relational Writings...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Estructuras y gestión de bases de datos con MySQL.
Migrating MySQL User Data When Running Database Migration...
Most relevant
Cloud Spanner - Defining Schemas and Understanding Query...
Most relevant
Introduction to SQL for BigQuery and Cloud SQL
Most relevant
Understanding Basic SQL Syntax
Most relevant
Fundamentals of Database Systems
Most relevant
The Structured Query Language (SQL)
Most relevant
Visualizing Data with Google Data Studio
Most relevant
Optimize Your Database with Indexes
Most relevant
The Web and Databases in Android
Most relevant

Coursera Buyer Protection & Guarantee

Verified partner policies & purchase protections

Accredited University Partner
Free Trial & Audit

7-Day Free Trial & Free Audit

7-day free trial on monthly Coursera Plus subscriptions; free audit option available on most individual courses to explore video lectures and readings at no charge.

Return & Refund Policy

14-Day Refund Guarantee

14-day refund window on annual Coursera Plus subscriptions and single-course purchases prior to certificate issuance. Monthly subscriptions do not offer refunds once billed.

Buyer Protections

Verified Academic & Industry Partner

Accredited university and industry certifications (e.g. Stanford, Google, IBM, Yale), secure SSL payment processing, and verifiable digital certificate links.

Key Purchase Protections
14-day refund window on annual Coursera Plus and single courses
7-day free trial on monthly Coursera Plus subscriptions
Free course audit option for lectures and readings
Verified certificates from top universities & companies
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Effort
4 semanas de estudio, de 3 a 5 horas/semana.
Level
Introductory
Via
Coursera
Institution
Meta
Instructor
Taught by Meta Staff
Language
Español
Transcript
English
This course belongs to a collection called Ingeniero en base de datos de Meta. It's comprised of seven courses:
  1. Modelado de datos avanzado
  2. Programar en Python
  3. Estructuras y gestión de bases de datos con MySQL (viewing)
  4. Introducción a las bases de datos
  5. Clientes de base de datos
  6. Proyecto final de ingenieros de bases de datos
  7. Temas avanzados de MySQL
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Los alumnos que son nuevos en las bases de datos relacionales se beneficiarán sobre manera de este curso introductorio
Aquellos que buscan desarrollar sus habilidades en MySQL y SQL encontrarán este curso valioso
Los profesionales de la industria de datos, como analistas y científicos de datos, pueden utilizar este curso para mejorar sus conocimientos sobre MySQL
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to Estructuras y gestión de bases de datos con MySQL.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser