Skip to main content
HomePython

Introduction to Databases in Python

4.3+
14 reviews
Intermediate

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

Start Course for Free
4 hours20 videos66 exercises97,111 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies


Course Description

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.
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Basics of Relational Databases

    Free

    In this chapter, you’ll get acquainted with the fundamentals of relational databases and the relational model for database management. You will learn how to connect to a database and interact with it by writing basic SQL queries, both in raw SQL as well as SQLAlchemy, which provides a Pythonic way of interacting with databases.

    Play Chapter Now
    Introduction to Databases
    50 xp
    Relational model
    50 xp
    Connecting to your database
    50 xp
    Engines and connection strings
    100 xp
    Autoloading Tables from a database
    100 xp
    Viewing Table details
    100 xp
    Introduction to SQL queries
    50 xp
    Selecting data from a Table: raw SQL
    100 xp
    Selecting data from a Table with SQLAlchemy
    100 xp
    Handling a ResultSet
    100 xp
    Congratulations!
    50 xp
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

datasets

Census (CSV)Census (SQLite)Employees (SQLite)

collaborators

Collaborator's avatar
Hugo Bowne-Anderson

prerequisites

Intermediate Python
Jason Myers HeadshotJason Myers

Co-Author of Essential SQLAlchemy and Software Engineer

Jason Myers is a software engineer and author. His area of expertise is in developing data analytics platforms. He has also written the Essential SQLAlchemy book, co-authored with Rick Copeland, that introduces you to working with relational databases in Python.
See More

Don’t just take our word for it

*4.3
from 14 reviews
50%
36%
14%
0%
0%
  • Yam C.
    2 months

    It's honestly fantastic. SQLAlchemy has a really intimidating documentation because there's 10-15 ways to get one thing done. Thise course managed to keep the CRUD and fundamentals into a linear outline. I only wish there were more pieces to this series but it seems like a one-off course T^T

  • Juan G.
    about 1 year

    Excelente curso

  • Amit K.
    over 1 year

    Topic covered well in brief with end to end implementation

  • Consuelo S.
    over 1 year

    Good work with the videos and exercises. Clear and straight to the point.

  • Attilio Z.
    almost 2 years

    Excelent course

"It's honestly fantastic. SQLAlchemy has a really intimidating documentation because there's 10-15 ways to get one thing done. Thise course managed to keep the CRUD and fundamentals into a linear outline. I only wish there were more pieces to this series but it seems like a one-off course T^T"

Yam C.

"Excelente curso"

Juan G.

"Topic covered well in brief with end to end implementation"

Amit K.

Join over 15 million learners and start Introduction to Databases in Python today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.