O'Reilly logo

Joe Celko's SQL for Smarties, 4th Edition by Joe Celko

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

6

Procedural, Semiprocedural, and Declarative Programming

This chapter is about programming and your mindset. SQL allows procedural code modules to be kept in the schema and will work inside procedural host languages. Avoid programming SQL as if it is a procedural file system language—SQL is a declarative language and requires a different mindset.

6.1 Basics of Software Engineering

The basics of software engineering do not change in SQL. They are realized differently. Most of us (with the exceptions of those rare programmers who started in LISP, APL, FP, Haskell, or other exotic languages) learned a block structured programming language that evolved from Algol-60. The same principles that apply to procedural code still apply to them.

In the late ...

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