We may earn an affiliate commission when you visit our partners.

Uso de bases de datos con Python

Este curso presentará a los estudiantes los conceptos básicos del lenguaje de consulta estructurado (Structured Query Language, SQL), así como el diseño básico de bases de datos para almacenar datos como parte de una iniciativa de varios pasos para recopilar, analizar y procesar datos. El curso utilizará SQLite3 como base de datos. También crearemos rastreadores web y procesos de visualización y recopilación de datos de varios pasos. Utilizaremos la biblioteca D3.js para realizar la visualización básica de datos. Este curso abarcará los capítulos de 14 y 15 del libro “Python para todos”. Para que le vaya bien en este curso, debe estar familiarizado con el material cubierto en los capítulos 1 a 13 del libro de texto y los primeros tres cursos de esta especialización. Este curso abarca Python 3.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

Syllabus

Python orientado a objetos

Para comenzar esta clase, cubrimos los aspectos básicos de Python orientado a objetos. No escribiremos nuestros propios objetos, pero dado que muchas de las cosas que usamos, como BeautifulSoup, cadenas, diccionarios y conexiones a bases de datos, utilizan patrones orientados a objetos (Object Oriented, OO) al menos comprenderemos algo de sus patrones y terminología.

Lenguaje de consulta estructurado básico

Aprenderemos las cuatro operaciones principales CRUD (Create, Read, Update, Delete [crear, leer, actualizar y eliminar]) para administrar los datos almacenados en una base de datos.

Modelos de datos y SQL relacional

En esta sección, aprenderemos cómo se almacenan los datos en varias tablas de una base de datos y cómo se vinculan las filas (es decir, estableceremos relaciones) en la base de datos.

Relaciones de varios a varios en SQL

En esta sección exploramos cómo modelar situaciones tales como estudiantes que se inscriben en cursos en los que cada curso tiene varios estudiantes y cada estudiante está inscrito en varios cursos.

Bases de datos y visualización

En esta sección, reunimos todo, recuperamos y procesamos algunos datos y luego usamos la API de Google Maps para visualizar nuestros datos.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Enseña los conceptos fundamentales de Lenguaje de Consulta Estructurado (SQL) y diseño básico de bases de datos

Emplea SQLite3 como base de datos, un motor muy conocido en la industria

Amplía el conocimiento sobre la creación de rastreadores web, la visualización de datos en varios pasos, y los procesos de recopilación de datos

Utiliza la biblioteca D3.js para realizar visualizaciones básicas de datos

Cubre los capítulos 14 y 15 del libro “Python para Todos”, consolidando conocimientos previos

Requiere familiaridad con los capítulos 1 a 13 del libro de texto y los primeros tres cursos de la especialización

Emplea Python 3, una versión muy utilizada en la actualidad

Save this course

Save Uso de bases de datos con Python to your list so you can find it easily later:

Save

Reviews summary

Python database course

This course introduces the basics of Structured Query Language (SQL) and basic database design for storing data.

Clear and straight to the point

"Straight to the point and very clear!"

Grading issues using external tools

"Este curso es muy interesante y muy bueno para practicar. Sin embargo, a la hora de calificar usan herramientas externas engorrosas que no permiten el aprobado de las tareas."

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

Introducción a la consulta de bases de datos

Show steps

Refresca tus conocimientos sobre los conceptos básicos de bases de datos y lenguaje de consulta estructurado (SQL) para preparar una base sólida para el curso.

Browse courses on SQL

Show steps

Repasar los conceptos básicos de las bases de datos, como tablas, filas y columnas.
Revisar los operadores y funciones básicas de SQL, como SELECT, WHERE y ORDER BY.

Review Python basics

Show steps

Understand the concepts of Python programming to prepare for the course

Browse courses on Python Basics

Show steps

Re-read chapters 1-13 of the Python for Everybody textbook
Complete the practice exercises in chapters 1-13

Ejercicios de consulta de bases de datos

Show steps

Fortalece tu comprensión de SQL mediante la realización de ejercicios prácticos de consulta de bases de datos.

Browse courses on SQL

Show steps

Resolver ejercicios de consulta de bases de datos que cubran las operaciones CRUD básicas (crear, leer, actualizar, eliminar).
Practicar consultas más complejas que involucren múltiples tablas y relaciones.

Six other activities

Expand to see all activities and additional details

Show all nine activities

Learn SQLite3 basics

Show steps

Practice using SQLite3, the database used in the course

Browse courses on sqlite3

Show steps

Follow the SQLite tutorial on the official website
Create a simple database and table using SQLite3
Query the database using basic SQL commands

Solve SQL coding challenges

Show steps

Strengthen SQL coding skills and prepare for course assignments

Show steps

Find SQL coding challenges online
Solve the challenges using SQL
Review the solutions to understand best practices

Join a study group

Show steps

Enhance understanding through discussions and peer support

Browse courses on Collaborative Learning

Show steps

Find or create a study group with classmates
Meet regularly to discuss course material
Work together on assignments and projects

Diseñar un modelo de base de datos

Show steps

Aplica tus habilidades de SQL para diseñar un modelo de base de datos para un escenario del mundo real, consolidando tu comprensión de las relaciones y la estructura de datos.

Browse courses on SQL

Show steps

Identificar los requisitos para el modelo de base de datos en función de un escenario dado.
Diseñar el esquema de la base de datos, incluidas las tablas, columnas y relaciones.
Crear un diagrama de entidad-relación para visualizar el modelo.

Build a data visualization dashboard

Show steps

Apply course concepts to create a practical data visualization

Browse courses on D3.js

Show steps

Gather data from a reliable source
Clean and prepare the data
Use D3.js to create the visualization
Deploy the dashboard online

Proyecto: Visualización de datos

Show steps

Integra tus conocimientos de SQL y visualización de datos creando un proyecto que visualice datos de una base de datos utilizando la biblioteca D3.js.

Show steps

Elegir un conjunto de datos de una base de datos y recuperar los datos utilizando SQL.
Procesar y limpiar los datos para prepararlos para la visualización.
Usar D3.js para crear visualizaciones de datos interactivas, como gráficos y mapas.

Career center

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

Data Engineer

Data Engineers build, maintain and manage data pipelines and warehouses. Data pipelines carry data from one system or format to another, usually in a structured or semi-structured form. Consequently, knowing how to interact with databases is a fundamental skill for a Data Engineer to have.

See salaries and explore the career path for Data Engineer

Database Administrator

Database Administrators help administer, manage and maintain an organization's database systems and information. Since this course covers administrating databases, especially through the SQLite3 database and SQLAlchemy, it will be a valuable foundation for any aspiring Database Administrator.

See salaries and explore the career path for Database Administrator

Data Scientist

Data Scientists leverage programming, algorithms and statistics in order to extract knowledge and insights from data. The techniques used to achieve this include data cleansing, preparation and analysis, as well as data visualization and communication - all of which this course can build a foundation towards.

See salaries and explore the career path for Data Scientist

Web Developer

Web Developers design, create and implement websites. Many websites require a database in order to maintain their users and or the data they provide to the site. Consequently, many Web Developers must be able to interact with a database in some way, making this course a valuable add-on.

See salaries and explore the career path for Web Developer

Software Engineer

Software Engineers design, develop and maintain software applications. Many applications require the ability to store and manage data, so having a strong understanding of databases is a strong soft skill for a Software Engineer to have.

See salaries and explore the career path for Software Engineer

Data Analyst

Data Analysts help collect, analyze and interpret data in order to derive meaningful insights from it. As an Analyst, you may analyze data to identify trends and predict future outcomes. This course provides a great primer into working with data, a skill required by most if not all Data Analysts.

See salaries and explore the career path for Data Analyst

Systems Analyst

Systems Analysts study a company or organization's needs in order to improve their efficiency. These Analysts often need to work with data in order to analyze bottlenecks or areas for growth, making database skills a valuable addition to their toolbox.

See salaries and explore the career path for Systems Analyst

Information Security Analyst

Information Security Analysts help protect an organization's digital infrastructure from unauthorized access or manipulation. Since databases contain valuable data assets of an organization, it is helpful for Information Security Analysts to have at least a fundamental understanding of databases, and how to protect them.

See salaries and explore the career path for Information Security Analyst

Business Analyst

Business Analysts study an organization or business domain in order to understand its requirements. Business also rely on data in order to make forecasts and decisions; this course introduces the foundational skills for working with data, which will be helpful to Business Analysts.

See salaries and explore the career path for Business Analyst

IT Architect

IT Architects design the computer and telecommunications networks used by an organization. This course introduces the fundamental concepts of databases and shows how to interact with them from Python, a skillset most IT Architects have or intend to gain.

See salaries and explore the career path for IT Architect

Quality Assurance Tester

Quality Assurance Testers ensure that software products meet the requirements and quality standards of an organization. QA Testers often write scripts or use manual testing to test out an application's functionality; many of these automated tests require interacting with a database in some way.

See salaries and explore the career path for Quality Assurance Tester

Technical Writer

Technical Writers create and edit instruction manuals and training materials for software products. Many technical manuals must cover databases in some way or another, making this course a valuable first step towards a career as a Technical Writer.

See salaries and explore the career path for Technical Writer

User Experience Researcher

User Experience Researchers study how users interact with a product in order to improve the user experience. UX Researchers will often need to analyze qualitative data in order to derive insights from it. This course can help introduce the foundational skills for analyzing data.

See salaries and explore the career path for User Experience Researcher

Product Manager

Product Managers oversee the development of a product from concept to launch. Many Product Managers need to have at least a basic understanding of how data can influence the success of a product, making this course a valuable first step towards getting into product management.

See salaries and explore the career path for Product Manager

Network Administrator

Network Administrators maintain and manage an organization's computer networks and related devices. While this course does not go into managing and administering databases themselves, it does help provide a foundational understanding of how databases work, which is helpful for any Network Administrator to have.

See salaries and explore the career path for Network Administrator

Reading list

We've selected 13 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 Uso de bases de datos con Python.

Python Para Todos

Save

Este libro abarca los capítulos de 14 y 15 del libro “Python para todos”, que es el libro de texto requerido para este curso. Proporciona una base sólida en los conceptos básicos de Python, que son esenciales para comprender el contenido de este curso.

Uso de bases de datos con Python

What's inside

Syllabus

Good to know

Save this course

Reviews summary

Python database course

Activities

Career center

Reading list

Share

Similar courses