Coursera

Uso de bases de datos con Python (Coursera)

Offered by University of Michigan,
Uso de bases de datos con Python (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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.

What You Will Learn

  • Utilizar las operaciones crear, leer, actualizar y eliminar para administrar bases de datos
  • Explicar los conceptos básicos de Python orientado a objetos
  • Comprender cómo se almacenan los datos en varias tablas de una base de datos
  • Utilizar la API de Google Maps para visualizar datos

Syllabus

WEEK 1
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.

WEEK 2
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.

WEEK 3
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.

WEEK 4
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.

WEEK 5
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.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

An Introduction to Interactive Programming in Python (Part 2) (Coursera) Coursera
Rice University

An Introduction to Interactive Programming in Python (Part 2) (Coursera)

CS: Software Engineering CS: Programming

This two-part course is designed to help students with very little or no computing background learn the basics of building simple interactive applications. Our language of choice, Python, is an easy-to learn, high-level computer language that is used in many of the computational courses offered on Coursera. To make learning Python easy, we have developed a new browser-based programming environment that makes developing interactive applications in Python simple.

Aug 10th 2026
4 Weeks
Game Programming Python
Details
Applied Plotting, Charting & Data Representation in Python (Coursera) Coursera
University of Michigan

Applied Plotting, Charting & Data Representation in Python (Coursera)

Statistics & Data Analysis Data Science

This course will introduce the learner to information visualization basics, with a focus on reporting and charting using the matplotlib library. The course will start with a design and information literacy perspective, touching on what makes a good and bad visualization, and what statistical measures translate into in terms of visualizations. The second week will focus on the technology used to make visualizations in python, matplotlib, and introduce users to best practices when creating basic charts and how to realize design decisions in the framework.

Aug 10th 2026
4 Weeks
Python Data Analysis Data Science
Details
Computer Science: Algorithms, Theory, and Machines (Coursera) Coursera
Princeton University

Computer Science: Algorithms, Theory, and Machines (Coursera)

Computer Science

This course introduces the broader discipline of computer science to people having basic familiarity with Java programming. It covers the second half of our book Computer Science: An Interdisciplinary Approach (the first half is covered in our Coursera course Computer Science: Programming with a Purpose, to be released in the fall of 2018). Our intent is to demystify computation and to build awareness about the substantial intellectual underpinnings and rich history of the field of computer science.

Aug 10th 2026
5-12 Weeks
Programming Computing Algorithms
Details
Python and Statistics for Financial Analysis (Coursera) Coursera
The Hong Kong University of Science and Technology - HKUST

Python and Statistics for Financial Analysis (Coursera)

Economics & Finance Business

Python is now becoming the number 1 programming language for data science. Due to python’s simplicity and high readability, it is gaining its importance in the financial industry. The course combines both python coding and statistical concepts and applies into analyzing financial data, such as stock data.

Aug 10th 2026
4 Weeks
Python Statistics Inference
Details
Programming Fundamentals (Coursera) Coursera
Duke University

Programming Fundamentals (Coursera)

CS: Theory CS: Programming

Programming is an increasingly important skill, whether you aspire to a career in software development, or in other fields. This course is the first in the specialization Introduction to Programming in C, but its lessons extend to any language you might want to learn. This is because programming is fundamentally about figuring out how to solve a class of problems and writing the algorithm, a clear set of steps to solve any problem in its class.

Aug 10th 2026
4 Weeks
Programming Algorithms C Language
Details
Programming Reactive Systems (Scala 2 version) (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Programming Reactive Systems (Scala 2 version) (Coursera)

CS: Software Engineering

Reactive programming is a set of techniques for implementing scalable, resilient and responsive systems as per the Reactive Manifesto. Such systems are based on asynchronous message-passing, and their basic building-blocks are event handlers. This course teaches how to implement reactive systems in Scala and Akka by using high-level abstractions, such as actors, asynchronous computations, and reactive streams.

Aug 10th 2026
5-12 Weeks
Programming Scala Cloud Computing
Details
Algorithmic Thinking (Part 2) (Coursera) Coursera
Rice University

Algorithmic Thinking (Part 2) (Coursera)

CS: Theory

Experienced Computer Scientists analyze and solve computational problems at a level of abstraction that is beyond that of any particular programming language. This two-part class is designed to train students in the mathematical concepts and process of "Algorithmic Thinking", allowing them to build simpler, more efficient solutions to computational problems.

Aug 10th 2026
4 Weeks
Python Computing Algorithms
Details
An Introduction to Interactive Programming in Python (Part 1) (Coursera) Coursera
Rice University

An Introduction to Interactive Programming in Python (Part 1) (Coursera)

CS: Programming

This two-part course is designed to help students with very little or no computing background learn the basics of building simple interactive applications. Our language of choice, Python, is an easy-to learn, high-level computer language that is used in many of the computational courses offered on Coursera. To make learning Python easy, we have developed a new browser-based programming environment that makes developing interactive applications in Python simple.

Aug 10th 2026
5-12 Weeks
Programming Python Interactive Applications
Details
Functional Program Design in Scala (Scala 2 version) (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Functional Program Design in Scala (Scala 2 version) (Coursera)

CS: Software Engineering

In this course you will learn how to apply the functional programming style in the design of larger Scala applications. You'll get to know important new functional programming concepts, from lazy evaluation to structuring your libraries using monads. We'll work on larger and more involved examples, from state space exploration to random testing to discrete circuit simulators. You’ll also learn some best practices on how to write good Scala code in the real world. Finally, you will learn how to leverage the ability of the compiler to infer values from types.

Aug 10th 2026
5-12 Weeks
Programming Scala Program Design
Details