Advanced Python: Working with Databases-0daytown

To create functional and useful Python applications, you need a database. Databases allow you to store data from user sessions, track inventory, make recommendations, and more. However, Python is compatible with many options: SQLite, MySQL, and PostgreSQL, among others. Selecting the right database is a skill that advanced developers are expected to master. This course provides an excellent primer, comparing the different types of databases that can be connected through the Python Database API. Instructor Kathryn Hodge teaches the differences between SQLite, MySQL, and PostgreSQL and shows how to use the ORM tool SQLAlchemy to query a database. The final chapters put your knowledge to practical use in two hands-on projects: developing a full-stack application with Python, PostgreSQL, and Flask and creating a data analysis app with pandas and Jupyter Notebook. By the end, you should feel comfortable creating and using databases and be able to decide which Python database is right for you.

Topics include:
What is a database?
Relational vs. nonrelational databases
Creating a SQLite database
Editing records in SQLite
Creating a MySQL database
Encapsulating database operations
Creating a PostgreSQL database
Interacting with databases using SQLAlchemy
Creating a stored procedure
Developing full-stack apps with Python and Flask
Developing analysis apps with pandas and SQLAlchemy

Advanced Python: Working with Databases