python-for-software-engineering-bootcamp-1

\ 12:29 Writing Our First Service Test 30:16 Fixtures 55:47 Integration Tests 1:24:58 Testing For Exceptions 1:31:39 Sending Requests in Python 1:51:36 Sending Async Requests 2:02:32 Testing Synchronous Requests 2:18:26 Testing Async Requests 2:28:46 Test Coverage 2:33:36 MyPy Round 2 to the Terminal\ 2:39:08 Digital Ocean Setup 2:53:52 SSH on Windows 2:59:22 Connecting With SSH 3:04:12 Basic Navigation 3:18:53 Creating Folders 3:29:23 Creating Files 3:40:29 Removing Folders and Files 3:47:06 Moving, Renaming, Copying Files and Folders 4:00:15 Environment Variables 4:09:19 Piping and Redirecting 4:15:20 Super User and Running Pythons Scripts 4:22:20 Executables and Modifying Permissions 4:37:35 Sending Requests \ 4:43:52 Docker Intro 4:53:21 Creating a Dockerfile 5:29:06 Multistage Build 5:50:53 Docker compose 6:23:34 Makefile \ 6:35:55 Intro to Relational Databases 6:51:15 Data Types and Schemas 7:08:50 [Mac] Setting Up a Local PostgreSQL Server 7:12:16 [Windows] Setting Up a Local PostgreSQL Server 7:17:08 [Mac] SQL Editor Postico 7:21:42 SQL Editor DataGrip 7:27:15 SQL Editor CLI 7:28:36 Creating and Removing a Database 7:34:37 Creating Schemas 7:38:26 Creating Tables 7:47:02 Altering Tables 7:50:08 Enumerated Types 7:54:59 Inserting Values 8:01:57 Running an SQL Script 8:08:17 Reading Data 8:15:18 Creating Tables Using Query Results 8:21:47 Aliases and Ordering 8:35:28 Conditional Filtering Direct Comparisons 8:40:36 Conditional Filtering Grouped Comparisons 8:50:57 Joining Conditionals 8:58:47 Negating Conditionals 9:03:28 Filtering Null Values 9:04:59 Creating New Columns and Arithmetics 9:12:36 Datatype Conversions 9:19:09 Logic Statements 9:26:31 Manipulating Strings 9:36:31 String Positional Information 9:44:33 String Subsets and Concatenations 10:06:25 String Replacements 10:16:01 Date and Time 10:22:34 Date and Time Intervals 10:30:11 Comments 10:37:01 Aggregation Functions 10:43:56 Grouping and Filtering Aggregations 10:56:16 Inner Join 11:15:05 Left, Right, and Outer Joins 11:31:54 Self Joins 11:41:00 Unions 11:46:29 Subqueries 11:55:32 CTEs