Web Database Developer

GES 307 -- 200 hours

Course Outline

Outline

Web Publishing and Design with HTML 4.01 and XHTML
1. Getting Organized
2. Basics of HTML and XHTML
3. HTML, XHTML, and Cascading Style Sheets (CSS)
4. Advanced Cascading Style Sheets (CSS), Forms, and DHTML
5. Adding Interactivity and Multimedia with HTML and XHTML
Dreamweaver MX 2004
1. Interface and Web Page Creation Basics
2. Project Planning, Link Creation, and HTML Editing
3. Images, Image Maps, and Assets
4. Tables, Frames, and Framesets
5. Dynamic HTML
6. Advanced Behaviors and Forms
7. Uploading Projects and Working with Templates
Dreamweaver 8
1. New Design Tools
2. New Application Development Features
JavaScript
1. Start Using JavaScript
2. Using JavaScript for Interactivity
3. Using Advanced JavaScript
Dynamic HTML
1. DHTML and Style Sheets
2. Using Javascript
3. Objects and Events
4. Styles and Content
5. Data From Other Sources
AJAX
1. History and Revival of AJAX
2. Introducing JavaScript
3. The XMLHttpRequest Object
4. N-Tier and AJAX
5. Rich Internet Applications
6. CSS and the DOM
7. AJAX Frameworks
8. Understanding an AJAX Library
9. AJAX and Web Services
10. Tagging with AJAX
11. Cloning Google Suggest
12. User Controls and AJAX.NET
13. AJAX and Mapping
14. AJAX and Web Parts
15. AJAX and ASP.NET Security
16. Performance
17. Debugging Your Application
18. AJAX and Site Testing
19. AJAX Usability
20. Atlas
SQL for the Windows Environment
1. Introduction to Databases and SQL
2. Filtering Data
3. Calculations and Functions
4. Summarizing Data
5. Groups and Queries
6. Joins
7. Data and Tables
8. Views and Stored Procedures
9. Transaction Processing and Cursors
10. Advanced SQL Functions
CGI/Perl
1. Getting Familiar with Forms
2. Building Programs
3. Web Applications
4. Interacting with Databases
ColdFusion MX
1. Introduction and Installation
2. Talking With the Database
3. Displaying Data
4. Programming and Application Framework
5. Custom Tags and Building Blocks
6. Using E-mail, Complex Data Types, and FTP
7. Securing, Debugging, and Improving Application Performance
8. Using Flash, Java, and XML
9. Integration and Understanding Fusebox and FLiP
10. Functions, Tags, and Resources
PHP and MySQL
1. Installing Required Software
2. PHP Basics
3. Programming with PHP
4. Creating Dynamic Web Sites
5. SQL and MySQL
6. Advanced SQL and MySQL
7. Error Handling and Debugging
8. Using PHP with MySQL
9. Developing Web Applications
10. Cookies and Sessions
11. Web Application Security
12. Extended Topics
13. Content Management Example
14. User Registration Example
15. E-Commerce Example
Flash MX 2004
1. Using the Interface and Importing Graphics
2. Drawing, Painting, and Using the Library
3. Creating Animation
4. Using Shape Tween and Timeline Effects
5. Using Sound and Layers
6. Adding Symbol and Buttons
7. ActionScript, Behaviors, and Publishing
Flash 8
1. What's New to Basic
2. What's New to Professional
Flash MX 2004 ActionScript 2.0
1. Object-Oriented Programming
2. Properties and Methods
3. Implementing Inheritance and Interfaces
4. Inter-Object Communications
5. Building User Interface Components
XML
1. Viewing and Understanding XML
2. Creating a Basic Document
3. Building DTDs and Checking Documents
4. Entities
5. The Document Object Model
6. CSS and XSL Style Sheets