premium course

Introduction to Databases in Python

Start Course For Free Play Trailer
  • 20 Videos
  • 66 Exercises
  • 4 hours 
  • 3,273 Participants
  • 5450 XP

Instructor(s):

Jason Myers
Jason Myers

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.

Collaborator(s):

Hugo Bowne-Anderson Hugo Bowne-Anderson

Vincent Lan Vincent Lan

Yashas Roy Yashas Roy

Course Description

Whether you like it or not, databases are ubiquitous and, as a data scientist, you'll need to interact with them constantly. The Python SQL toolkit SQLAlchemy provides an accessible and intuitive way to query, build & write to SQLite, MySQL and Postgresql databases (among many others), all of which you will encounter in the daily life of a data scientist. In this course, you'll learn the basics of relational databases and why they're everywhere, along with how to interact with them for all your data scientific needs.

1Basics of Relational Databases Free

In this chapter, you will become acquainted with the fundamentals of Relational Databases and the Relational Model. You will learn how to connect to a database and then interact with it by writing basic SQL queries, both in raw SQL as well as with SQLAlchemy, which provides a Pythonic way of interacting with databases.