Manejo de bases de datos con Python from Coursera

Este curso te permitirá conocer qué son las bases de datos relacionales y aprender a trabajar con ellas. El lenguaje SQL que es utilizado en las bases de datos relacionales para trabajar en la definición de los datos y en la manipulación de los mismos será uno de los temas que abordarás.

Luego, emprenderás el trabajo con base de datos y cómo hacerlo desde Python. En primer lugar utilizando la librería sqlite3, que forma parte de la biblioteca estándar de Python. Esta librería se conecta directamente a la base de datos y puede ejecutar consultas con SQL desde Python. En segundo lugar, utilizarás la librería SQLAlchemy para poder tener un mapeo los modelos de nuestro sistema con la base de datos. Esta librería proporciona un mecanismo para realizar este mapeo de forma automática. De esta manera no hace falta estar escribiendo consultas SQL y hacer todo el mapeo manualmente.

Una vez que completes este curso, podrás diseñar y construir sistemas que persistan los datos de su sistema en una base de datos relacional.

What's inside

Syllabus

Introducción a las bases de datos relacionales

¡Bienvenidos al primer módulo del curso! En este módulo abordaremos los siguientes contenidos: veremos qué son las bases de datos relacionales. Describiremos sus fundamentos y sus componentes, entre ellos detallaremos las relaciones, los registros y las columnas y se explicará qué es y para qué sirve una clave primaria y una clave foránea. Luego veremos que es la integridad de datos y detallaremos los diversos tipos de restricciones de integridad que implementa una base de datos relacional. Por último veremos qué son y para qué sirven los índices en las bases de datos relacionales. Además describiremos cómo utilizar el motor de base de datos SQLite con el programa SQLite Browser, el cual utilizaremos durante el curso para hacer diversas pruebas.

Lenguaje SQL

Avanzamos al módulo 2 de contenido. En esta semana aprenderemos el lenguaje de consultas SQL (del inglés, Structured Query Language). Primero veremos como crear, modificar y borrar tablas de la base de datos utilizando este lenguaje, para luego detallar cómo se realizan consultas de los datos y cómo se insertan, actualizan y borran registros de una tabla en la base de datos. Por último veremos cómo realizar consultas sobre tablas que están relacionadas.

Manejo de bases de datos en Python

Llegamos al módulo 3 del curso. En esta semana trabajaremos con la librería sqlite3 que forma parte de la biblioteca estándar de Python. Se detalla qué son y para qué sirven las conexiones y los cursores de base de datos. Se explicará qué es una transacción y cómo las utiliza la librería. Luego trabajaremos insertando, actualizando, borrando y consultando objetos de la base de datos. Por último veremos qué son y para qué sirven las migraciones o cambios de esquema.

Mapeo Objeto Relacional

Llegamos al último Módulo del curso. Felicitaciones por haber llegado hasta aquí. En esta semana aprenderemos que es el Mapeo Objeto Relacional (del inglés, ORM) y trabajaremos con la librería SQLAlchemy que implementa un ORM para Python. Se explicarán las bases de SQLAlchemy y se realizará la creación de modelos mapeados. Luego se guardarán objetos nuevos o modificaciones a uno existente y se borrarán objetos de la base de datos. Además veremos cómo se realizan las consultas en SQLAlchemy utilizando el objeto Query. Por último veremos cómo relacionar dos modelos, con relaciones uno a muchos, muchos a uno, uno a uno y muchos a muchos.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Dirigido a personas sin conocimientos previos en Bases de Datos Relacionales y con nociones básicas de Python

Introduce conceptos fundamentales de las bases de datos relacionales, como tablas, registros, columnas, claves primarias y claves foráneas

Enseña a utilizar el lenguaje SQL para crear, modificar y consultar datos en bases de datos relacionales

Explica cómo trabajar con bases de datos en Python utilizando la biblioteca sqlite3 y SQLAlchemy

Cubre el concepto de Mapeo Objeto Relacional (ORM) y su implementación en Python mediante SQLAlchemy

Reviews summary

Python database management

This course covers the basics of relational databases and SQL, how to use Python to work with databases, and how to use the SQLAlchemy library for object-relational mapping. While the content was praised for being well-explained, some issues were mentioned such as an incomplete final project description and lack of hands-on exercises in Jupyter.

Clear demonstrations of how to use Python to interact with databases

"Muy buen curso, para empezar en base de datos con Python con SQLite.Saludos ;)"

"Excelente curso para aquellos que ya tengan fundamentos de Python, objetos y bases de datos."

Comprehensive explanation and utilization of SQLAlchemy for object-relational mapping

"Muy bueno, pero la explicación debe ser un poco más detallada"

Structured, well-rounded content covering basic database concepts and Python integration

"Muy interesante el curso. "

"Excelente curso para introducirnos a como funcionan las bases de datos y como usar Python para acceder a las funciones de estas"

Limited hands-on exercises and lack of Jupyter-based labs

"Sería bueno que tuviera laboratorios virtuales en Jupyter por ejemplo"

Incomplete description and lack of guidance for the final project

"El proyecto final no tiene nada que ver con lo visto en el curso"

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 Manejo de bases de datos con Python with these activities:

Explora el tutorial de SQLite

Show steps

Revisa el tutorial de SQLite para familiarizarte con los conceptos básicos de las bases de datos relacionales.

Browse courses on SQLite

Show steps

Visita el sitio web oficial de SQLite
Sigue el tutorial para principiantes

Show all one activities

Career center

Learners who complete Manejo de bases de datos con Python will develop knowledge and skills that may be useful to these careers:

Database Administrator

Database Administrators work managing and maintaining databases, ensuring their security and performance. They work closely with developers and users to ensure that the database meets the needs of the organization. This course helps build a foundation for this career by providing an understanding of relational databases, SQL, and Python for database management.

See salaries and explore the career path for Database Administrator

Data Analyst

Data Analysts collect, clean, and analyze data to help businesses make informed decisions. They use a variety of tools and techniques to extract insights from data, including SQL and Python. This course provides a solid foundation for a career as a Data Analyst by teaching the fundamentals of relational databases and SQL, as well as how to use Python for data analysis.

See salaries and explore the career path for Data Analyst

Data Scientist

Data Scientists use their knowledge of statistics, machine learning, and data analysis to solve complex business problems. They work with large datasets to identify trends and patterns, and they build models to predict future outcomes. This course provides a foundation for a career as a Data Scientist by teaching the fundamentals of relational databases, SQL, and Python for data analysis.

See salaries and explore the career path for Data Scientist

Data Engineer

Data Engineers design, build, and maintain the infrastructure that stores and processes data. They work with a variety of tools and technologies, including databases, data warehouses, and big data platforms. This course provides a foundation for a career as a Data Engineer by teaching the fundamentals of relational databases, SQL, and Python for data management.

See salaries and explore the career path for Data Engineer

Software Engineer

Software Engineers design, develop, and maintain software applications. They work with a variety of programming languages and technologies, and they must have a strong understanding of data structures and algorithms. This course may be useful for Software Engineers who want to learn more about relational databases and SQL for data management.

See salaries and explore the career path for Software Engineer

Web Developer

Web Developers design and develop websites and web applications. They work with a variety of programming languages and technologies, and they must have a strong understanding of data structures and algorithms. This course may be useful for Web Developers who want to learn more about relational databases and SQL for data management.

See salaries and explore the career path for Web Developer

Business Analyst

Business Analysts gather and analyze data to help businesses make informed decisions. They work with a variety of stakeholders, including executives, managers, and customers. This course may be useful for Business Analysts who want to learn more about relational databases and SQL for data analysis.

See salaries and explore the career path for Business Analyst

Product Manager

Product Managers are responsible for the development and launch of new products. They work with a variety of stakeholders, including engineers, designers, and marketers. This course may be useful for Product Managers who want to learn more about relational databases and SQL for data management.

See salaries and explore the career path for Product Manager

Project Manager

Project Managers are responsible for planning, executing, and completing projects. They work with a variety of stakeholders, including clients, team members, and vendors. This course may be useful for Project Managers who want to learn more about relational databases and SQL for data management.

See salaries and explore the career path for Project Manager

Marketing Manager

Marketing Managers are responsible for developing and executing marketing campaigns. They work with a variety of stakeholders, including customers, sales teams, and marketing agencies. This course may be useful for Marketing Managers who want to learn more about relational databases and SQL for data analysis.

See salaries and explore the career path for Marketing Manager

Sales Manager

Sales Managers are responsible for leading and motivating sales teams. They work with a variety of stakeholders, including customers, sales representatives, and marketing teams. This course may be useful for Sales Managers who want to learn more about relational databases and SQL for data analysis.

See salaries and explore the career path for Sales Manager

Customer Success Manager

Customer Success Managers are responsible for ensuring that customers are satisfied with their products or services. They work with a variety of stakeholders, including customers, sales teams, and product teams. This course may be useful for Customer Success Managers who want to learn more about relational databases and SQL for data analysis.

See salaries and explore the career path for Customer Success Manager

Operations Manager

Operations Managers are responsible for the day-to-day operations of a business. They work with a variety of stakeholders, including employees, customers, and vendors. This course may be useful for Operations Managers who want to learn more about relational databases and SQL for data management.

See salaries and explore the career path for Operations Manager

Human Resources Manager

Human Resources Managers are responsible for managing the human resources of a business. They work with a variety of stakeholders, including employees, managers, and executives. This course may be useful for Human Resources Managers who want to learn more about relational databases and SQL for data management.

See salaries and explore the career path for Human Resources Manager

Financial Analyst

Financial Analysts analyze financial data to make investment recommendations. They work with a variety of stakeholders, including clients, portfolio managers, and research analysts. This course may be useful for Financial Analysts who want to learn more about relational databases and SQL for data analysis.

See salaries and explore the career path for Financial Analyst