Proyecto final de ingenieros de bases de datos from Coursera

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.

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.

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

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

Show steps

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

Show steps

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

Show steps

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

Show steps

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.

See salaries and explore the career path for 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.

See salaries and explore the career path for Data Visualization Specialist

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.

See salaries and explore the career path for Business Intelligence Analyst

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.

See salaries and explore the career path for Database Administrator

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.

See salaries and explore the career path for Data Scientist

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.

See salaries and explore the career path for Statistician

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.

See salaries and explore the career path for 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.

See salaries and explore the career path for 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.

See salaries and explore the career path for Customer Insights Analyst

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.

See salaries and explore the career path for Market Research Analyst

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.

See salaries and explore the career path for Systems Analyst

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.

See salaries and explore the career path for Operations Research Analyst

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.

See salaries and explore the career path for Product Manager

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.

See salaries and explore the career path for Software Engineer

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.

See salaries and explore the career path for Business Analyst

Proyecto final de ingenieros de bases de datos

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses