Lecture Schedule
Please print and bring these notes/worksheets to class.
| Week | Topic | Reading | Lecture Material | In Class |
|---|---|---|---|---|
| 1 | Introduction, Databases background | Power Point Power Point Handout | ||
| 3 | Schema Diagrams, Relational Algebra | Power Point Worksheet Worksheet Solutions | ||
| 4 | SQL and MySQL | Power Point PDF Power Point Printable PDF MySQL Worksheet | In Class MySQL | |
| 5 | MySQL Queries, Creating and Editing Tables | Power Point Printable Power Point More MySQL Worksheet Solutions | In Class MySQL | |
| 6 | MySQL Outer Joins, Views, NULL, string functions, HTML | Power Point HTML Power Point MySQL Views Worksheet Solutions | ||
| 7 | HTML, CSS | CSS Power Point | ||
| 8 | PHP | Power Point | ||
| 9 | PHP and SQL | Power Point | Empty starter file: query.php To look at the txt for this file, download this php_query.txt | |
| 10 | JavaScript and jQuery | jQuery Power Point | ||
| 11 | jQuery, AJAX, JSON | Power Point printable Power Point | ||
| 12 | Last Year's final | W16 Final Note that some questions have code missing because portions resemble your A3 |