Sams Teach Yourself ASP.NET in 21 Days, Second Edition By Chris Payne
Table of Contents
Week 2. At a Glance
Today's lesson discusses database fundamentals what they are, how to create them, and how to use them. This lesson won't be a thorough reference on databases, but it will give you a good background to help build your applications in later lessons.
Databases are incredibly useful tools for storing large amounts of data in efficient ways, and they allow you to view, modify, and work with all types of information. They make ASP.NET applications immensely more useful, as you'll see in the coming few days.
Today's lesson will cover the following:
What databases are
The difference between relational and flat-file databases
How to create your own databases using Access 2000 and SQL Server 2000
How to select, insert, update, and delete data using the Structured Query Language (SQL)