[FreeCoursesOnline.Me] Lynda - Advanced Python Working with Databases

[FreeCoursesOnline.Me] Lynda - Advanced Python Working with Databases

Other
Size
1014 MB
Seeders
1
Leechers
0
Files
96
Category
Other
Added
12/20/20 at 9:43pm GMT+1
Infohash
290e1cfb88e1c416d71efc9a6621de7ab0190859

Description
Lynda and other Courses >>> https://www.freecoursesonline.me/
For Developer Tools & Apps >>> https://ftuapps.com/
Forum for discussion >>> https://1hack.us/



Author : Kathryn Hodge
Language : English
Released : 10/9/2020
Duration : 4h 51m
Subtitle : Included
Skill Level : Advanced
Course Source : https://www.lynda.com/Python-tutorials/Advanced-Python-Working-Databases/2832052-2.html

Description :

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


File list
  • [FreeCoursesOnline.Me] Lynda - Advanced Python Working with Databases
  • 0. Introduction/001 - Using databases to level up your Python applications.mp4 9.3 MB
  • 0. Introduction/001 - Using databases to level up your Python applications.srt 2.6 KB
  • 0. Introduction/002 - What you need to know.mp4 6.6 MB
  • 0. Introduction/002 - What you need to know.srt 3.9 KB
  • 0. Websites you may like/How you can help our Group!.txt 208 B
  • 1. Introduction to Databases in Python/001 - What is a database.mp4 5.9 MB
  • 1. Introduction to Databases in Python/001 - What is a database.srt 3.3 KB
  • 1. Introduction to Databases in Python/002 - Relational databases.mp4 12.8 MB
  • 1. Introduction to Databases in Python/002 - Relational databases.srt 6.5 KB
  • 1. Introduction to Databases in Python/003 - Non-relational databases.mp4 10 MB
  • 1. Introduction to Databases in Python/003 - Non-relational databases.srt 6.8 KB
  • 1. Introduction to Databases in Python/004 - Python Database API.mp4 7.1 MB
  • 1. Introduction to Databases in Python/004 - Python Database API.srt 5 KB
  • 2. Using SQLite in Python/001 - What is SQLite.mp4 4.6 MB
  • 2. Using SQLite in Python/001 - What is SQLite.srt 3.4 KB
  • 2. Using SQLite in Python/002 - Creating an SQLite database.mp4 5.6 MB
  • 2. Using SQLite in Python/002 - Creating an SQLite database.srt 5.7 KB
  • 2. Using SQLite in Python/003 - Manipulating records in a SQLite database.mp4 16.9 MB
  • 2. Using SQLite in Python/003 - Manipulating records in a SQLite database.srt 11.8 KB
  • 2. Using SQLite in Python/004 - What is SQLAlchemy.mp4 8.7 MB
  • 2. Using SQLite in Python/004 - What is SQLAlchemy.srt 6.6 KB
  • 2. Using SQLite in Python/005 - Setting up a virtual environment for SQLAlchemy.mp4 4.9 MB
  • 2. Using SQLite in Python/005 - Setting up a virtual environment for SQLAlchemy.srt 4.2 KB
  • 2. Using SQLite in Python/006 - Using SQLAlchemy Core with an SQLite database.mp4 19.7 MB
  • 2. Using SQLite in Python/006 - Using SQLAlchemy Core with an SQLite database.srt 15.2 KB
  • 2. Using SQLite in Python/007 - Challenge- Create an SQLite database.mp4 2.2 MB
  • 2. Using SQLite in Python/007 - Challenge- Create an SQLite database.srt 1.4 KB
  • 2. Using SQLite in Python/008 - Solution- Create an SQLite database.mp4 24.2 MB
  • 2. Using SQLite in Python/008 - Solution- Create an SQLite database.srt 13.6 KB
  • 3. Using MySQL in Python/001 - What is MySQL.mp4 9.5 MB
  • 3. Using MySQL in Python/001 - What is MySQL.srt 6.2 KB
  • 3. Using MySQL in Python/002 - Creating a MySQL database.mp4 7.8 MB
  • 3. Using MySQL in Python/002 - Creating a MySQL database.srt 5.9 KB
  • 3. Using MySQL in Python/003 - Building tables in a MySQL database.mp4 25.1 MB
  • 3. Using MySQL in Python/003 - Building tables in a MySQL database.srt 13.6 KB
  • 3. Using MySQL in Python/004 - Connecting a Python application to a MySQL database.mp4 12.8 MB
  • 3. Using MySQL in Python/004 - Connecting a Python application to a MySQL database.srt 9.9 KB
  • 3. Using MySQL in Python/005 - Encaspulating database operations to make better applications.mp4 29.3 MB
  • 3. Using MySQL in Python/005 - Encaspulating database operations to make better applications.srt 15.6 KB
  • 3. Using MySQL in Python/006 - Developing Pythonic applications with SQLAlchemy ORM.mp4 23.9 MB
  • 3. Using MySQL in Python/006 - Developing Pythonic applications with SQLAlchemy ORM.srt 13.4 KB
  • 3. Using MySQL in Python/007 - Using SQLAlchemy Sessions to transact on a MySQL database.mp4 24.4 MB
  • 3. Using MySQL in Python/007 - Using SQLAlchemy Sessions to transact on a MySQL database.srt 10.9 KB
  • 3. Using MySQL in Python/008 - Using SQL to import CSV data.mp4 40.4 MB
  • 3. Using MySQL in Python/008 - Using SQL to import CSV data.srt 53 B
  • 3. Using MySQL in Python/009 - Leveraging SQLAlchemy and pandas to import CSV data.mp4 24.4 MB
  • 3. Using MySQL in Python/009 - Leveraging SQLAlchemy and pandas to import CSV data.srt 11.6 KB
  • 3. Using MySQL in Python/010 - Challenge- Create a MySQL database.mp4 5.2 MB
  • 3. Using MySQL in Python/010 - Challenge- Create a MySQL database.srt 2 KB
  • 3. Using MySQL in Python/011 - Solution- Create a MySQL database.mp4 25.9 MB
  • 3. Using MySQL in Python/011 - Solution- Create a MySQL database.srt 12.1 KB
  • 4. Using PostgreSQL in Python/001 - What is PostgreSQL.mp4 5 MB
  • 4. Using PostgreSQL in Python/001 - What is PostgreSQL.srt 3.9 KB
  • 4. Using PostgreSQL in Python/002 - Creating a PostgreSQL database.mp4 12.4 MB
  • 4. Using PostgreSQL in Python/002 - Creating a PostgreSQL database.srt 7.5 KB
  • 4. Using PostgreSQL in Python/003 - Creating a table in Postgres using Python.mp4 8.2 MB
  • 4. Using PostgreSQL in Python/003 - Creating a table in Postgres using Python.srt 7.8 KB
  • 4. Using PostgreSQL in Python/004 - Inserting data into a Postgres database.mp4 21.2 MB
  • 4. Using PostgreSQL in Python/004 - Inserting data into a Postgres database.srt 12.1 KB
  • 4. Using PostgreSQL in Python/005 - Interacting with a Postgres database using Python.mp4 31.3 MB
  • 4. Using PostgreSQL in Python/005 - Interacting with a Postgres database using Python.srt 15.5 KB
  • 4. Using PostgreSQL in Python/006 - Pythonic Postgres interactions with SQLAlchemy Core.mp4 31.6 MB
  • 4. Using PostgreSQL in Python/006 - Pythonic Postgres interactions with SQLAlchemy Core.srt 15.9 KB
  • 4. Using PostgreSQL in Python/007 - Pythonic Postgres interactions with SQLAlchemy ORM.mp4 27.5 MB
  • 4. Using PostgreSQL in Python/007 - Pythonic Postgres interactions with SQLAlchemy ORM.srt 13 KB
  • 4. Using PostgreSQL in Python/008 - Grouping SQL statements with stored procedures.mp4 5.3 MB
  • 4. Using PostgreSQL in Python/008 - Grouping SQL statements with stored procedures.srt 3.7 KB
  • 4. Using PostgreSQL in Python/009 - Creating a stored procedure in PostgreSQL.mp4 18.7 MB
  • 4. Using PostgreSQL in Python/009 - Creating a stored procedure in PostgreSQL.srt 10.1 KB
  • 4. Using PostgreSQL in Python/010 - Using Postgres stored procedures and functions in Python.mp4 21.6 MB
  • 4. Using PostgreSQL in Python/010 - Using Postgres stored procedures and functions in Python.srt 53 B
  • 4. Using PostgreSQL in Python/011 - Challenge- Create a Postgres database.mp4 5 MB
  • 4. Using PostgreSQL in Python/011 - Challenge- Create a Postgres database.srt 3.6 KB
  • 4. Using PostgreSQL in Python/012 - Solution- Create a Postgres database.mp4 44.2 MB
  • 4. Using PostgreSQL in Python/012 - Solution- Create a Postgres database.srt 18.7 KB
  • 5. Developing Full-Stack Applications/001 - Setting up Flask in a Python application.mp4 5.5 MB
  • 5. Developing Full-Stack Applications/001 - Setting up Flask in a Python application.srt 3.7 KB
  • 5. Developing Full-Stack Applications/002 - Creating a webpage with Flask.mp4 11.1 MB
  • 5. Developing Full-Stack Applications/002 - Creating a webpage with Flask.srt 9.5 KB
  • 5. Developing Full-Stack Applications/003 - Developing additional routes to enhance your application.mp4 17.2 MB
  • 5. Developing Full-Stack Applications/003 - Developing additional routes to enhance your application.srt 12.8 KB
  • 5. Developing Full-Stack Applications/004 - Instantiating a Postgres database using Python.mp4 14.5 MB
  • 5. Developing Full-Stack Applications/004 - Instantiating a Postgres database using Python.srt 8.1 KB
  • 5. Developing Full-Stack Applications/005 - Connecting a database to a Pythonic Flask project.mp4 21.7 MB
  • 5. Developing Full-Stack Applications/005 - Connecting a database to a Pythonic Flask project.srt 10.4 KB
  • 5. Developing Full-Stack Applications/006 - Feeding data from a database into a Flask application.mp4 16.3 MB
  • 5. Developing Full-Stack Applications/006 - Feeding data from a database into a Flask application.srt 7.1 KB
  • 5. Developing Full-Stack Applications/007 - Develop add functionality to a Flask application.mp4 29.4 MB
  • 5. Developing Full-Stack Applications/007 - Develop add functionality to a Flask application.srt 13.3 KB
  • 5. Developing Full-Stack Applications/008 - Challenge- Develop delete functionality.mp4 2.6 MB
  • 5. Developing Full-Stack Applications/008 - Challenge- Develop delete functionality.srt 1.5 KB
  • 5. Developing Full-Stack Applications/009 - Solution- Develop delete functionality.mp4 42.3 MB
  • 5. Developing Full-Stack Applications/009 - Solution- Develop delete functionality.srt 16.6 KB
  • 6. Developing Analysis Applications/001 - Introduction to pandas.mp4 6.5 MB
  • 6. Developing Analysis Applications/001 - Introduction to pandas.srt 3.3 KB
  • 6. Developing Analysis Applications/002 - Setting up pandas and Jupyter Notebook.mp4 7.6 MB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
6.7 GB11/12/18354
1.7 GB01/27/24350
1 GB12/27/22320
3.1 GB06/20/20251
4 GB12/26/19213
16 GB02/21/23210
2.1 GB07/08/20203
2.7 GB06/18/20190
2.9 GB07/25/20190
2.6 GB03/25/23180
3.9 GB12/02/23180
1 GB07/01/20170
1.7 GB11/05/22170
1.7 GB10/09/22161
6.9 GB01/07/23161