We may earn an affiliate commission when you visit our partners.
Course image
Taught by Meta Staff

En este curso, completará un proyecto final donde deberá crear una base de datos y un cliente para el restaurante Little Lemon.

Para completar este curso, necesitará experiencia en ingeniería de bases de datos.

Read more

En este curso, completará un proyecto final donde deberá crear una base de datos y un cliente para el restaurante Little Lemon.

Para completar este curso, necesitará experiencia en ingeniería de bases de datos.

El proyecto final le permite demostrar múltiples habilidades del Certificado mediante la resolución de un auténtico problema del mundo real. Cada módulo incluye un breve resumen y enlaces a contenidos que ya se han tratado en cursos anteriores de este programa.

En este curso, demostrará su nuevo conjunto de habilidades mediante el diseño y la elaboración de una solución de base de datos, combinando todas las habilidades y tecnologías que aprendió a lo largo de este programa para resolver el problema en cuestión.

Al final de este curso, habrá demostrado su capacidad para realizar lo siguiente:

- Configurar un proyecto de base de datos.

-Agregar informes de ventas.

-Crear un sistema para reservar mesas.

-Trabajar con análisis y visualización de datos.

-Crear un cliente de base de datos.

También demostrará su capacidad con las siguientes herramientas y software:

-Git,

-MySQL Workbench,

-Tableau,

-Python.

Enroll now

What's inside

Syllabus

Información del proyecto
En este módulo, tendrá experiencia práctica en el uso de MySQL. Configure un servidor de instancia MySQL en MySQL Workbench, luego cree un modelo de datos de diagrama ER e impleméntelo en MySQL.
Read more
Consultas, procedimientos y sentencias preparadas de bases de datos
Utilice SQL para crear tablas virtuales, procedimientos almacenados y sentencias preparadas para el restaurante Little Lemon.
Clientes y visualización
Visualice los datos de ventas de un restaurante e implemente un cliente de base de datos en Python.
Evaluación del proyecto
Realice una revisión entre compañeros del proyecto de base de datos de Little Lemon y reflexione sobre lo que aprendió.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Examines database design and implementation relevant to industry operations
Develops skills in database engineering sought by many employers
Taught by Meta Staff, industry leaders in database engineering
Requires prior knowledge of database engineering
Primarily focused on the MySQL database management system

Save this course

Save Proyecto final de ingenieros de bases de datos to your list so you can find it easily later:
Save

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 Proyecto final de ingenieros de bases de datos with these activities:
Repaso de consultas y procedimientos de bases de datos
Revisar consultas y procedimientos de bases de datos ayudará a fortalecer la base necesaria para el curso, especialmente en el módulo sobre consultas, procedimientos y sentencias preparadas.
Browse courses on SQL
Show steps
  • Revisar los conceptos básicos de SQL, como la sintaxis y las cláusulas.
  • Crear tablas y datos de muestra para practicar consultas.
  • Realizar consultas simples y complejas en las tablas de muestra.
  • Crear y ejecutar procedimientos almacenados para automatizar tareas.
  • Utilizar sentencias preparadas para mejorar el rendimiento y la seguridad de las consultas.
Tutoriales guiados sobre visualización de datos
Seguir tutoriales guiados sobre visualización de datos complementará el módulo sobre clientes y visualización, proporcionando una comprensión práctica de las técnicas de visualización y herramientas como Tableau.
Show steps
  • Acceder a los tutoriales guiados sobre visualización de datos proporcionados por Tableau.
  • Crear visualizaciones básicas como gráficos de barras, gráficos circulares y mapas.
  • Aplicar técnicas de visualización avanzadas, como gráficos combinados y paneles.
  • Analizar datos visualmente para identificar patrones y tendencias.
  • Exportar y compartir visualizaciones para su presentación.
Participar en eventos de networking del sector
Asistir a eventos de networking de la industria conectará con profesionales y aprenderá sobre prácticas actuales, complementando el conocimiento adquirido en el curso.
Show steps
  • Identificar y asistir a eventos de networking del sector de bases de datos.
  • Conectar con profesionales de bases de datos, como ingenieros, arquitectos y científicos de datos.
  • Discutir tendencias de la industria, mejores prácticas e innovaciones.
  • Intercambiar ideas y aprender sobre posibles oportunidades de empleo.
  • Mantenerse al día con las últimas noticias y desarrollos en el campo de las bases de datos.
One other activity
Expand to see all activities and additional details
Show all four activities
Contribuir a proyectos de bases de datos de código abierto
Contribuir a proyectos de bases de datos de código abierto proporcionará experiencia práctica en el trabajo con bases de datos del mundo real, lo que complementará el proyecto del curso.
Show steps
  • Identificar proyectos de bases de datos de código abierto que necesiten contribuciones.
  • Revisar el código fuente y la documentación de los proyectos.
  • Realizar cambios en el código, como corregir errores o agregar nuevas funciones.
  • Enviar solicitudes de extracción para que los cambios sean revisados y fusionados.
  • Colaborar con otros contribuyentes para mejorar los proyectos.

Career center

Learners who complete Proyecto final de ingenieros de bases de datos will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts typically build a foundation in statistics and machine learning before moving into their roles. The final project for this Database Engineering course helps you to do just that. It also introduces you to the Python programming language, which is one of the most in-demand languages for Data Analysts who need to develop machine learning algorithms and analyze large volumes of data. This course can help you build marketable skills that can help you in your path to becoming an effective Data Analyst.
Data Visualization Specialist
Data Visualization Specialists are responsible for creating visual representations of data. They use data visualization tools to communicate complex data insights to stakeholders. If you are looking to become a Data Visualization Specialist, this course is an excellent place to start. It includes training on Tableau, one of the most in-demand data visualization tools in the industry.
Business Intelligence Analyst
Business Intelligence Analysts collect and analyze data to help businesses make better decisions. They use data visualization tools to communicate their findings to stakeholders. If your goal is to become a Business Intelligence Analyst, this course will help you lay the groundwork you need. It includes in-depth training on data visualization in Tableau. Tableau is one of the most in-demand skills for Business Intelligence Analysts because it allows them to quickly and easily communicate complex data insights to stakeholders.
Database Administrator
A Database Administrator is responsible for managing and maintaining databases, including troubleshooting and security. They monitor and optimize the performance of databases. If you are looking to become a Database Administrator, this course is an excellent start. It covers all of the essential skills involved in managing and maintaining a database, including using MySQL Workbench, setting up an instance, optimizing performance, and implementing a data model.
Data Scientist
Data Scientists are responsible for analyzing and interpreting data to extract insights that businesses can use to make informed decisions. Data Scientists typically build a foundation in mathematics and statistics, then learn to apply advanced analytics techniques, such as machine learning, to solve problems with data. This course can help you to build a foundation in data analysis and visualization. You will learn to create data visualizations in Tableau and use Python to implement a data client.
Statistician
Statisticians collect, analyze, and interpret data. They use statistical methods to draw conclusions about populations based on samples. This course can help you build a foundation in statistics that can be beneficial in a career as a Statistician. It covers essential statistical concepts and provides hands-on practice with data analysis.
Data Engineer
Data Engineers are typically responsible for architecting and maintaining data management systems. Data Engineers build tools and work with Data Scientists to make data readily accessible for advanced analytics. This course helps build the tools and skills you will need as a Data Engineer. By setting up a database project, creating a system for reserving tables, and working with data visualization, you will be introduced to an essential part of a Data Engineer's job. This course may help you to build the skills you need to be an effective Data Engineer.
Data Architect
Data Architects design and build the data management systems that businesses need to function. To do this, you must have a deep understanding of data modeling, storage, security, and governance. This course gives a thorough overview of all of these subfields. You will also work with several essential data tools to create a database and a client in Python. Taking this course may help you gain the skills you need to become a Data Architect.
Customer Insights Analyst
Customer Insights Analysts collect and analyze data to understand customer behavior. They use this information to help businesses improve their products and services. This course may be helpful to you if you would like to become a Customer Insights Analyst. It includes training on data analysis and data visualization.
Market Research Analyst
Market Research Analysts collect and analyze data to understand market trends and customer behavior. They use this information to help businesses make informed decisions about their products and services. This course may be helpful if you want to become a Market Research Analyst. It provides a solid foundation in data analysis and data visualization.
Systems Analyst
Systems Analysts are responsible for analyzing and designing business systems. They work with users to understand their needs and then develop solutions that meet those needs. If you want to become a Systems Analyst, this course will help you build the skills you need. It includes training on data visualization and data modeling, both of which are important skills for Systems Analysts.
Operations Research Analyst
Operations Research Analysts use mathematical and analytical techniques to solve business problems. They develop models to optimize processes and improve efficiency. This course may be useful if you want to become an Operations Research Analyst. It includes training on data analysis and optimization techniques.
Product Manager
Product Managers are responsible for the development and launch of new products. They work with cross-functional teams to define product requirements, develop roadmaps, and launch products to market. This course may be helpful if you want to become a Product Manager. It provides a solid foundation in data analysis and data visualization. Product Managers must be able to analyze data to make informed decisions about product development.
Software Engineer
Software Engineers are responsible for designing, developing, and maintaining software applications. They use a variety of programming languages and technologies to create software solutions for businesses. This course may be helpful to you if you would like to become a Software Engineer. It includes in-depth training on Python, which is one of the most popular programming languages used by Software Engineers.
Business Analyst
Business Analysts are responsible for analyzing business processes and identifying opportunities for improvement. They work with stakeholders to understand their needs and then develop solutions that meet those needs. This course may be helpful if you wish to become a Business Analyst. It gives a detailed overview of data analysis and data visualization. Business Analysts must be able to analyze data and communicate their findings to stakeholders.

Reading list

We've selected seven 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 Proyecto final de ingenieros de bases de datos.
Este libro cubre el uso de Python para la ciencia de datos, lo que complementa el uso de Python para la creación de clientes de bases de datos en el curso.
Este libro proporciona una guía completa para el uso de Tableau, la herramienta utilizada en el curso para la visualización de datos.
Este libro introduce los conceptos básicos de programación en Python, lo que puede ser beneficioso para los estudiantes que buscan desarrollar sus habilidades en el lenguaje utilizado en el curso.
Este libro sirve como una guía completa para el modelado dimensional, que es un tema estrechamente relacionado con el diseño de bases de datos cubierto en el curso.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Proyecto final de ingenieros de bases de datos.
Ánalisis de Marketing con Power BI: Visualizando Campañas
Most relevant
Proyecto final para desarrolladores de back-end
Most relevant
Informes de ventas con HubSpot
Most relevant
Creación de Tablas de Base de Datos con SQL
Most relevant
Proyecto Final de Analítica de Datos
Most relevant
Habilitación de ventas
Most relevant
Marco web Django
Most relevant
Herramientas para la ciencia de datos
Most relevant
Crea tu primer juego de adivinanza con Python
Most relevant
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 - 2024 OpenCourser