1 2-min Introduction.mp4 (15.67 MB)
MP4
2 1 all resources.zip (1.43 MB)
ZIP
1 Section Overview.mp4 (3.08 MB)
MP4
10 Column Names Would Be Nice.mp4 (52.11 MB)
MP4
11 The Transaction Lifecycle.mp4 (14.32 MB)
MP4
12 Parameterized Statements.mp4 (37.23 MB)
MP4
13 A Different Flavor.mp4 (12.36 MB)
MP4
14 Various Ways To Execute.mp4 (35.67 MB)
MP4
15 Database Dump.mp4 (32.87 MB)
MP4
16 Context Managed Connections.mp4 (26.7 MB)
MP4
17 Let's Build!.mp4 (8.39 MB)
MP4
18 1 day 1 - challenges.zip (85.08 KB)
ZIP
19 Creating A Virtual Environment.mp4 (20.96 MB)
MP4
2 1 day1 - lecture resources.zip (5.89 KB)
ZIP
20 Challenge 1 - Interface.mp4 (7.13 MB)
MP4
21 The Interface.mp4 (36.11 MB)
MP4
22 Sketching Out The Basics.mp4 (5.53 MB)
MP4
23 Challenge 2 - DDL.mp4 (2.77 MB)
MP4
24 Executing the DDL.mp4 (53.3 MB)
MP4
25 Foreign Key Gotcha.mp4 (17.03 MB)
MP4
26 The Add Box Menu.mp4 (49.17 MB)
MP4
27 Challenge 3 - Add Box To Database.mp4 (3.2 MB)
MP4
28 Add Box Helper.mp4 (34.35 MB)
MP4
29 Challenge 4 - Displaying Box Types.mp4 (7.9 MB)
MP4
3 Introduction to SQLIite.mp4 (13 MB)
MP4
30 Displaying All Boxes.mp4 (36.21 MB)
MP4
31 A Prettier Display.mp4 (28.91 MB)
MP4
32 Challenge 5 - Loading Boxes With Validation.mp4 (8.63 MB)
MP4
33 Load Box Menu.mp4 (65.23 MB)
MP4
34 The Containers Database View.mp4 (32.51 MB)
MP4
35 Container Constraints.mp4 (55.95 MB)
MP4
36 The Final Stretch.mp4 (39.86 MB)
MP4
38 Challenge 6 - Seed Data.mp4 (2.88 MB)
MP4
39 Seeding Some Boxes.mp4 (38.12 MB)
MP4
4 sqlite3 In Python.mp4 (12.62 MB)
MP4
40 Challenge 7 - Containers.mp4 (2.38 MB)
MP4
41 Displaying Containers.mp4 (45.58 MB)
MP4
42 Business Summary.mp4 (12.44 MB)
MP4
43 The Bottom Line.mp4 (94.09 MB)
MP4
44 Challenge 9 - Configurable Constants.mp4 (10.16 MB)
MP4
45 Refactoring Configuration.mp4 (88.4 MB)
MP4
5 DBAPI 2 0.mp4 (23.84 MB)
MP4
6 Connections And Cursors.mp4 (29.95 MB)
MP4
7 Inserts.mp4 (11.46 MB)
MP4
8 DML vs DDL (and DCL and DQL).mp4 (15.64 MB)
MP4
9 Fetching.mp4 (26.42 MB)
MP4
1 Section Overview.mp4 (3.28 MB)
MP4
10 Prepared Statements.mp4 (29.94 MB)
MP4
11 Let's Fetch.mp4 (18.09 MB)
MP4
12 Buffering.mp4 (13.15 MB)
MP4
13 Dict Cursors.mp4 (18.35 MB)
MP4
14 A Named Alternative.mp4 (21.58 MB)
MP4
15 executescript() Please.mp4 (69.99 MB)
MP4
16 Best Multi With Autocommit.mp4 (67.74 MB)
MP4
17 Let's Build!.mp4 (16.64 MB)
MP4
18 1 day 2 - all challenges.zip (216.45 KB)
ZIP
19 Setting Up.mp4 (4.2 MB)
MP4
20 The Interface.mp4 (47.97 MB)
MP4
21 Challenge 1 - Connection Helper.mp4 (1.23 MB)
MP4
22 Writing The Helper.mp4 (42.44 MB)
MP4
23 Challenge 2 - Prepare The DDL.mp4 (6.26 MB)
MP4
24 Wiring Up The DDL.mp4 (50.91 MB)
MP4
25 Challenge 3 - The Reset Command.mp4 (2.97 MB)
MP4
26 Resetting The Database.mp4 (36.01 MB)
MP4
27 Challenge 4 - Add Student.mp4 (2.07 MB)
MP4
28 Adding New Students.mp4 (41.7 MB)
MP4
29 Challenge 5 - Add Course.mp4 (2.01 MB)
MP4
3 Welcome To MySQL.mp4 (12.93 MB)
MP4
30 Adding New Courses.mp4 (22.46 MB)
MP4
31 Challenge 6 - Prerequisites.mp4 (11.71 MB)
MP4
32 Prereq DDL And Command.mp4 (77.53 MB)
MP4
33 Addressing A Small Inconsistency.mp4 (27.6 MB)
MP4
34 Challenge 7 - Querying.mp4 (10.94 MB)
MP4
35 The Query Helper.mp4 (58.08 MB)
MP4
36 Challenge 8 - Seeding Data.mp4 (10.87 MB)
MP4
37 Initializing Data.mp4 (90.15 MB)
MP4
38 —no-with-data.mp4 (17.09 MB)
MP4
39 Challenge 9 - Show Prerequisites For Course.mp4 (4.86 MB)
MP4
4 Local Vs Cloud MySQL.mp4 (31.56 MB)
MP4
40 Displaying Prereqs.mp4 (33.78 MB)
MP4
41 Pretty Tables.mp4 (57 MB)
MP4
42 Challenge 10 - Show Students And Courses.mp4 (8.17 MB)
MP4
43 Displaying Students And Courses.mp4 (59.58 MB)
MP4
44 Challenge 11 - Course Enrollment Part I.mp4 (13.48 MB)
MP4
45 Naive Enrollment.mp4 (75.7 MB)
MP4
46 Challenge 12 - Grading.mp4 (7.97 MB)
MP4
47 The Grade Command.mp4 (29.83 MB)
MP4
48 Challenge 13 - Course Enrollment Part II.mp4 (2.68 MB)
MP4
49 Prereq-aware Enrollment.mp4 (138.13 MB)
MP4
5 Connecting From Python.mp4 (28.87 MB)
MP4
50 Hiding Internals, Colorizing Externals.mp4 (61.05 MB)
MP4
51 Verbose Query Execution.mp4 (53.2 MB)
MP4
52 Challenge 14 - Unenroll.mp4 (1.98 MB)
MP4
53 Unenrolling Students.mp4 (28.33 MB)
MP4
54 Challenge 15 - Courses By Student.mp4 (2.14 MB)
MP4
55 Current Enrollment Report.mp4 (35.04 MB)
MP4
56 Challenge 16 - Transcripts.mp4 (3.66 MB)
MP4
57 Generating Transcripts.mp4 (51.37 MB)
MP4
58 Challenge 17 - Letter Grades.mp4 (2.98 MB)
MP4
59 Approach.mp4 (47.36 MB)
MP4
6 URL Parsing.mp4 (23.43 MB)
MP4
60 Implementation.mp4 (44.97 MB)
MP4
61 Challenge 18 - Most Popular Courses.mp4 (2.81 MB)
MP4
62 Most Enrolled Courses.mp4 (45.64 MB)
MP4
63 Challenge 19 - Top Students.mp4 (2.92 MB)
MP4
64 Top Performers.mp4 (45.57 MB)
MP4
7 Cursors Again.mp4 (30.67 MB)
MP4
8 Context Managers Revisited.mp4 (45.12 MB)
MP4
9 Parameterized Inserts.mp4 (19.5 MB)
MP4
1 Section Overview.mp4 (4.04 MB)
MP4
10 Dynamic Queries Part II.mp4 (97.42 MB)
MP4
11 Quick Refactor.mp4 (20.26 MB)
MP4
12 Let's Build!.mp4 (14.24 MB)
MP4
13 1 day 3 - challenges.zip (373.75 KB)
ZIP
14 New Virtual Env.mp4 (11.17 MB)
MP4
15 The Web-based API.mp4 (29.41 MB)
MP4
16 Automatic Documentation.mp4 (10.71 MB)
MP4
17 Our Database.mp4 (10.29 MB)
MP4
18 Object-Oriented Helper Part I.mp4 (39.01 MB)
MP4
19 Object-Oriented Helper Part II.mp4 (26.18 MB)
MP4
20 Connection URL As Env Variable.mp4 (25.55 MB)
MP4
21 Dependency Injection.mp4 (55.73 MB)
MP4
22 Challenge 1 - DDL.mp4 (9.05 MB)
MP4
23 Creating Our First Tables.mp4 (20.3 MB)
MP4
24 The Register Endpoint.mp4 (35.58 MB)
MP4
25 Data Validation With Pydantic.mp4 (26.42 MB)
MP4
26 User Registration Data Validation.mp4 (53.16 MB)
MP4
27 Hashing Passwords.mp4 (66.21 MB)
MP4
28 Registration With Hashed Passwords.mp4 (27.84 MB)
MP4
29 Challenge 2 - Persisting To Database.mp4 (2.6 MB)
MP4
3 PostgreSQL.mp4 (10.98 MB)
MP4
30 Inserting Users.mp4 (40.47 MB)
MP4
31 Adding The UNIQUE Constraint.mp4 (37.08 MB)
MP4
32 HTTPExceptions And Status Codes.mp4 (50.62 MB)
MP4
33 Challenge 3 - Object-Oriented Refactor.mp4 (17.04 MB)
MP4
34 OOP Write Returning Id.mp4 (89.34 MB)
MP4
35 Challenge 4 - Registration Tokens.mp4 (7.09 MB)
MP4
36 Saving Tokens.mp4 (23.22 MB)
MP4
37 The Activate Endpoint + Cleanup.mp4 (39.31 MB)
MP4
38 Challenge 5 - Get One.mp4 (14.21 MB)
MP4
39 Implementing Database get one().mp4 (101.65 MB)
MP4
4 The Precompiled Alternative.mp4 (24.3 MB)
MP4
40 Challenge 6 - Get One As Special Case Of Get.mp4 (9.73 MB)
MP4
41 Implementing A Generalized Get.mp4 (46.63 MB)
MP4
42 Challenge 7 - Update.mp4 (13.74 MB)
MP4
43 Implementing Database update().mp4 (64.96 MB)
MP4
44 Challenge 8 - Endpoint Integration.mp4 (5.02 MB)
MP4
45 The Activate Flow.mp4 (61.2 MB)
MP4
46 Challenge 9 - Activate Once.mp4 (3.63 MB)
MP4
47 Enforcing One Time Activation.mp4 (53.56 MB)
MP4
48 Messages Prep.mp4 (40.08 MB)
MP4
49 Form vs Query Params.mp4 (22.35 MB)
MP4
5 Database Server.mp4 (17.27 MB)
MP4
50 Code Reorg Using Routers.mp4 (96.4 MB)
MP4
51 Challenge 10 - Messages DDL + Path.mp4 (10.56 MB)
MP4
52 Persisting Messages.mp4 (57.77 MB)
MP4
53 Fixing A Typo.mp4 (4.32 MB)
MP4
54 Authentication.mp4 (70.9 MB)
MP4
55 Authenticated POST messages.mp4 (51.25 MB)
MP4
56 Fixing An Old Bug.mp4 (26.55 MB)
MP4
57 Challenge 11 - Updating Messages.mp4 (5.69 MB)
MP4
58 PATCH messages.mp4 (81.51 MB)
MP4
59 Challenge 12 - Get Message By Id.mp4 (9.42 MB)
MP4
6 Connecting.mp4 (23.49 MB)
MP4
60 Getting Public + Own Messages.mp4 (64.91 MB)
MP4
61 Challenge 13 - Get All Messages.mp4 (8.11 MB)
MP4
62 Getting Public And Own Messages.mp4 (44.65 MB)
MP4
63 or where Refactor.mp4 (70.32 MB)
MP4
64 Challenge 14 - Database Delete.mp4 (6.68 MB)
MP4
65 Implementing delete().mp4 (31.33 MB)
MP4
66 Refactoring Database Methods.mp4 (94.51 MB)
MP4
67 Challenge 15 - Integrating Delete.mp4 (3.33 MB)
MP4
68 Deleting Messages From The Interface.mp4 (48.42 MB)
MP4
69 Challenge 16 - New Get Contains.mp4 (20.67 MB)
MP4
7 Query Execution.mp4 (46.4 MB)
MP4
70 Implementing Get With Like Operator.mp4 (74.84 MB)
MP4
71 Challenge 17 - Get With Contains.mp4 (26.87 MB)
MP4
72 Refactoring Get.mp4 (36.34 MB)
MP4
73 Challenge 18 - Search Messages.mp4 (4.2 MB)
MP4
74 Implementing Message Search.mp4 (122.55 MB)
MP4
75 A More Coherent Database get().mp4 (74.25 MB)
MP4
76 The Final get() Refactor.mp4 (135.07 MB)
MP4
77 Challenge 19 - Upvotes.mp4 (4.15 MB)
MP4
78 Upvotes DDL.mp4 (30.24 MB)
MP4
79 Challenge 20 - Upvoting.mp4 (4.06 MB)
MP4
8 Parametrization.mp4 (53.91 MB)
MP4
80 The Upvote Interface.mp4 (106.68 MB)
MP4
81 Quick Bug Fix.mp4 (14.65 MB)
MP4
82 Challenge 21 - Most Popular Messages.mp4 (9.02 MB)
MP4
83 Most Upvoted.mp4 (79.6 MB)
MP4
84 Preparing To Send Emails.mp4 (44.39 MB)
MP4
85 Sending Generated Tokens.mp4 (101.41 MB)
MP4
86 Two Little Tweaks.mp4 (20.2 MB)
MP4
87 Preparing To Deploy.mp4 (45.44 MB)
MP4
88 Deployment.mp4 (49.07 MB)
MP4
9 Dynamic Query Generation.mp4 (58.18 MB)
MP4
1 Outro + Sqlalchemy Musings.mp4 (13.53 MB)
MP4