[Lynda] Advanced Python: Working with Databases

 

Author: Kathryn Hodge

Released: 10/9/2020

 

About:

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

 

About Instructor:

Kathryn Hodge works as a software developer at a media company.

In addition to her work as a developer, Kathryn runs a YouTube channel for people wanting to learn how to code. Before graduating college, she worked for three years as a computer science teaching assistant. She is very interested in the intersection of media, entertainment, and technology, and is focused on creating software that makes an impact.

 

Skills covered in this course:

• Developer
• Programming Languages
• Python

 

Size: 0.99GB

 

Course: https://www.lynda.com/Python-tutorials/Advanced-Python-Working-Databases/2832052-2.html


FRIENDLY WEBSITES

 

Tutorials For Free, Guides, Articles & Community Forum.OneHack.Us | Tutorials For Free, Guides, Articles & Community Forum. A place where everyone can share knowledge with each other



 

RELATED POSTS


One Comment

Add a Comment

Your email address will not be published. Required fields are marked *