O'Reilly logo

Sams Teach Yourself SQL in One Hour a Day, Fifth Edition by Arie D. Jones, Ron Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required