I just completed DataCamp’s course titled “Introduction to Databases in Python“. This is a very informative course, and is actually one of the few tutorials out there that I have run across on SQLAlchemy.
I just finished Northwestern University’s MSPA (Master of Science in Predictive Analytics) Predict 420 class – Database Systems and Data Preparation Review, and I wish I would have taken DataCamp’s course first. It would have helped tremendously. You have the opportunity to use SQLAlchemy to interact with SQL databases in Predict 420, but I looked and could not find a really good tuturial on this, until I ran across DataCamp’s course, after I finished Predict 420. I highly recommend this DataCamp course to other MSPA students.
Introduction to Databases in Python is divided up into 5 sections, with the course’s description of each section attached.
- Basics of Relational Database. 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.
- Applying Filtering, Ordering, and Grouping to Queries. In this chapter, 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!
- Advanced SQLAlchemy Queries. Herein, you will learn to perform advanced – and incredibly useful – queries that will 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 various different ways. Now, you will learn how to build your own databases and keep them updated!
- Putting it all together. Here, you will bring together all of the skills you acquired in the previous chapters to work on a real life 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.