The Web offers all kinds of interesting and fun pages where you can do your shopping, research just about any topic, make travel arrangements,
buy and sell stocks, or even hold a virtual auction.
The ease of navigating through the Web to conduct these online activities conceals the complex engineering that goes on behind the scenes.
A good example is shopping for a new car.
The Web site of the manufacturer lets you view any model in any color, and read about performance, options, and prices.
You can even custom select your favorite model with the desired options and get the sticker price, right down to the penny.
Then you can do some comparison shopping by going to another Web site and finding a dealer with the best price in your area.
Sites such as this frequently query and display data from large databases. This data includes
- audio, and
- even other Web pages.
Most Web sites today incorporate some type of database, from something as simple as text files to very large relational database systems.
Data is what the Web is about. We build Web sites to provide data to our users as well as get data from them in return. Web pages and data are practically synonymous.
This module introduces you to basic database concepts that you will need to understand before adding database functionality to your Web applications created with
Visual Studio. By the time you finish this module, you should be able to do the following:
Visual Studio 2005 Express Edition
Identify table structures used in relational databases
Identify common database systems
Recognize ODBC, ADO, and other database access solutions
Explain what SQL is and what it does
Insert a data source into a project
Bind a database to an environment
In the next lesson, the storage of data will be discussed.