 |
Integrated Web & Database Design
Integrated Web Design: 1 year - 3 credits
This course is designed to provide students a solid foundation in creating dynamic web sites. Students begin by creating basic web pages using the Dreamweaver MX 2004 suite. As students develop more pages and create an integrated site, they are also introduced to other applications within the suite including Flash and Fireworks.
The second stage of the class involves developing dynamic sites that require a database running behind the scenes. Students learn the basics of SQL (Structured Query Language), with an emphasis on MySQL, as well as some of the basics of PHP. All of these tools build toward the eventual planning and creation of actual database-driven web sites which solve real-world needs. Student projects include conducting interviews and researching the needs of various non-profit groups in the community to develop web sites for them.
Dreamweaver Topics Covered:
- Create hyperlinks between and within documents
- Add images and image maps to web pages
- Create page designs and templates using tables
- Format page contents using Cascading Style Sheets
- Create HTML forms to prompt for user input
- Use frames to segment a browser window
- Add behaviors for interactivity
- Use layers
- Use timelines
- Test and deploy a web site
MySQL Topics Covered:
- Installing MySQL (open source DB)
- Build SQL queries
- Create, modify, and delete a database
- Create, modify, and drop tables
- Add, change, and delete data
- Use MySQL functions
- Manage the MySQL server
- Configure MySQL security
- Use MySQL with PHP
This site is designed and developed by the staff and students at the William D. Ford Career-Technical Center. E-mail questions and comments to wdfordctc@wwcsd.net.