Professor: Randy Appleton rappleto@nmu.edu
Wed Jan 17 --
Go over the syllabus. Meet each other. Talk about losing weight story. Tell web architecture.
HTMLCan you do forms and multimedia and CSS?
The Three Tiered Architecture.
Two types of Databases.
SQL, including how to create a table (with types), drop a table, and ask queries (with operators). Joins.
Fri Jan 19 – Make a personal database. Types. More joins. Review insert and create table and select. Subqueries. limit statement. Work on This problem in pairs.
Mon Jan 22 -- Database decomposition. transactions and Optimization.
Wed Jan 24 -- SQL using distinct and count and group by and in and subqueries. More sql homework. PHP make programs that 1) count from 1 to 100 2) compute the fib(10) using a function and Fizbuz.
Mon Jan 29 -- Work day.
Wed Jan 31 -- Quiz.
Mon Feb 5 -- Databases in PHP.
Mon Feb 12 -- The complete app and Login Assignment.
Wed Feb 15 -- Cookies and Session variables. My Login
Mon Feb 19 -- Arrays in php. LoadAverage.Regular Expressions. Character classes. Big list of special characters. Regex tester. Patterns to make.
Mon Mar 12 -- Soundex Images in PHP
Mon Mar 19 -- Map Projections and The Mapping Assignment.
Mon Mar 27 -- Python for fun
Wed Mar 29 -- Bottle.
Mon Apr 1 -- MP3 Assignment. Python module of the week and MP3 tagger and List files and static_file
'
Mon Apr 9 -- Cork!! Cork man pages How to install cork (bad) Simple webapp cork howto Cork config files recreate accounts My cork example. Configuring email.
Wed Apr 18 -- The Template Assignment. Templates and Bottle SQL and Bottle Templates
Fri Apr 20 -- Lab day. MP3 thing due
Mon Apr 23 -- AJAX in bottle. Web Scrapy thing
Wed Apr 25 -- Course Eval. Review for the final exam.
Fri Apr 27 -- Practice final exam.