To design interactive, database-driven Web pages, you need to know how to create HTML forms, design databases/SQL queries, and develop Active Server Pages scripts. Before you learn the details of these technologies, you need to understand how they work together to create an interactive Web application.
After completing this tutorial you should be able to do the following:
Describe the four components of a database-driven, interactive Web site
Explain how these components interact to create a database-driven interactive Web application
Welcome to this new series, Visual Jumpstart Tutorials for Web Designers. We're assuming in this series that you already know how to create static Web pages using HTML and want to take the next step of learning the technologies needed to build interactive, database-driven business and entertainment Web sites.
In our experience, the main concepts you need to understand about databases, SQL, and server-side scripts are not difficult to grasp. What is difficult for most beginners is knowing how these technologies work together to create an interactive, database-driven Web site. Thus, in this first tutorial we focus on showing you how all these different back-end technologies fit together. There are many kinds of databases and server-side scripting languages. Due to their popularity, we'll focus on Microsoft Access databases and Active Server Pages for the server-side scripts, which assumes that you're running a Web server that supports these technologies.