Web and Database Technologies
Tuesday 18:00-21:00 H108 (Cauldon)

corner piece Weeks 1-3 corner piece
Week Lecture Tutorial/Exercise


        1
 
 

Database Concepts
 
WDT Week by Week Topics
 

Creating Related Tables
 
Personal Information Activity
 


        2
 
 

Data Dictionary (Example)
 
Entity Relationship Diagrams (Introduction)
 

Choosing your own entities
 


        3
 
 

Creating ERDs in QSEE Superlite
 
Exporting ERDs from QSEE Superlite into MySQL
 

Creating your own ERD
 
corner piece corner piece

corner piece Weeks 4-6 corner piece
Week Lecture Tutorial/Exercise


        4
 
 

Form, Query and Report Design Task
 

Form, Query and Report (Examples)
 


        5
 
 

Entering data into MySQL
 
Simple select queries
 

Employee-Project QSEE file
 
Employee-Project with data (SQL file)
 


        6
 
 

Calculations and Groupings
 
Joins and Subqueries
 

Joins and Subqueries (Exercises)
 
corner piece corner piece

corner piece Weeks 7-9 corner piece
Week Lecture Tutorial/Exercise


        7
 
 

HTML Forms
 

Employee to Project Forms
 


        8
 
 

Introduction to PHP
 
PDO Connection to MySQL
 

PDO Connection to EmployeeProject database
 


        9
 
 

PDO Insert Query
 

Employee PDO Insert (Example)
 
corner piece corner piece

corner piece Weeks 10-12 corner piece
Week Lecture Tutorial/Exercise


        10
 
 

PDO Select Query
 

Employee PDO Select (Example)
 


        11
 
 

PDO Delete and Update Queries
 

Employee PDO Delete (Example)
 
Employee PDO Update (Example)
 


        12
 
 

Database Testing
 
Testing Plan
 
corner piece corner piece


corner piece Links & Addtional Resources corner piece
Links Additional Resouces

ERD (QSEE) tutorial

Introduction to PHP PDO

PDO Connection (Explained)

PHP 5 Forms - Required Fields

PHP Data Objects (PHP.net)

PHP Database Access: Are You Doing It Correctly?

QSEE Superlite (homepage)

QSEE Superlite (zipped folder)

W3Schools (HTML Forms)

W3Schools (PHP Form Validation)

W3Schools (PHP Forms)

W3Schools (SQL Tutorial)

WDT Module Descriptor

 
 
corner piece corner piece

Acknowlegements to: Craig Wilson, Heather Skelton

< Back to Home Page >

Valid XHTML 1.0 Transitional   Valid CSS!   PHP enabled!