By Jim Melton
Advanced SQL:1999 - figuring out Object-Relational and different complicated Features is the practitioner's instruction manual to the standard's complex positive aspects. it's not a re-presentation of the normal, yet quite an authoritative, in-depth advisor to its sensible program. Like its better half, SQL:1999 - realizing Relational Language Components, which defined the standard's easy gains, this ebook will help you make your functions either powerful and standard-compliant.
This convenient reference has a modular structure so that you can discover particular themes comfortably. it really is both precious to these upgrading from prior models of SQL and people with out past adventure. Written by means of the standard's uncommon editor, Advanced SQL:1999 will whole your wisdom and aid your abilities like no different ebook can.
* Focuses solely at the concerns that topic to programmers who're connecting purposes to databases.
* info SQL:1999's item amenities, together with established user-defined varieties, typed tables, user-defined exercises, and regimen invocation.
* Examines amenities new to SQL, together with these when it comes to online analytical processing (OLAP), administration of exterior info (SQL/MED), and Java support.
* Covers the continuing improvement of XML support.
* contains appendices that disguise the SQL:1999 annexes, a SQL:1999 instance utilizing UDTs, prestige codes, and beneficial details at the standardization process.
Read or Download Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features (The Morgan Kaufmann Series in Data Management Systems) PDF
Best Sql books
Offering info for database directors and alertness builders, this e-book is a step by step consultant to studying program improvement and process administration with SQL, writing effective SQL code, and fine-tuning server functionality. The CD-ROM comprises an evaluate reproduction of SQL Server 7.
Write strong SQL statements and PL/SQL programsLearn to entry Oracle databases via SQL statements and build PL/SQL courses with tips from Oracle specialist, Jason fee. released via Oracle Press, Oracle Database 11g SQL explains tips to retrieve and alter database details, use SQL Plus and SQL Developer, paintings with database items, write PL/SQL courses, and lots more and plenty extra.
The former version of this booklet verified itself because the such a lot entire and comprehensible remedy of the SQL normal quite often on hand. Many alterations have happened within the SQL criteria international for the reason that that variation used to be released, even if: an enormous new part, the Call-Level Interface (SQL/CLI), used to be additional in 1995.
The necessity to deal with more and more greater info volumes is one issue riding the adoption of a brand new type of nonrelational “NoSQL” databases. Advocates of NoSQL databases declare they are often used to construct structures which are extra performant, scale larger, and are more straightforward to application. NoSQL Distilled is a concise yet thorough advent to this speedily rising know-how.
Additional info for Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features (The Morgan Kaufmann Series in Data Management Systems)