Advanced Python: Working with Databases

LinkedIn Learning Review
Location
Online(Course Link)
Dates
On Demand
Course Categories
IT, Technology and Software
Certficate
Yes(Certificate of Completion)
Language
English
Course Fees
US Dollar 6.98 (Check Course Page for Last Price)No. of Attendant
Unlimited
Acquired Skills/Covered Subjects
- Introduction to Databases in Python
- Using SQLite in Python
- Using MySQL in Python
- Using PostgreSQL in Python
Provider Name | LinkedIn Learning |
---|---|
Training Areas |
|
Website | https://www.linkedin.com/learning/ |
About The Provider |
LinkedIn Learning is an American website offering video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015.Microsoft acquired LinkedIn in December 2016. |
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.