Advanced Python - Working with Databases

[ FreeCourseWeb.com ] Advanced Python: Working with Databases



Download More Latest Courses Visit -->> https://FreeCourseWeb.com







MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Skill Level: Advanced | Genre: eLearning | Language: English + .srt | Duration: 4h 51m | Size: 766 MB

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



Use Winrar to Extract. And use a shorter path when extracting, such as C: drive



ALSO ANOTHER TIP: You Can Easily Navigate Using Winrar and Rename the Too Long File/ Folder Name if Needed While You Cannot in Default Windows Explorer. You are Welcome ! :)



Download More Latest Courses Visit -->> https://FreeCourseWeb.com



Get Latest Apps Tips and Tricks -->> https://AppWikia.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...