Sams Teach Yourself SQL in One Hour a Day, Fifth Edition

LESSON 13Creating Views

In this lesson we begin to cover a topic that might be new even to programmers or database users who have already had some exposure to SQL. Lessons 1 through 8 covered nearly all the introductory material you need to get started using SQL and relational databases. Lesson 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. In this lesson, the focus shifts to a feature of SQL that provides you with more flexibility as a programmer. This feature is the ...