python-for-software-engineering-bootcamp-2

\ 5:38 Window Functions and Aliases 21:05 Row Numbers and Ranks 27:20 Using Other Rows with Window Functions 38:28 NTiles 42:37 Understanding Query Performance Databases into our Application\ 46:24 Adding Postgres into our Docker Compose 1:01:02 Creating Database Models in Python 1:39:18 Database Migrations 2:10:25 SQLAlchemy ORM Intro 2:30:50 Creating a Database Client 2:52:31 Updating our Application to Read From the Database 3:18:17 Database Inserts 3:29:51 Database Updates 3:41:01 Database Deletes 3:44:14 Async Database Queries 3:56:28 Async Updates 4:03:15 Updating Unit Tests to Work With the Database 4:18:09 Updating Integration Tests to Work With the Database 4:30:17 SQLite for Testing 4:51:49 Mocking \ 5:23:10 Redis Intro 5:54:44 Adding Caching Into Our Application 6:25:04 Redis Hash Intro 6:45:02 Redis Sets Intro 6:49:27 Adding Hash Caching to Pagination Endpoint 7:17:34 Python Object Serialization 7:32:57 Cache Flushing 7:44:03 Data Compression \ 7:55:08 MyPy Configurations 8:18:19 Import Sorting 8:30:21 Automatic Code Formatting 8:34:27 Additional Code Checking \ 8:42:42 Github Credentials Setup 8:48:53 Github Desktop Setup 8:50:12 Cloning A Repository 8:54:17 Pushing a Local Repository to Github 9:08:24 Reverting and Squashing Commits 9:18:10 GitHub Branches 9:25:57 Pull Request 9:42:31 Precommit Hooks 9:54:10 Github CI 10:16:35 Tagged Release 10:38:31 Reading Documentation and Parallel Programming\ 10:49:04 Threading, Multiprocessing, Async Intro 11:02:57 Threading in Python 11:21:49 Creating a Threading Class 11:36:47 Creating a Wikipedia Reader 11:50:53 Creating a Yahoo Finance Reader