LESSON 20New Objects in the Latest Standard

In this lesson, you learn some of the features and concepts that were added recently to the SQL standard. Although there are many enhancements to the general SQL syntax, this lesson discusses only the more predominant enhancements.

By the end of this lesson, you should have an understanding of the following:

• New features in the SQL standard

• Basic syntax of the new features

• Basic concepts of the new features

TIP

The new features mentioned in this lesson have already been introduced in most relational database management systems (RDBMSs). Some of these topics have been discussed in previous lessons. This lesson has been added to clarify major additions to the objects in the SQL standard. There ...

Get Sams Teach Yourself SQL in One Hour a Day, Fifth Edition 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.

Start your free trial