• Syllabus
• TA: Finn Todd
• SQL Playground
• Class Demos
• Final Project Requirements (due 5/1 at midnight)

(4/16) Week 15 - Securing your Node.js API with JWT and Connecting to it from a Frontend JS Application

• Starter Project
• What is CORS?
• Express CORS Middleware
• Ember.js
• jsonwebtoken
• dotenv
• Writing Express Middleware
• What is JSON Web Token?
• JWT Decoder
• Why is 'Bearer' required before the token in 'Authorization' header in a HTTP request?
• Lab 7 - Backend Career Panel Prep

(4/9) Week 14 - NoSQL Databases and MongoDB with Michal Meyers

• No labs or assignments

(4/2) Week 13 - Testing and Continuous Integration

• Frisby.js REST API Testing Framework
• Jest Testing Framework
• Chai Assertion Library
• Travis CI
• Travis CI - Core Concepts for Beginners
• forever
• Lab 6 - Relational vs Non-relational Database Research (due 4/9 before class - no extensions)
• Assignment 5 - Testing and Continuous Integration with Travis (due 4/9)

(3/26) Week 12 - Managing Asynchronous Code with async/await

• RunJS
• Review callbacks and promises
• async/await
• try/catch/throw
• Error
• Exercise/Demo: Using async/await in our Express and Sequelize API
• JSON, REST APIs, and JSON:API

(3/19) Week 11 - Node.js 3: Sequelize ORM

• CommonJS Modules
• Sequelize ORM
• Postman
• Lecture Recording
• Lab 5 - Build an API Endpoint with Express and Sequelize (due 3/26)

(3/12) Week 10 - Spring Break

• No class

(3/5) Week 9 - Node.js 2: Real-Time with Web Sockets

• ws: a Node.js WebSocket library
• Lecture Recording
• Lab 4 - An Editable Document (due 3/19)

(2/26) Week 8 - Midterm

• Midterm

(2/19) Week 7 - Node.js 1: The Fundamentals and Building a REST API

• Node.js
• Node Version Manager (nvm)
• The Node REPL and running a JS file with Node
• Asynchronous vs synchronous execution, what does it really mean?
• Callback functions
• JavaScript Promises for Dummies
• Exercise: Promisify setTimeout
• Node Package Manager (npm)
• REST APIs
• Express
• Knex Query Builder
• Deploying to Heroku
• Lab 3 - Building API Endpoints with Express (due 3/5 - no extensions)

(2/12) Week 6 - Laravel 4: Authentication and Middleware

• Middleware
• Authentication
• Migrations
• Assignment 4 - Writing Middleware (due 2/19)

(2/5) Week 5 - Laravel 3: Object-Relational Mapping with Eloquent

• Eloquent
• Class examples in php artisan tinker
• Lab 1 - Object-Relational Mapping with Eloquent (due 2/12)
• Lab 2 - Project Proposal (due 2/19)

(1/29) Week 4 - Laravel 2: Working with Forms

• CSRF
• Data Validation
• Working with Error Messages
• Old Input
• Controller method naming conventions in the section Actions Handled By Resource Controller
• Assignment 3 - Laravel 2 (due 2/5)

(1/22) Week 3 - Laravel 1: Intro to MVC

• Model-View-Controller (MVC)
• Laravel – Routes, Controllers, Query Builder, and Views
• Deploying Laravel to Heroku
• Laravel Site
• Assignment 2 - Laravel 1 (due 1/29)

(1/15) Week 2 - PDO

• HTTP Lifecycle
• Database-driven Web Pages Review
• SQL Joins
• PHP Data Objects (PDO), Prepared Statements, and Parameter Binding
• Deploying a plain PHP app to Heroku
• Sample SQLite database
• SQLite Cheatsheet
• Assignment 1 - PDO (due 1/22)

(1/8) Week 1

• Install Git
• Create a GitHub account
• Install PHP
  • Mac
  • Windows
• Reading: PHP Object Oriented Solutions – Chapter 1 & 2
• Reading: Object-Oriented PHP for Beginners