O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

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

Advanced SQL statements

For our last look at SQL, we examine some statements of a more complex nature. It is important to note that these statements do not contain any elements that we haven't already covered. Their complexity derives from the number of elements they contain working together. Decoding and understanding these statements involves the ability to do the following three operations:

  • Recognize the syntax being used
  • Break the statements into component pieces
  • Understand how the different pieces work together

Examining complex statements such as these is good practice for the SQL certification exam. The ability to master them will significantly increase your preparation for the test. Our first example is listed as follows:

If we step back and ...

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