Table of Contents
Introduction.
WEEK 1. LEARNING ULTRADEV'S HTML TOOLS AND DYNAMIC SITE
BASICS.
Day 1. The UltraDev Interface.
The UltraDev Interface. The Menu System. The Document Design
Window.Manipulating Objects. Design Size. Download Time and Page
Size. Customizing the Document Design View.The Tool Palettes.The
HTML Objects. The Properties Palette. The Other Windows and
Palettes.Direct Access to the HTML.Transferring Selections Between
Views. Line Options. Referencing Tag Information. Searching
Features. Launching an External Editor.Customizing the UltraDev
Preferences. Summary. Q&A. Workshop.Quiz. Exercises.
Day 2.
Using the UltraDev WYSIWYG Layout Tools.
Creating Your First Web Site.Defining a Site.Design
Considerations.Know Your Customer. Plan for the Lowest Common
Denominator. Keep It Clean.Common Objects and Page Elements.Making
a Link. Editing the Head. Common Page Attributes. Previewing Your
Work. Spell Checking.Tables.Inserting a Table. Image and Text
Layout. Using the Table Layout Mode.Navigation Buttons and
Bars.Lists of Links. Images and Image Maps. Rollover Images.
Rollover Navigation Bars.Layers.Precise Positioning with Layers.
Layers to Tables, and Vice Versa.Persistent Elements with
Frames.Defining a Frameset. The Frames Palette. The NoFrames
Content. Complex Framesets. To Frame or Not To Frame?Forms.
Checking Your Code. Reporting. Summary. Q&A. Workshop.Quiz.
Exercises.
Day 3. Planning and Managing a Web Site.
Site Planning.Site Maps. Naming Conventions.The UltraDev Site Map
Tools.Using the Site Map on Existing Web Sites. Using the Site Map
on New Web Sites.Bringing an Existing Site into UltraDev.Accessing
Your Data. Setting Up Your Connection. Using the
Connection.Maintaining Your Site.Link Verification.A Distributed
Editing Environment.Enabling Check In and Check Out. Using the
Check In/Out System. Design Notes.Summary. Q&A. Workshop.Quiz.
Exercises.
Day 4. Web Sites with Action-Client-Side
Behaviors.
DHTML-What It Is and Isn't.Style Sheets. JavaScript. The DHTML
Problem. To “D”(HTML) or Not to “D”(HTML)?Introducing Client
Behaviors.The Behavior Palette. Creating a Behavior. Creating a
Status Bar Behavior. Creating Pop-Up Help. Pop-Up Browser Windows.
Drag and Drop on a Web Page?Using Timelines.The Timelines Palette.
Setting Animation Keyframes. Easily Defining a Complex Path.
Additional Timeline Functions.Instant Flash.Flash Buttons. Flash
Text.Other Dynamic Elements. Advanced JavaScript Programmers.
Summary. Q&A. Workshop.Quiz. Exercises.
Day 5. Reusable
Components and UltraDev Packages.
Code Reuse.Repetitive Formatting-Style Sheets. Common Components.
Templates.HTML Styles. Cascading Style Sheets.Working with Style
Sheets.Libraries.Creating a Library Item from Existing HTML. The
Site Asset Palette-Libraries. Creating a Library Item from
Scratch.Template Files.Creating a Template from an Existing Page.
The Site Asset Palette-Templates. Creating a Template from Scratch.
Got Template?Asset Manager.Asset Manager Views.Extending
UltraDev.Recording Commands. Recording Temporary Commands. Download
UltraDev Packages.Summary. Q&A. Workshop.Quiz. Exercises.
Day
6. Introduction to Dynamic Web Applications and Database
Design.
Dynamic Web Sites.Traditional Web Application Programming. HTML
Embedded Languages.Understanding Dynamic Sites.Variable Passing.
Cookies.Creating Dynamic Sites.Types of Dynamic Sites. Planning for
Dynamic Sites.Database Design.Data Modeling Terminology. A
Normalization Example. From Model to Database.Summary. Q&A.
Workshop.Quiz. Exercises.
Day 7. Understanding the Supported
Scripting Languages.
The UltraDev Languages.Active Server Pages. Java Server Pages.
ColdFusion.Choosing a Server.User Friendliness. Type of Services
Offered. Reliability. Performance/Cost Ratio. Support. The Final
Decision.Inside the Supported Languages.Programming
Concepts.Summary. Q&A. Workshop.Quiz. Exercise.
Week 1. In
Review.
WEEK 2. BRING THE WEB TO LIFE.
Day 8. Setting Up Macintosh and Windows Systems for Database
Interaction.
The Database Connection.Setting Up a Database Connection
(Macintosh/Windows).The Java-ODBC Connection (Macintosh/Windows
NT).Setting Up the Macintosh JDBC Client Driver. Configuring the
Windows NT JDBC-ODBC Server.Setting Up MySQL.Setting Up MySQL for
Windows. Setting Up MySQL for Unix Systems. Testing the MySQL
Server. Setting Up an ODBC Data Source to MySQL.Setting Up an ODBC
Data Source to Microsoft Access. Summary. Q&A. Workshop.Quiz.
Exercises.
Day 9. Introducing the UltraDev Dynamic Tools.
Traditional Databases on the Web.Connections. Server Behaviors.
Standard Server Behaviors. The Online Difference. Additional Server
Behaviors.Data Bindings.Dynamic Data. Design View Bindings.User
Authentication.Log In User. Restrict Access To Page. Log Out User.
Check New Username.Advanced Technique: Editing/Creating Server
Behaviors. Summary. Q&A. Workshop.Quiz. Exercises.
Day 10.
Creating Database-Driven Screens.
Database-Driven Screens. A Simple Table.Creating the Back End.
Developing the UltraDev Front End.Adding Graphics to the
Recordset.An Image-Ready Database Back End. Adding a Dynamic Image
to the Design.Prettifying the Display. Dynamic Attributes and
Complex Displays.An Extended Database Back End.Additional
Functionality on Dynamic Screens.Sorting.Summary. Q&A.
Workshop.Quiz. Exercises.
Day 11. Storing, Editing, and Updating
Data from an UltraDev Application.
Online Data Manipulation. Creating Online Forms.Creating a Simple
HTML Form. Text Fields. Submit Buttons.Adding an Insert Action.
Detail Screens and Record Deletion.Detail Screens. Deleting
Records. Linking to a Detail Screen.Update Screens.Creating Dynamic
Forms. Dynamic Forms Through Server Behaviors. Dynamic Form
Elements Through Properties.Auto-Generating Forms and
Screens.Master-Detail Pages. Record Insert Forms. Record Update
Forms. Making the Final Connection.Summary. Q&A. Workshop.Quiz.
Exercises.
Day 12. Writing Advanced Database Queries.
Why We Need SQL. The Database Objects. Creating Databases and
Tables.Datatypes.Adding/Changing Data.Updating Data. Deleting
Data.Querying Database Tables.Sorting Information. Joining Tables.
Summarization Tools.Other Advanced Techniques.Views. Stored
Procedures. Sub-queries.Advanced Queries and UltraDev. Summary.
Q&A. Workshop.Quiz. Exercise.
Day 13. Advanced Components:
Catalogs, Searches.
A Product Catalog.Product Categories. Catalog Items. Related Items.
The SQL. The SQL Queries.Designing the Catalog.Search Form. Search
Results.Automating the Navigation Bar.Navigation Status. Navigation
Bars.Summary. Q&A. Workshop.Quiz. Exercises.
Day 14. Advanced
Components: User Logins.
Login Systems.HTTP Authentication. Web-Based Login.The SQL. A
Simple Login.Processing the Login Information.Maintaining a
Session.Variable Passing. Variable Passing Continued. Moving to a
Related Page.Time for Cookies.Setting a Session Variable. Using
Session Variables. Session Variables in Queries.The UltraDev
Authentication System. Real Web Site Security. Summary. Q&A.
Workshop.Quiz. Exercises.
Week 2. In Review.
WEEK 3. DEVELOPING ADVANCED WEB APPLICATIONS.
Day 15. Advanced Techniques: Converting Existing Web Sites to
Use Dynamic Tools.
Making the Static-to-Dynamic Transition. Randomizing Banner
Ads.Table Definitions. Sample Data. The SQL Query.
Implementation.Seasonal/Time-Based Images.Table Definition. The
SQL. Multiple Seasonal/Time-Based Images.Getting Your User's
Feedback.The Table Definition. The SQL.Creating the HTML. Summary.
Q&A. Workshop.Quiz. Exercises.
Day 16. Advanced Techniques:
Data Collection and Reporting.
Input and Output, a Messaging System Overview.Defining the Site
Map. Creating the SQL.Building the Main List View.Creating the
Message Listing. Sorting the Message List. Adding Parameters to the
Go To Related Page Behavior. Searching the Message Listing.Reading
Messages.Creating the Recordsets. Laying Out the Page. Message
Deletion. Wrapping Up the Viewing Screen.The Composition
Screen.Adding the Hidden Fields. Saving the Message.Summary.
Q&A. Workshop.Quiz. Exercises.
Day 17. Advanced Techniques:
Tracking and Using User Data.
Customized Web Sites.Configurable Web Site Map.Table
Definitions.User Authentication and Preferences. Features and
Options. An Optimized Structure. Seeding the Available Options.
Default Preferences.The Registration and Login System.The
Registration Pages. The Login Pages.The Content Screen. The
Preferences. Summary. Workshop. Q&A.Quiz. Exercises.
Day 18.
Advanced Techniques: Complex Query Systems.
Complex Searches.Thresholds. Weighing Responses.The Site Map. The
Table Definitions.The UserInfo Table. The Options Table. Inserting
Sample Data.The Login System.Registration and Initial Profile.Login
Screens. Creating the Update Profile Page. The Search and Results
Pages. Protecting Your Pages. Summary. Q&A. Workshop.Quiz.
Exercises.
Day 19. Advanced Techniques: Testing and Educating
Online.
Survey and Testing Systems.The Site Map. Creating the SQL.Building
the Login Screen. Creating the Quiz Form.Skipping Questions.
Dynamic Answers. Saving the Response. Measuring Correct Responses
(Optional). Ending the Quiz. Protecting the Quiz.Administrative
Access.Creating the Results Screen.Summary. Q&A. Workshop.Quiz.
Exercises.
Day 20. Advanced Techniques: E-Commerce
Solutions.
The Simply Complex.Shopping Based on a Session ID. User Accounts.
Our “Perfect” Approach. An E-Commerce Site Map.The Table
Definitions.Product Categories. Catalog Items. Related Items. User
Information. Shopping Cart Information.The Catalog System.Search
Form. Search Results. Detail Screens. Related Items. Cleaning Up
the Display.The User Authentication System.The Registration Pages.
The Login Screens.The Shopping Cart. The Checkout System.The
Shopping Cart View. The Final Checkout. The Finished Page.Summary.
Q&A. Workshop.Quiz. Exercises.
Day 21. Testing and Deploying
Dynamic Applications.
Coding Problems. HTML Design Errors.Forms. Layers.Server Behavior
Problems.Leftovers. Advanced Queries. Keep It Simple.Testing.Check
for NULL Values. Validate Using Duplicate Data. Test Maximum
Lengths.Additional Troubleshooting Resources. Summary. Q&A.
Workshop.Quiz. Exercise.
Week 3. In Review.
Appendix A. Quiz Answers.
Appendix B. Customizing the UltraDev Environment.
Menus. Dialog Boxes and Windows.
Appendix C. MySQL Quick Function
Reference.
Common Data Types. Arithmetic Operations. Logical Operations.
Numeric Comparisons. String Comparison Functions. Mathematical
Functions. String Functions.Date and Time Functions.Summarization
Functions for Use with GROUP BY Clauses.
Appendix D. Custom Code
Listings.
Day 15-The Guestbook (guestbook.asp). Day 16-Message List
(index.asp). Day 16-Message Reading (message.asp). Day 17-Login
Page (login2.asp). Day 17-Content Page (content.asp). Day 19-Quiz
Question Screen (quiz.asp). Day 20-Add To Cart (details.asp). Day
20-Deleting Items from the Cart (checkout.asp). Day 20-Final
Checkout (checkout2.asp).
Index.Promotional Information
Sams Teach Yourself Dreamweaver UltraDev 4 in 21 Days teaches you
all the skills you need to get up and running effectively with
Dreamweaver UltraDev 4. The tutorial approach aids you in learning
the basics quickly and then moves on to the more advanced features
and concepts. By the end of the 21 days, you will know how to
create dynamic Web sites containing database interactivity,
streamline ASP content, write custom validations and extend
functionality with JavaScript, design enhanced navigation of the
Web site, and incorporate interactivity. Written by leading trainer
and developer John Ray, you will benefit from expert tips for more
effective site design.
About the Author
John Ray is an award-winning Web application and network
developer for the Ohio State University. He holds a computer
engineering degree from OSU and oversees network operations for one
of its colleges. There, he implemented a campus-wide database for
maintaining TCP/IP information for a wide range of networked
computers. For the past five years, John has used Linux exclusively
for his programming efforts and has championed its use for projects
inside and outside the university. He provides Linux- and
UNIX-based TCP/IP programming solutions to businesses nationwide.
His other publications include Que's Red Hat Installation and
Configuration Handbook, Linux Maximum Security, and Special Edition
Using TCP/IP, and Sams Teach Yourself Linux in 10 Minutes.