Building Data-Driven Websites with Adobe Dreamweaver

Building Data-Driven Websites with Adobe Dreamweaver online course
Class Name

Building Data-Driven Websites with Adobe Dreamweaver

Dreamweaver has the ability to add PHP or ASP code to your pages that lets them communicate with a database. Dreamweaver code can display dynamic data from the database on a Web page. It can also use forms to add data to the database or to update the data that is already there. Dreamweaver can also create login pages that restrict access to administrative pages. A Web designer can use Dreamweaver to create dynamic pages by completing simple dialog boxes. It's not necessary to know how to write the code.

Knowing how to use the dynamic functions of Dreamweaver opens up an whole new realm of possibilities in Web design. You can display a product catalog with list and display pages, and provide a backend for the site owners to update the product information themselves. Using data driven Web pages can save a countless hours in the creation and maintenance of a Web site. For instance, you could have a site on golf courses in Southern California. If you were building a static site, the site would would have hundreds of pages. If there were 400 courses, you would need a information page for each one, and also several list pages that listed courses in different areas. However, if you build this site with a database, you would have a home page, where the visitor could select the area he wanted to know about. A list page that listed golf courses in the chosen area, and page that listed the details about the particular course the visitor chose on the list page. That's 3 pages, instead of over 400.

You can do other things with databases, as well. You can create forms for Web visitors to fill out. They can RSVP to event invitations and choose their meal preference or T-Shirt size. They can add items to their wish lists or vote on an important issue. The possibilities are endless. Once you see how easy this is to do, you'll be finding ways to use it in almost every site you build.

Objectives
  • Configuring Dreamweaver to work with databases
  • Establishing a database connection from a Web page
  • Displaying content from databases on Web pages
  • Creating Web-based forms that add, modify and delete records in a database
  • Protecting access to Web pages using usernames and passwords

Applicable Job Roles: Web designers who don't know how to hand code server side languages that communicate with databases will be able to add to their Web design skills.

Outline
Week 1
  • How Dynamic Sites Work
  • Choosing a Server Model and Host
  • Setting Up the Site in Dreamweaver
  • Forms Review
Week 2
  • Passing Data from Page to Page
  • Intro to Database Basics
  • Preparing the Database
Week 3
  • Connecting to the Database
  • Retrieving Information from the Database
  • Displaying Data on the Page
  • Master-Detail Pages
  • Recordset Navigation
Week 4
  • Forms that Add Data to a Database
Week 5
  • Forms that Update Data Already in the Database
  • Dynamic Form Fields
  • Deleting Data from the Database
Week 6
  • Password Protecting Web Pages
  • Login Pages
  • Logout Function
Prerequisites
Introduction to Dreamweaver course or equivalent knowledge/experience. Advanced Dreamweaver is also helpful.
Requirements
  • Software: Dreamweaver CS5, CS5.5 or CS6 running on either a Windows or Macintosh computer.
  • Website: Students will need to have a Website that supports either PHP with MySQL or ASP with Access. More will be explained about this during the first week of class.
Class Books
Course Price
  • Member Price: $100 US
  • Non-Member Price: $200.00 US
[Register Now]

Additional Information:
Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training.

Refund Policy: Please read our "Terms and Refund Policy" before registering for this course.

Additional Cost: Book and software migh be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

Start Date: Click on the Register Now button to process to the registration page. You will see the start date of the class on that page.

How eClasses Work:Instructors post lectures, reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class. Web Study certificate is also available. Click on the Certificates link on the top navigation bar for more information.

 

Register Now

  • Member Price: $100 US
  • Non-Member Price: $200.00 US
  • Web Course No: A133
  • Instructor: Judy Fontanella
  • Co-instructor/TA:
  • CEUs: 3
  • Duration: 6 weeks
  • Session Open for Registration
Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.


4 Web Study Certificates

 Valid XHTML 1.0!  Valid CSS1!  Level Triple-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Intro to DreamweaverAdvanced DreamweaverBuilding Data-Driven Websites with Adobe Dreamweaver
Advanced Adobe FlashIntro to FlashAdobe Fireworks
Adobe Flash Level IIWeb VideographyContracting Your Services
Intro to Apache AdministrationBlog and Article WritingWeb Content Writing
Intro to DNSIntro to UNIXIntro to Web Analytics
WordPress Theme DesignIntro to WordPressIntro to Drupal
Project ManagementIntro to Joomla!Intermediate Joomla!
Logo DesignWebsite Project ManagementLegal Issues for Web Designers and Content Managers
Search Engine OptimizationWebsite PromotionEmail Marketing and Strategies
Social Media MarketingIntro to Designing Accessible WebsitesDesign Concepts
Intro to Web DesignIntro to Adobe MuseMobile Application UI Design
Photoshop Level 1Photoshop for the WebPhotoshop Retouching
InDesign Level 1Adobe IllustratorAdobe Illustrator Level 2
Intro to Adobe Edge AnimateIntro to HTMLHTML Level 2
Mobile Web DesignHTML5 IntroIntro to Cascading Style Sheets
Intermediate CSS WorkshopCSS 2.1 in DepthIntro to CSS3
Intro to XHTMLIntro to Database DesignIntro to SQL (Using Access)
Intro to SQL (Using MySQL)MySQLIntro to SQL Server
Intro to Programming ConceptsIntro to PHPShopping Cart Using PHP and MySQL
Intro to JSPIntro to ColdFusion Web DevelopmentIntermediate ColdFusion
Intro to JavaScriptIntermediate JavaScriptIntro to AJAX
Intro to jQueryJava for Non-ProgrammersProgramming in Java - Intro
Intermediate Java ProgrammingIntro to PerlIntro to C#
Intro to ASP.NET Web Development with C#Intro to Visual Basic.NETIntro to ASP
Intermediate ASPIntermediate ASP.NET Web Development with C#Intro to Web Security
Intro to XMLIntermediate XMLIntro to Android App Development
Intro to Game ProductionIntro to Game Design and DevelopmentIntro to Flash Game Programming
Intro to C++ Using GamesIntro to Windows Game Programming Using C++3D Game Programming Using DirectX