1 Day Course

Performance-based objectives

• Establish database connectivity.
• Work with recordsets.
• Create interactive page elements.
• Administer database records.
• Create a user authentication system.
• Administer websites.

Prerequisites

This course is intended for website developers, website designers, marketing managers, web graphic artists, website administrators. Before taking this course, the student should complete the following Element K courses, or have equivalent knowledge: Adobe Dreamweaver CS3: Level 1, Adobe Dreamweaver CS3: Level 2, HTML 4.01 Web Authoring & Microsoft Office Access: Level 1.

Course Content

Lesson 1: Establishing Database Connectivity

• 1A: Connect to a Server Using a Server Technology
• 1B: Identify the Components of a Database-Driven Site
• 1C: Create a Connection to a Database

Lesson 2: Working with Recordsets

• 2A: Create Recordsets
• 2B: Display Records
• 2C: Page Through Recordsets

Lesson 3: Creating Interactive Page Elements

• 3A: Create Master and Detail Pages
• 3B: Create Search and Results Pages
• 3C: Use Dynamic Form Elements

Lesson 4: Administering Database Records

• 4A: Insert Records
• 4B: Edit Records
• 4C: Delete Records

Lesson 5: Creating a User Authentication System

• 5A: Create a User Registration Form
• 5B: Secure Web Pages

Lesson 6: Administering Websites

• 6A: Transfer Files to Servers
• 6B: Manage Websites