SQL Clearly Explained

Specificaties
Paperback, blz. | Engels
Elsevier Science | e druk, 2010
ISBN13: 9780123756978
Rubricering
Juridisch :
Elsevier Science e druk, 2010 9780123756978
Verwachte levertijd ongeveer 9 werkdagen

Samenvatting

SQL Clearly Explained, Third Edition, provides an in-depth introduction to using SQL (Structured Query Language). Readers will learn not only SQL syntax, but also how SQL works.

Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. As a result, the set of standard SQL commands has been greatly extended and this new edition takes that into account.

This new edition includes updated tips and tricks to reflect the current concepts of SQL and XML standards; several new chapters covering object-relational and XML extensions; and an ancillary package that includes case studies, a syllabus, exams and more.

This book is intended for working SQL programmers, database administrators, database designers, database analysts, and application system developers as well as those who are developing new features for database management systems who want to know about user needs. This would include anyone working with electronic content in the relational database context but also XML. Web services, etc.

Specificaties

ISBN13:9780123756978
Taal:Engels
Bindwijze:Paperback

Inhoudsopgave

<p>1. The relational data model2. Manipulating relations with relational algebra3. Introduction to SQL4. Simple SQL retrieval5. Retrieving data from more than one table6. Advanced retrieval operations7. Calculations and grouping queries8. Data Modifications9. Schemas and tables10. Views, temporary tables, CTEs and indexes11. Keeping the design up to date12. Users and access rights13. Users, sessions, and transaction manipulation14. Triggers and stored procedures15. Embedded SQL16. Dynamic SQL17. XML support18. The object-relational data model19. Object-relational support</p>

Net verschenen

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        SQL Clearly Explained