000			03249cam a2200457Ma 4500
001			ocn896850670
003			OCoLC
005			20190328114809.0
006			m o d
007			cr |||||||||||
008			141106s2014 ne o 000 0 eng d
040			_aUKMGB _beng _epn _cUKMGB _dOCLCO _dN$T _dOPELS _dUIU _dOCLCF _dTEFOD _dOCLCQ _dOCLCO _dU3W _dD6H
016	7		_a016941146 _2Uk
016	7		_a016938666 _2Uk
020			_a9780128008300 _q(electronic bk.)
020			_a012800830X _q(electronic bk.)
020			_z9780128007617
020			_z0128007613
035			_a(OCoLC)896850670
050		4	_aQA76.73.S67
072		7	_aCOM _x051170 _2bisacsh
082	0	4	_a005.133 _223
100	1		_aCelko, Joe, _eauthor.
245	1	0	_aJoe Celko's SQL for smarties : advanced SQL programming / _h[electronic resource]
246	3	0	_aSQL for smarties
250			_aFifth edition.
264		1	_aAmsterdam : _bMorgan Kaufmann, _c2014.
300			_a1 online resource.
336			_atext _btxt _2rdacontent
337			_acomputer _bc _2rdamedia
338			_aonline resource _bcr _2rdacarrier
490	0		_aThe Morgan Kaufmann series in data management systems
588	0		_aCIP data; item not viewed.
520			_aSQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You'll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions.
650		0	_aSQL (Computer program language)
650		7	_aCOMPUTERS _xProgramming Languages _xSQL. _2bisacsh
650		7	_aSQL (Computer program language) _2fast _0(OCoLC)fst01102869
655		4	_aElectronic books.
776	0	8	_iPrint version: _z9780128007617
856	4	0	_3ScienceDirect _uhttp://www.sciencedirect.com/science/book/9780128007617
999			_c247008 _d247008