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

DataCamp

Introduction to Databases in Python

via DataCamp

Overview

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

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.

Syllabus

Basics of Relational Databases
-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.

Applying Filtering, Ordering and Grouping to Queries
-In this chapter, you will build on your database knowledge by writing more nuanced queries that allow you to filter, order, and count your data—all within the Pythonic framework provided by SQLAlchemy.

Advanced SQLAlchemy Queries
-In this chapter, you will learn to perform advanced—and incredibly useful—queries that enable you to interact with your data in powerful ways.

Creating and Manipulating your own Databases
-In the previous chapters, you interacted with existing databases and queried them in different ways. Now, you will learn how to build your own databases and keep them updated.

Putting it all together
-Bring together all of the skills you acquired in the previous chapters to work on a real-life project. From connecting to a database and populating it, to reading and querying it.

Taught by

Jason Myers

Reviews

1.0 rating, based on 2 Class Central reviews

4.4 rating at DataCamp based on 11 ratings

Start your review of Introduction to Databases in Python

  • Anonymous
    Jason's pace is way too quick for me to process the information he's attempting to teach. His descriptions of the code barely are finished before he moves on. Slides are not helpful, and when they are, they move way too fast. I would NOT recommend this course with Jason. It was very difficult to learn from him.
  • Anonymous
    Jason Myers might be a great data scientist but he fails as a teacher. Other datacamp instructors explain things better and more suited to beginners

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.