Silicon Valley Code Camp : October 6th and 7th, 2012session
SQL Design Patterns
About This Session
Patterns emerge as both templated solutions to recurring problems and designs, as well as provide useful ways to encapsulate complex ideas into smaller, friendlier terms. Patterns gained popularity in the object-orientated community since the Fowler and the Gang Of Four, but declarative languages, like SQL, have had little-to-no coverage of how these patterns can be applied.
Understanding SQL design patterns is a crucial skill every SQL developer must learn and use in their career. SQL patterns can be applied to small projects or large, multi-million dollar systems, to provide common solutions to complex problems.
Patterns create a foundation for "best practices" for SQL, Database Architecture, and well as management of SQL developers and DBAs.