top

Web Authoring (CMS)                                 Loyalist Course Outline         Course Outline
CSS, AJAX, PHP & mySQL Databases 

** Bring Headphones to each class**

1. Designing web pages with CSS   assets  The Box Model |  tutorial-a |  tutorial-b |  tutorial-c
1. Preferences settings
2. Creating an External Style Sheet
3. Using CSS Text Properties, Tag Styles
4. Editing a Style
5. Creating a Class Style
6. Attaching an External Style Sheet

2a. Descendent Selectors    tutorial
1. Customizing Links and Text for seperate DIV IDs

2b. Building CSS Page Layouts   assets     tutorial
1. Creating a centered "Container" with DIV IDs
2. Creating Content Area with DIV IDs
3. Creating a Sidebar with DIV IDs
4. Styling links and text using Descendent Selectors

3. Formatting Links and Spry Menu   assets    tutorial-a |    tutorial-b |  tutorial-c
1. Creating and Formatting Links
2. Adding a Spry Navigation Bar
3. Using CSS to style a Spry Navigation Bar

4. CSS Layout (CS3)    assets   tutorial-a |  tutorial-b |  tutorial-c |   tutorial-d |  tutorial-e text instructions
1. Create file from Dreamweaver's provided CSS layouts
2. Editing and Adding Styles
3. Applying Styles
4. Fine-tuning the Layout
5. Float Conflicts and IE workarounds

4b. CSS Layout using DW layouts (CS5)    assets   tutorial |  tutorial-large
1. Create file from Dreamweaver's provided CSS layouts
2. Editing and Adding Styles
3. Applying Styles
4. Fine-tuning the Layout

5a. mySQL Database Setup   assets (5, 6 & 7)    tutorial
1. Install MAMP (management software)   Download MAMP
2. Basic Web Server Setup
3. Intro to phpMyAdmin
4.Establish secure admin user with phpMyAdmin
5. Establish Database using phpMyAdmin
6. Set up PHP/mySQL Web Site in Dreamweaver
7. Connect to Database in Dreamweaver

5b. Displaying Database Information     tutorial-a |   tutorial-b |   tutorial-c |   tutorial-d |  tutorial-e
1. Create a RECORDSET
2. Live Data View and Creating Repeating Regions
3. Editing a Recordset and Linking to a Detail Page
4. Building the Detailed Product Page
5. Applying Dynamic Data to the Page
6. Create Dynamic Category Menu

6. Creating Admin Pages     tutorial-a |  tutorial-b |  tutorial-c
1. Adding an Insert Product Page
2. Creating and Linking to the Edit Database Records Page
3. Creating and Linking to the Delete Records Page

7. Security and Authentication     tutorial-a |  tutorial-b |  tutorial-c
1. Building a Login Page
2. Password Protecting the Administration Pages
3. Displaying a Portion of a Page to a Logged-in User

** Final Project   final assets  |   criteria   |  phpMyAdmin - Login   | Set-up FTP Account

 



©2008 Daniel Ouellette