Saltar al contenido principal

Curso

Introduction to Databases in Python

IntermedioNivel de habilidad

Actualizado 5/2025

In this course, you'll learn the basics of relational databases and how to interact with them.

Comienza El Curso Gratis

Incluido conPremium or Teams

PythonData Manipulation4 horas20 vídeos66 Ejercicios5,550 XP98,315Certificado de logros

Crea Tu Cuenta Gratuita

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.

¿Entrenar a 2 o más personas?

Probar DataCamp for Business

Preferido por estudiantes en miles de empresas

Descripción del curso

In this course, you'll learn the basics of using SQL with Python. This will be useful because databases are ubiquitous and data scientists, analysts, and engineers must interact with them constantly. The Python SQL toolkit SQLAlchemy provides an accessible and intuitive way to query, build, and write to essential databases, including SQLite, MySQL, and PostgreSQL.

Prerrequisitos

Intermediate Python

1

Basics of Relational Databases

Iniciar Capítulo

Introduction to Databases

Relational model

Connecting to your database

Engines and connection strings

Autoloading Tables from a database

Viewing Table details

Introduction to SQL queries

Selecting data from a Table: raw SQL

Selecting data from a Table with SQLAlchemy

Handling a ResultSet

Congratulations!

2

Applying Filtering, Ordering and Grouping to Queries

Iniciar Capítulo

Filtering and targeting data

Connecting to a PostgreSQL database

Filter data selected from a Table - Simple

Filter data selected from a Table - Expressions

Filter data selected from a Table - Advanced

Ordering query results

Ordering by a single column

Ordering in descending order by a single column

Ordering by multiple columns

Counting, summing, and grouping data

Counting distinct data

Count of records by state

Determining the population sum by state

SQLAlchemy and pandas for visualization

ResultsSets and pandas DataFrames

From SQLAlchemy results to a plot

3

Advanced SQLAlchemy Queries

Iniciar Capítulo

Calculating values in a query

Connecting to a MySQL database

Calculating a difference between two columns

Determining the overall percentage of women

SQL relationships

Automatic joins with an established relationship

More practice with joins

Working with hierarchical tables

Using alias to handle same table joined queries

Leveraging functions and group_bys with hierarchical data

Handling large ResultSets

Working on blocks of records

4

Creating and Manipulating your own Databases

Iniciar Capítulo

Creating databases and tables

Creating tables with SQLAlchemy

Constraints and data defaults

Inserting data into a table

Inserting a single row

Inserting multiple records at once

Loading a CSV into a table

Updating data in a table

Updating individual records

Updating multiple records

Correlated updates

Deleting data from a database

Deleting all the records from a table

Deleting specific records

Deleting a table completely

5

Putting it all together

Iniciar Capítulo

Census case study

Setup the engine and metadata

Create the table to the database

Populating the database

Reading the data from the CSV

Load data from a list into the Table

Querying the database

Determine the average age by population

Determine the percentage of population by gender and state

Determine the difference by state from the 2000 and 2008 censuses

Congratulations!

Introduction to Databases in Python

Curso
Completo

Obtener certificado de logros

Añade esta credencial a tu perfil, currículum vitae o CV de LinkedIn
Compártelo en las redes sociales y en tu evaluación de desempeño

Incluido conPremium or Teams

Inscríbete Ahora

Únete a más 17 millones de estudiantes y empezar Introduction to Databases in Python hoy

Crea Tu Cuenta Gratuita

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.