Skip to main content

SQL is About Sets

  • Chapter
  • 737 Accesses

Abstract

One of the most difficult transitions to make in order to become highly proficient at writing SQL well is to shift from thinking procedurally to thinking declaratively (or in sets). It is often hardest to learn to think in sets if you’ve spent time working with virtually any programming language. Ifthisisthe case for you, you are likely very comfortable with constructs such as IF-THEN-ELSE, WHILE-DO, LOOP-END LOOP, and BEGIN-END. These constructs support working with logic and data in a very procedural, step-by-step, top-down type approach. The SQL language is not intended to be implemented from a procedural point of view, but from a set-oriented one. The longer it takes you to shift to a set-oriented point of view, the longer it will be before you are truly proficient at writing SQL that is functionally correct and also highly optimized to perform well.

Keywords

  • Venn Diagram
  • Aggregate Function
  • Input Query
  • Procedural Approach
  • Process Flow Diagram

These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • DOI: 10.1007/978-1-4302-3229-2_4
  • Chapter length: 24 pages
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
eBook
USD   39.99
Price excludes VAT (USA)
  • ISBN: 978-1-4302-3229-2
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD   49.99
Price excludes VAT (USA)

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Authors

Rights and permissions

Reprints and Permissions

Copyright information

© 2010 Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, and Jared Still

About this chapter

Cite this chapter

Morton, K., Osborne, K., Sands, R., Shamsudeen, R., Still, J. (2010). SQL is About Sets. In: Pro Oracle SQL. Apress. https://doi.org/10.1007/978-1-4302-3229-2_4

Download citation