• Syllabus
• Instructor: David Tang (dtang@usc.edu)
• TA: Brighton Balfrey (balfrey@usc.edu)
• SQL Playground
• Final Project Requirements (due 5/2 at 11:59pm)

(4/26) Week 15 - Guest Lecture on Infrastructure and Deployment with Kousha Hamidi

• Kousha Hamidi on LinkedIn

(4/19) Week 14 - Guest Lecture on NoSQL Databases with Michal Meyers

• Michal Meyers on LinkedIn

(4/12) Week 13 - Introduction to Node.js

• Node.js (slides sent via email)
• Code
• Assignment 10 (due 4/19 at 11:59pm)

(4/5) Week 12 - Building a REST API

• REST APIs (slides)
• Code
• Download Postman
• Further learning
  • Laravel Documentation: API Resources
  • The JSON:API Specification
  • Laravel Sanctum
• Assignment 9 (due 4/12 at 11:59pm)
• Action Item: Download the LTS version of Node.js

(3/29) Week 11 - Mail and Queues

• Code
• Laravel Documentation: Mail
• Laravel Documentation: Queues
• Assignment 8 (due 4/5 at 11:59pm)

(3/22) Week 10 - Authorization with Gates and Policies

• Code
• Laravel Documentation: Authorization
• Assignment 7 (due 3/29 at 11:59pm)

(3/15) Week 9 - Migrations (Part 2), Mass Assignment, Middleware

• Code
• Laravel Documentation: Migrations
• Laravel Documentation: Assigning to a Belongs To Relationship
• Laravel Documentation: Middleware
• Laravel Documentation: View Routes
• Assignment 6 (due 3/22 at 11:59pm)

(3/8) Week 8 - Exam

• Midterm

(3/1) Week 7 - Migrations (Part 1), Authentication, and Middleware

• Code
• Laravel Documentation: Migrations
• Laravel Documentation: Authentication Starter Kits
• Laravel Documentation: Authentication
• Laravel Documentation: Middleware
• Midterm on 3/8

(2/22) Week 6 - Object-Relational Mapping (ORM)

• ORM Slides
• Code
• Laravel Documentation: Eloquent
• Assignment 5 (due 3/1 at 11:59pm)
• Midterm on 3/8

(2/15) Week 5 - Presidents' Day

• No class

(2/8) Week 4 - CRUD, Validation, and Flash Messages

• CSRF Slides
• Code
• Assignment 3 (due 2/22 at 11:59pm)
• Assignment 4 (due 2/22 at 11:59pm)
• Reading: Protecting Web Applications Against Cross-Site Request Forgery (CSRF) Attacks

(2/1) Week 3 - Introduction to Laravel

• Topics: MVC, Routes, Controllers, Query Builder, Views, Deploying to Heroku
• Code - OOP
• Code - Laravel
• Assignment 2 (due 2/8 at 11:59pm)
• (required) PHP Namespaces in under 5 Minutes
• (optional) LinkedIn Learning Course: PHP: Objected-Oriented Programming

(1/25) Week 2 - Review of Database-driven Web Pages with PHP

• Topics: SQL Joins, PDO, Environment Variables, Deploying to Heroku
• Class introduction slides
• chinook database SQL dump
• Code
• Assignment 1 (due 2/1 at 11:59pm)
• Action Item: Scaffold a Laravel application called "music-app"

(1/18) Week 1 - MLK (No Class)

Week 0 - Class Preparation

• Welcome