Jason Myers teaches you how to work with databases in Python using SQLAlchemy. You'll learn to create databases, add and query data, then apply it to a real case study with US Census data.
Chapters
Welcome to Introduction to Databases in Python. My name is Jason Myers and I'm a software engineer and an author. My area of expertise is in developing data analytics platforms. I've also written the Essential SQLalchemy book, co authored with Rick Copeland that introduces you to working with relational databases in Python. In this course you'll learn about relational databases which can be found everywhere in the data science world from the tech industry to finance and healthcare. You'll learn how to interact with databases using the SQLAlchemy toolkit, which provides a wonderfully Pythonic way to extract information from them, as well as how to create a database. We'll also learn how to add and change data within a database. Finally, you'll take a deep dive into a case study using data from the US Census. Working with databases and SQL querying can be difficult to master. In this course we provide the tools for beginners to start developing their skills in working with databases with Python. Thanks for joining and see you in the course.