Advanced SQL:1999
eBook - PDF

Advanced SQL:1999

Understanding Object-Relational and Other Advanced Features

  1. 562 pages
  2. English
  3. PDF
  4. Available on iOS & Android
eBook - PDF

Advanced SQL:1999

Understanding Object-Relational and Other Advanced Features

About this book

Advanced SQL:1999 - Understanding Object-Relational and Other Advanced Features is the practitioner's handbook to the standard's advanced features. It is not a re-presentation of the standard, but rather an authoritative, in-depth guide to its practical application. Like its companion, SQL:1999 - Understanding Relational Language Components, which explained the standard's basic features, this book will show you how to make your applications both effective and standard-compliant.This handy reference has a modular format so you can explore specific topics with ease. It is equally useful to those upgrading from earlier versions of SQL and those with no previous experience. Written by the standard's distinguished editor, Advanced SQL:1999 will complete your knowledge and support your skills like no other book can. - Focuses entirely on the issues that matter to programmers who are connecting applications to databases. - Details SQL:1999's object facilities, including structured user-defined types, typed tables, user-defined routines, and routine invocation. - Examines facilities new to SQL, including those relating to on-line analytical processing (OLAP), management of external data (SQL/MED), and Java support. - Covers the ongoing development of XML support. - Includes appendices that cover the SQL:1999 annexes, a SQL:1999 example using UDTs, status codes, and useful information on the standardization process.

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Advanced SQL:1999 by Jim Melton in PDF and/or ePUB format, as well as other popular books in Computer Science & Databases. We have over one million books available in our catalogue for you to explore.

Information

Table of contents

  1. Front Cover
  2. Advanced SQL: 1999 Understanding Object-Relational and Other Advanced Features
  3. Copyright Page
  4. Foreword
  5. Contents
  6. Preface
  7. Chapter 1. Introduction to SQL:1999
  8. Chapter 2. User-Defined Types
  9. Chapter 3. Typed Tables
  10. Chapter 4. Routines and Routine Invocation
  11. Chapter 5. Foreign Servers and Foreign-Data Wrappers
  12. Chapter 6. Datalinks
  13. Chapter 7. OLAP
  14. Chapter 8. SQL/OLB and SQL/JRT
  15. Chapter 9. SQL/XML
  16. Chapter 10. SQL Multimedia and Application Packages
  17. Chapter 11. A Look to the Future
  18. Appendix A. An SQL:1999 Example Using UDTs
  19. Appendix B. The SQL: 1999 Annexes
  20. Appendix C. Relevant Standards Bodies
  21. Appendix D. Status Codes
  22. Appendix E. The SQL Standardization Process
  23. Index
  24. About the Author