Databases on the Web
Being able to integrate database technology with the provision of web content is now a common expectation for web site developers. Harnessing these techniques can improve the management, maintenance and scalability of your web sites. This practical workshop teaches you the skills needed to provide web access to existing databases - enabling you to start developing web sites using database-managed content with confidence.
Topics:
- Why is web/database integration important?
- Key methods & processes for web/database interaction
- Active Server Pages (ASP) and ODBC
- Using PHP with MySQL
- Static vs. dynamic pages: database-managed or database-driven?
- Information management issues
Who is it for?
This practical workshop is suitable for anyone who is looking for an understanding of the key skills required to provide web access to database-managed information.
Participants will need to be comfortable working with HTML (including an understanding of HTML forms and basic web publishing) as well as having some knowledge of basic database concepts such as tables, fields, records, keys and SQL.
By the end of the workshop participants will have:
- Explored the potential of web and database integration
- Created static and dynamic web pages from a database
- Used ASP and ODBC to publish database content
- Extracted data from a MySQL database using PHP scripts
- Created web pages to search for information held in a database
