• • 
•  
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Web Database Developer

GES 307 -- 267 hours

Course Outline

I. Web Design & Graphics
a. Introduction to Design
b. Making Your Site Fast and Viewable
c. Building Your Site with Images
d. Building Your Site with Formatting
e. Using Other Tools

II. Web Publishing and Design with HTML 4.01 and XHTML
a. Getting Organized
b. Basics of HTML and XHTML
c. HTML, XHTML, and Cascading Style Sheets (CSS)
d. Advanced Cascading Style Sheets (CSS), Forms, and DHTML
e. Adding Interactivity and Multimedia with HTML and XHTML

III. JavaScript
a. Start Using JavaScript
b. Using JavaScript for Interactivity
c. Using Advanced JavaScript

IV. AJAX
a. History and Revival of AJAX
b. Introducing JavaScript
c. The XMLHttpRequest Object
d. N-Tier and AJAX
e. Rich Internet Applications
f. CSS and the DOM
g. AJAX Frameworks
h. Understanding an AJAX Library
i. AJAX and Web Services
j. Tagging with AJAX
k. Cloning Google Suggest
l. User Controls and AJAX.NET
m. AJAX and Mapping
n. AJAX and Web Parts
o. AJAX and ASP.NET Security
p. Performance
q. Debugging Your Application
r. AJAX and Site Testing
s. AJAX Usability
t. Atlas

V. Dynamic HTML
a. DHTML and Style Sheets
b. Using Javascript
c. Objects and Events
d. Styles and Content
e. Data From Other Sources

VI. SQL for the Windows Environment
a. Introduction to Databases and SQL
b. Filtering Data
c. Calculations and Functions
d. Summarizing Data
e. Groups and Queries
f. Joins
g. Data and Tables
h. Views and Stored Procedures
i. Transaction Processing and Cursors
j. Advanced SQL Functions

VII. CGI/Perl
a. Getting Familiar with Forms
b. Building Programs
c. Web Applications
d. Interacting with Databases

VIII. ColdFusion MX
a. Introduction and Installation
b. Talking With the Database
c. Displaying Data
d. Programming and Application Framework
e. Custom Tags and Building Blocks
f. Using E-mail, Complex Data Types, and FTP
g. Securing, Debugging, and Improving Application Performance
h. Using Flash, Java, and XML
i. Integration and Understanding Fusebox and FLiP
j. Functions, Tags, and Resources

IX. PHP and MySQL
a. Installing Required Software
b. PHP Basics
c. Programming with PHP
d. Creating Dynamic Web Sites
e. SQL and MySQL
f. Advanced SQL and MySQL
g. Error Handling and Debugging
h. Using PHP with MySQL
i. Developing Web Applications
j. Cookies and Sessions
k. Web Application Security
l. Extended Topics
m. Content Management Example
n. User Registration Example
o. E-Commerce Example

X. XML
a. Viewing and Understanding XML
b. Creating a Basic Document
c. Building DTDs and Checking Documents
d. Entities
e. The Document Object Model
f. CSS and XSL Style Sheets

XI. SQL Server 2005 MCTS 70-431
a. Installing and Configuring SQL Server 2005
b. Creating Databases
c. Working with Tables and Programmability Objects
d. Implementing Database Objects
e. Supporting the XML Framework
f. Enhancing Data Consumption and Throughput
g. Maintaining and Backing Up Databases
h. Monitoring Performance
i. Troubleshooting and Optimizing
j. Implementing High Availability
k. Practice Exams

XII. Oracle 10g Administration
a. Oracle Architectural Components
b. Oracle Server Introduction
c. Database Architecture, Creation, and Interfaces
d. Database Control and Storage Structures
e. Managing Users and Schemas
f. Data Management
g. PL/SQL
h. Database Security Management
i. Oracle Net Services
j. Oracle Shared Server
k. Database Performance Monitoring
l. Database Maintenance
m. Database Undo Management
n. Database Locking Conflicts
o. Database Backup and Recovery Concepts
p. Database Backups
q. Database Recovery