Sams Teach Yourself SQL in 21 Days, Fourth Edition

Day 14. Creating Views

Today we begin to cover a topic that may be new even to programmers or database users who have already had some exposure to SQL. Days 1 through 8 covered nearly all the introductory material you need to get started using SQL and relational databases. Day 9, “Creating and Maintaining Tables,” was devoted to a discussion of database design, table creation, and other data-manipulation commands. The common feature of the objects discussed so far—databases, tables, records, and fields—is that they are all physical objects that are ultimately located in a data file on a hard disk. Today, the focus shifts to a feature of SQL that provides you with more flexibility as a programmer. This feature is the view. By the end of today, ...