LAST WEEK BEFORE FINALS!

FINAL PROJECT FINAL EXAM SCHEDULE

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


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

FINAL PRESENTATIONS
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
Intro to Digital Ocean
Basic server setup & configuration
Week 8 Assignments Homework 8
Lab 7

Week 9 Topics Client/Server STATES
Local Storage vs Cookies vs Sessions
JWTs
Hashing & Indexing
SSH Key Pairs
Week 9 Assignments Homework 9
Lab 8

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

Week 11 Topics RESTful APIs
JSON RPC 2.0 jQuery
Intro to Bootstrap
API (Application Programming Interface)
RPC (Remote Proceedure Calls)
API / RPC Protocols
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
Lab 11

Week 13 Topics Password hashing
JSON Webtokens
PHP APIs
Week 13 Assignments
EC Guided Lab 12


Week 14 Topics REVIEW
Final Project Prep
Q&A
Week 13 Assignments

Week 15 Topics FINAL PRESENTATIONS
Week 15 Assignments FINAL PRESENTATIONS
`