🔗 w3d1 :: w3d2 :: w3d3 :: w3d4 :: w3d5 🔗
- Practice
- We'll implement a simple version of a well-known card game. We'll announce the specific game, and you can look up the basic rules ahead of time.
- 📖 Programming Paradigms (5 min)
- 📖 SQL Fundamentals
- SQL For The Impatient (20 min)
- A Visual Explanation of Joins (5 min)
- Self-Joins (5 min)
- Formatting SQL Code (5 min)
- Subqueries (5 min)
- NULL (2 min)
- CASE (5 min)
- COALESCE (5 min)
- 📖 PostgreSQL Setup (10 min)
- Complete SQL Bolt Tutorial sections 1 - 12 (80 min)
- What is Privilege? (6 min)
- What is Intersectionality? (5 min)
- 12 Things Allies Can Do (5 min)
- How Do I Ally? (7 min)
- Getting Started in Social Justice (8 min)
- Solo SQL Zoo
🔐 go_video_go
- 🎥 RDBMS Intro (10 min)
- 🎥 Building a Database (25 min)
- 🎥 ORM Intro (5 min)
- 🎥 ORM Demo (25 min)
- 📖 SQLite3 (15 min)
- 📖 Heredocs (5 min)
- 📖 Little Bobby Tables (2 min)
- 🎥 CSS Display Property (8 min)
- 📖 CSS Display Property (15 min)
- Plays-Playwrights ORM (35 min)
- PostgreSQL Tutorial
- Familiarize yourself with Section 2 - 12, but don't try to remember it all. Keep this for future reference.
🔐 go_video_go
- 🎥 Starting a new Rails Project (7 min)
- 🎥 Migrations (14 min)
- 🎥 Models (8 min)
- 🎥 Basic Associations (belongs_to, has_many) (12 min)
- 🎥 More Associations (has_many through:...) (12 min)
- 🎥 Validations (13 min)
- 🎥 Indices (7 min)
- 🎥 CSS Inherits (4 min)
- 🎥 CSS Reset (16 min)
- NB: Video lectures are using Rails 4, but we will be using Rails 5 everywhere else. If you would like to read about some of the more important differences between Rails 4 and Rails 5, check out this reading.
- Intro to Rails (45 min)
- Rails 4 vs Rails 5
- Creating a new Rails project
- Migrations
- ORM Review and Intro to Active Record
- Associations:
belongs_toandhas_manyhas_many :throughhas_one- Unconventional Associations
- for now, always specify
class_name/primary_key/foreign_key
- Basic and Custom Validations
- ActiveRecord and Indexes
- 📖 ActiveRecord::Relation (15 min)
- 📖 ActiveRecord and Joins (25 min)
- 📖 Scopes (10 min)
- 📖 More on Querying (15 min)
- 🎥 CSS Float & Clearfix (18 min)
- 🎥 CSS Grid System (15 min)
- 📖 CSS Float & Clearfix (5 min)
- Movie Buff in Training (30 min)
- N+1 Buster (30 min)
- 📖 Metaprogramming (20 min)
- 📖 Class Instance Variables (15 min)
- 📖 Demo: send (5 min)
- 📖 Demo: macros (5 min)
- 📖 Nontechnical Overview of SQL (15 min)
- 🎥 CSS Flexbox (19 min)
- 📖 CSS Display Types (10 min)
- Metacorgis (30 min)