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.