Class Notes

Notes: 1. please visit this page frequently, as it will be updated constantly during the term
2. Items under Slides and under Additional Material are considered mandatory reading and will be tested in the exams.

Shortcuts:

11: P3P
Topics
Apr 11: Introduction to P3P (from p3pbook.com)
Additional Material
Online Resources
Reference Books
Web Privacy with P3P (O'Reilly)

10: XML Parsing
Topics
Apr 4/6: Parsing XML with PHP
Additional Material
PEAR::DB package for PHP
Online Resources
Reference Books

09: Security
Topics
Mar 23/28: SQL Injection Attacks
Mar 30: SQL Security
Additional Material
SQL Injection Attacks by Example
Online Resources
Reference Books

08: SQL Overview
Topics
Mar 16/21: overview
Additional Material
Online Resources
Reference Books

07: PHP
Topics
Mar 14: Review of PHP
Additional Material
hello.php (run),   hello2.php (run),   hello3.php (run),   hello4.php (run)

vars1.php (run),   array1.php (run),   vars2.php (run)

skel.php (run),   power1.php (run),   power2.php (run),   power3.php (run)

func1.php (run),   func2.php (run),   func3.php (run),   func4.php (run),   file1.php (run),   lala.txt

Online Resources
PHP Manual: http://www.php.net
Reference Books
Programming PHP, 1st Ed (O'Reilly)

06: Secure Coding
Topics
Mar 02: Overview
Additional Material
First Chapter of Secure Coding: Principles and Practices [pdf]
Online Resources
www.securecoding.org
Reference Books
Secure Coding: Principles and Practices (O'Reilly)

05: Data Warehousing and Data Mining
Topics
Feb 14: Data Warehousing
Feb 16: Data Mining Intro
Feb 23/28: Data Mining
Additional Material
Online Resources
www.kdnuggets.com
Reference Books

04: XML
Topics
Jan 26: introduction to XML and RSS

Jan 31: DTD

Feb 2: XPath

Feb 9: XQuery

Additional Material
XML Tutorial (XML Basic)
Introduction to XML, How can XML be Used?, XML Syntax, XML Elements, XML Attributes, XML Validation


What is RSS,   RSS Tutorial


DTD Tutorial
Introduction to DTD , DTD - XML Building Blocks, DTD - Elements, DTD - Attributes, DTD - Entities, DTD - Examples


XPath Tutorial
XPath Intro, XPath Nodes, XPath Syntax, XPath Axes, XPath Operators, XPath Examples, XPath Summary


XQuery Tutorial
XQuery Intro, XQuery Example, XQuery FLWOR Expressions, XQuery FLWOR + HTML, XQuery Terms, XQuery Syntax, XQuery Adding Elements and Attributes, XQuery Selecting and Filtering, XQuery Functions, XPath, XQuery, and XSLT Functions

Online Resources
Learning XML: Markup and Core Concepts (Book Chapter)

X is for XQuery
XQuery Tutorial

Reference Books
Learning XML (Safari link)

XML in a Nutshell, 3rd Edition (Safari link)

XML Hacks (Safari link)

03: Information Retrieval
Topics
Jan 19: IR intro

Jan 24: PageRank

Additional Material
Relevance Ranking Example [doc]

The Google Pagerank Algorithm and How It Works

Online Resources
PageRank Calculator

The Anatomy of a Large-Scale Hypertextual Web Search Engine

The PageRank Citation Ranking: Bringing Order to the Web [pdf]

Googling the Bottom Line [Wired News, 03 Feb 2005]

Reference Books

02: Review of Perl
Topics
Jan 10/12/17: perl intro
Additional Material
Examples: add_any.pl, addtwo.pl, argv.pl, array1.pl, array2.pl, array3.pl, fileio.pl, getopt.pl, hash1.pl, io1.pl, reg1.pl, reg2.pl, reg3.pl, scope1.pl, spoof.pl,
Online Resources
perl.com/ and perl.org/

Article on Lexical Scope: #1, #2, #3.

Perl Documentation: http://perldoc.perl.org/
Getopt::Long manual

Reference Books
Learning Perl, 4th Ed (O'Reilly)
Safari Chapters:   #1, #2, #3, #4, #5, #6 #7, #8, #9, #10, #11.

Programming Perl, 3rd Ed (O'Reilly)
Safari Chapters: #8, #9

01: Course Overview
Topics
Jan 05: overview
Additional Material
Online Resources
Reference Books