Lynda | Advanced Python: Working with Databases [FCO]

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size1014.3 MB
  • Uploaded BySunRiseZone
  • Downloads315
  • Last checkedDec. 24th '20
  • Date uploadedDec. 21st '20
  • Seeders 35
  • Leechers6
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : 290E1CFB88E1C416D71EFC9A6621DE7AB0190859

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

Files:

[FreeCoursesOnline.Me] Lynda - Advanced Python Working with Databases 0. Introduction
  • 001 - Using databases to level up your Python applications.mp4 (9.3 MB)
  • 001 - Using databases to level up your Python applications.srt (2.6 KB)
  • 002 - What you need to know.mp4 (6.6 MB)
  • 002 - What you need to know.srt (3.9 KB)
0. Websites you may like
  • 0. (1Hack.Us) Premium Tutorials-Guides-Articles _ Community based Forum.url (0.4 KB)
  • 1. (FreeCoursesOnline.Me) Download Udacity, Masterclass, Lynda, PHLearn, Pluralsight Free.url (0.3 KB)
  • 3. (FTUApps.com) Download Cracked Developers Applications For Free.url (0.2 KB)
  • How you can help our Group!.txt (0.2 KB)
1. Introduction to Databases in Python
  • 001 - What is a database.mp4 (5.9 MB)
  • 001 - What is a database.srt (3.3 KB)
  • 002 - Relational databases.mp4 (12.8 MB)
  • 002 - Relational databases.srt (6.5 KB)
  • 003 - Non-relational databases.mp4 (10.0 MB)
  • 003 - Non-relational databases.srt (6.8 KB)
  • 004 - Python Database API.mp4 (7.1 MB)
  • 004 - Python Database API.srt (5.0 KB)
2. Using SQLite in Python
  • 001 - What is SQLite.mp4 (4.6 MB)
  • 001 - What is SQLite.srt (3.4 KB)
  • 002 - Creating an SQLite database.mp4 (5.6 MB)
  • 002 - Creating an SQLite database.srt (5.7 KB)
  • 003 - Manipulating records in a SQLite database.mp4 (16.9 MB)
  • 003 - Manipulating records in a SQLite database.srt (11.8 KB)
  • 004 - What is SQLAlchemy.mp4 (8.7 MB)
  • 004 - What is SQLAlchemy.srt (6.6 KB)
  • 005 - Setting up a virtual environment for SQLAlchemy.mp4 (4.9 MB)
  • 005 - Setting up a virtual environment for SQLAlchemy.srt (4.2 KB)
  • 006 - Using SQLAlchemy Core with an SQLite database.mp4 (19.7 MB)
  • 006 - Using SQLAlchemy Core with an SQLite database.srt (15.2 KB)
  • 007 - Challenge- Create an SQLite database.mp4 (2.2 MB)
  • 007 - Challenge- Create an SQLite database.srt (1.4 KB)
  • 008 - Solution- Create an SQLite database.mp4 (24.2 MB)
  • 008 - Solution- Create an SQLite database.srt (13.6 KB)
3. Using MySQL in Python
  • 001 - What is MySQL.mp4 (9.5 MB)
  • 001 - What is MySQL.srt (6.2 KB)
  • 002 - Creating a MySQL database.mp4 (7.8 MB)
  • 002 - Creating a MySQL database.srt (5.9 KB)
  • 003 - Building tables in a MySQL database.mp4 (25.1 MB)
  • 003 - Building tables in a MySQL database.srt (13.6 KB)
  • 004 - Connecting a Python application to a MySQL database.mp4 (12.8 MB)
  • 004 - Connecting a Python application to a MySQL database.srt (9.9 KB)
  • 005 - Encaspulating database operations to make better applications.mp4 (29.3 MB)
  • 005 - Encaspulating database operations to make better applications.srt (15.6 KB)
  • 006 - Developing Pythonic applications with SQLAlchemy ORM.mp4 (23.9 MB)
  • 006 - Developing Pythonic applications with SQLAlchemy ORM.srt (13.4 KB)
  • 007 - Using SQLAlchemy Sessions to transact on a MySQL database.mp4 (24.4 MB)
  • 007 - Using SQLAlchemy Sessions to transact on a MySQL database.srt (10.9 KB)
  • 008 - Using SQL to import CSV data.mp4 (40.4 MB)
  • 008 - Using SQL to import CSV data.srt (0.1 KB)
  • 009 - Leveraging SQLAlchemy and pandas to import CSV data.mp4 (24.4 MB)
  • 009 - Leveraging SQLAlchemy and pandas to import CSV data.srt (11.6 KB)
  • 010 - Challenge- Create a MySQL database.mp4 (5.2 MB)
  • 010 - Challenge- Create a MySQL database.srt (2.0 KB)
  • 011 - Solution- Create a MySQL database.mp4 (25.9 MB)
  • 011 - Solution- Create a MySQL database.srt (12.1 KB)
4. Using PostgreSQL in Python
  • 001 - What is PostgreSQL.mp4 (5.0 MB)
  • 001 - What is PostgreSQL.srt (3.9 KB)
  • 002 - Creating a PostgreSQL database.mp4 (12.4 MB)
  • 002 - Creating a PostgreSQL database.srt (7.5 KB)
  • 003 - Creating a table in Postgres using Python.mp4 (8.2 MB)
  • 003 - Creating a table in Postgres using Python.srt (7.8 KB)
  • 004 - Inserting data into a Postgres database.mp4 (21.2 MB)
  • 004 - Inserting data into a Postgres database.srt (12.1 KB)
  • 005 - Interacting with a Postgres database using Python.mp4 (31.3 MB)
  • 005 - Interacting with a Postgres database using Python.srt (15.5 KB)
  • 006 - Pythonic Postgres interactions with SQLAlchemy Core.mp4 (31.6 MB)
  • 006 - Pythonic Postgres interactions with SQLAlchemy Core.srt (15.9 KB)
  • 007 - Pythonic Postgres interactions with SQLAlchemy ORM.mp4 (27.5 MB)
  • 007 - Pythonic Postgres interactions with SQLAlchemy ORM.srt (13.0 KB)
  • 008 - Grouping SQL statements with stored procedures.mp4 (5.3 MB)
  • 008 - Grouping SQL statements with stored procedures.srt (3.7 KB)
  • 009 - Creating a stored procedure in PostgreSQL.mp4 (18.7 MB)
  • 009 - Creating a stored procedure in PostgreSQL.srt (10.1 KB)
  • 010 - Using Postgres stored procedures and functions in Python.mp4 (21.6 MB)
  • 010 - Using Postgres stored procedures and functions in Python.srt (0.1 KB)
  • 011 - Challenge- Create a Postgres database.mp4 (5.0 MB)
  • 011 - Challenge- Create a Postgres database.srt (3.6 KB)
  • 012 - Solution- Create a Postgres database.mp4 (44.2 MB)
  • 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)
  • 001 - Setting up Flask in a Python application.srt (3.7 KB)
  • 002 - Creating a webpage with Flask.mp4 (11.1 MB)
  • 002 - Creating a webpage with Flask.srt (9.5 KB)
  • 003 - Developing additional routes to enhance your application.mp4 (17.2 MB)
  • 003 - Developing additional routes to enhance your application.srt (12.8 KB)
  • 004 - Instantiating a Postgres database using Python.mp4 (14.5 MB)
  • 004 - Instantiating a Postgres database using Python.srt (8.1 KB)
  • 005 - Connecting a database to a Pythonic Flask project.mp4 (21.7 MB)
  • 005 - Connecting a database to a Pythonic Flask project.srt (10.4 KB)
  • 006 - Feeding data from a database into a Flask application.mp4 (16.3 MB)
  • 006 - Feeding data from a database into a Flask application.srt (7.1 KB)
  • 007 - Develop add functionality to a Flask application.mp4 (29.4 MB)
  • 007 - Develop add functionality to a F

Code:

  • udp://opentor.org:2710/announce
  • udp://p4p.arenabg.com:1337/announce
  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://9.rarbg.to:2710/announce
  • udp://exodus.desync.com:6969/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.moeking.me:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • http://tracker.foreverpirates.co:80/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://open.stealth.si:80/announce
  • udp://tracker.internetwarriors.net:1337/announce