Chapter 8. Working with Databases

After completing this chapter, you will be able to

  • Describe what a database is and how it is similar to a spreadsheet.

  • Describe database data types.

  • Describe what database tables are and how to define their structure.

  • Create a database, using Database Explorer.

  • Create a table, using Database Explorer.

  • Create columns to represent rows of a table.

  • Create rows in a table.

  • Define Structured Query Language (SQL).

  • Describe how to use the SELECT statements to retrieve data from tables.

  • Describe how to use the WHERE clause to filter data retrieved from tables.

  • Create SQL queries in SQL Query Designer.

All applications begin and end with data. Within applications, data is added, stored, and retrieved. It is the value proposition of ...

Get Microsoft® Visual Web Developer™ 2008 Express Edition Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.