- 1 What this Course Covers
- 2 Getting Started
- 3 What to Focus On
- 4 Executing SQL Statements from Ruby
- 5 Project Demo
- 6 Project Setup
- 7 Database Design
- 8 Listing Expenses
- 9 Displaying Help
- 10 Adding Expenses
- 11 Handling Parameters Safely
- 12 Code Structure
- 13 Searching Expenses
- 14 Deleting Expenses
- 15 Clearing Expenses
- 16 Counting and Totaling Expenses
- 17 Creating the Schema Automatically
- 18 Summary
- 1 Getting Started
- 2 What to Focus On
- 3 Project Overview
- 4 Extracting Session Manipulation Code
- 5 Designing a Schema
- 6 Setting up a Database Connection
- 7 Executing and Logging Database Queries
- 8 Loading Records From the Database
- 9 Solving the Reloading Problem
- 10 Development Configuration
- 11 Working with Lists
- 12 Working with Todos
- 13 Deploying PG Applications to Heroku
- 14 Summary
- 1 What to focus on
- 2 Identifying Optimizations
- 3 Optimising N + 1 queries
- 4 Pushing Down Operations to the Database
- 5 Summary
- 6 Quiz
| 1st: John the Baptist | 2nd: deep-dive | 3rd: find/fill gaps | |
|---|---|---|---|
| L1 | 29.11.23 | 2.12.23 | |
| L2 | 30.11.23 | 4.11.23 | |
| L3 | 30.11.23 | 4.11.23 | |
| L4 | 6.12.23 |