You've learned the relational model and basic SQL queries with SQLAlchemy. The course ahead covers stronger querying, extracting diverse data, and creating and writing to databases. The final chapter has you build a database from US Census data and query it for demographic insights.
Chapters
Congratulations on making it through the first chapter, you've become acquainted with the basics of the relational model and relational databases and are now able to make basic SQL queries using SQLAlchemy. In the rest of this course, you'll beef up your SQL querying skills and learn how to extract all types of useful information from your databases using SQLAlchemy. In addition, you'll learn how to create and write to relational databases very necessary skills for working data scientists because new data is constantly being created in our streaming world. In the final chapter, you'll consolidate all of your skills with a deep dive into the US Census data set. In that chapter, you'll create a database, load data, and query it in order to extract information about U.S. demographics. See you in the next chapter.