O'Reilly logo

Understanding DB2®: Learning Visually with Examples, Second Edition by Dwaine R. Snow, Michael Dang, Xiaomei Wang, Raul F. Chong

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

Chapter 9. Leveraging the Power of SQL

Structured Query Language (SQL) lets users access and manipulate data in relational database management systems. Now that you have learned about the fundamentals of DB2, this chapter shows you how to leverage the power of SQL to work with relational data that is stored in DB2 databases. The examples provided in this chapter use the sample database. In Chapter 10, Mastering the DB2 pureXML Support, we discuss SQL/XML functions. SQL/XML is an extension of the SQL language that includes support for accessing XML data. You can now issue SQL queries that can access both, relational and XML data. Chapter 8, The DB2 Storage Model, describes the sample database in more detail.

In this chapter you will learn about: ...

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