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. Luckily, we just launched Introduction to Databases in Python, taught by Jason Myers, to help you master these concepts. 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 science needs.
Introduction to Databases in Python features 67 interactive exercises that combine high-quality video, in-browser coding, and gamification for an engaging learning experience from the comfort of your browser.
What you'll learn
In the first 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.
Next, you will build on the database knowledge you began acquiring in the previous chapter by writing more nuanced queries that allow you to filter, order, and count your data, all within the Pythonic framework provided by SQLAlchemy.
In the third chapter, you will learn to perform advanced - and incredibly useful - queries that will enable you to interact with your data in powerful ways.
In the fourth chapter, you will learn how to build your own databases and keep them updated. Lastly, you will finish up with a real life case study project. From connecting to a database, to populating it, to reading and querying it, you will have a chance to apply all the key concepts you learned in this course. Enjoy!