English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 2h 43m | 451 MB
This course will teach you how to develop applications in Python using both relational and NoSQL databases.
In this course, Working with Databases in Python 3, you’ll learn to develop Python applications using both relational and NoSQL databases. First, you’ll explore how to use local databases for development. Next, you’ll discover how to use database servers with native drivers. Finally, you’ll learn how to use a mapper to work with data models in Python. When you’re finished with this course, you’ll have the skills and knowledge of relational and NoSQL databases in Python needed to use databases in your next Python application.
Table of Contents
Course Overview
1 Course Overview
Using a Local Relational Database – SQLite
2 Overview
3 SQLite Databases
4 Demo – Starter Code Review
5 Using the sqlite3 Module
6 Demo – sqlite3 Module
7 Row Factories
8 Demo – Row Factories
9 Summary
Using a Relational Database – PostgreSQL and psycopg2
10 Overview
11 Installing psycopg2
12 Inserting Data
13 Retrieving Data
14 Demo
15 Summary
Using an ORM – SQLAlchemy
16 Overview
17 SQLAlchemy – A Python ORM
18 Using SQLAlchemy
19 Demo – Data Modeling
20 Demo – CRUD Part 1
21 Demo – CRUD Part 2
22 Relationships
23 Demo – Relationships Part 1
24 Demo – Relationships Part 2
25 Demo – Using the SQLAlchemy ORM in an Application
26 Demo – Swapping Databases
27 Summary
Using a Local NoSQL Database – Mongita
28 Overview
29 NoSQL Databases
30 Mongita
31 Demo – Mongita
32 Summary
Using a NoSQL Database – MongoDB and pymongo
33 Overview
34 Using MongoDB in Visual Studio Code
35 Migrating from Mongita to pymongo
36 Filtering Multiple Conditions
37 Embedded Documents and Lists
38 Demo – Embedded Documents and List
39 Summary
Using an ODM – MongoEngine
40 Overview
41 ODM vs. ORM
42 Data Modeling with MongoEngine
43 Demo – Data Modeling with MongoEngine
44 Embedded Documents with MongoEngine
45 Demo – Embedded Documents with MongoEngine
46 Summary
Resolve the captcha to access the links!