IT'S WEEK 15!
PRESENTATIONS ALL WEEK

Project 3 (FINAL PROJECT) WHAT'S THIS?!

Contact Info

Instructor:
William Paul Royer

Email:
wroyer@csub.edu

Office:
Science III 339

Office Hours:

Monday 11:00am - 1:00pm
Wednesday 11:00am - 1:00pm
Friday 10:00am - 12:00pm


If you are unable to meet with me during my regularly scheduled office hours please contact me by e-mail and I will work with you to schedule a special time to meet.

Schedule

Date Lesson Plan
Week 1 Topics Review Syllabus
Course Overview
Monolithic Servers vs Microservices
Review Odin, Linux, VIM
Review HTML, JavaScript, CSS
W3Schools

Week 1 Assignments Homework 1
Lab 1

Week 2 Topics PHP Syntax
Running a php script via console
Accessing php via the browser
Data Types
Variables/Identifiers
Scope
Operators
Constants
Conditional statments
Control structures
Looping
Embedding php in html
Understanding php output
Developer mode and errors
Logging
Week 2 Assignments Homework 2
Lab 2

Week 3 Topics Functions
Arrays (Indexed & Associative)
Array Looping
Array Functions
Array Manipulation
MORE Strings
String Functions
String Manipulation
Week 3 Assignments Homework 3
Lab 3

Week 4 Topics Forms Review
Input Types
Requests: get/post
Superglobals $_GET vs $_POST
Processing Form Data
Server Side Validation
Sticky Form Values
Week 4 Assignments Homework 4
Lab 4

Week 5 Topics More Functions!
Intro To OOP/Classes
Intro To Relational Data
Intro to mySQL
Week 5 Assignments Homework 5
Project 1

Week 6 Topics More SQL!
Creating/Dropping Tables
SQL Datatypes
INSERT, SELECT, UPDATE, DELETE
Sourcing .sql files
MySQLi in PHP
Prepared statements
Week 6 Assignments Homework 6
Guided Lab 5

Week 7 Topics More MySQLi
fetch_row, fetch_assoc, fetch_array
MYSQLI_ASSOC, MYSQLI_NUM, MYSQLI_BOTH
get_result, bind_result, store_result
Week 7 Assignments Homework 7
Lab 6

Week 8 Topics Internet infrastructure
HTTP, HTTPS, SSL
DNS (Domain Name System)
DNS record types (A, CNAME, MX, TXT, etc...)
Domain names & nameservers
Week 8 Assignments Homework 8
Lab 7

Week 9 Topics Intro to Digital Ocean
Basic server setup & configuration
More about SSL JWTs
SSH Key Pairs
Reverse Proxy & Multiple processes
Week 9 Assignments Homework 9
Lab 8

Week 10 Topics Intro to Nodejs
Intro to NPM
Managing processes with PM2
Week 10 Assignments Lab 9
Project 2

Week 11 Topics jQuery
Intro to Bootstrap
API (Application Programming Interface)
RPC (Remote Proceedure Calls)
API / RPC Protocols
RESTful APIs
JSON RPC 2.0
Week 11 Assignments Homework 10
Lab 10

Week 12 Topics Nodejs echosystem
NPM in depth
Package.json
node_modules/
express.js
git & github
Week 12 Assignments Project 3
Week 13 Topics More Express.js
API Design
Debugging & Tools
curl, ajax, fetch
Week 13 Assignments CONTINUE FINAL PROJECT
Lab 11

Week 14 Topics Password hashing
JSON Webtokens
REVIEW
Week 14 Assignments FINAL PROJECT PREP
EC Guided Lab 12


Week 15 Topics CLASS FINAL PRESENTATIONS
`