
- 562 pages
- English
- PDF
- Available on iOS & Android
eBook - PDF
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.
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.
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
- Front Cover
- Advanced SQL: 1999 Understanding Object-Relational and Other Advanced Features
- Copyright Page
- Foreword
- Contents
- Preface
- Chapter 1. Introduction to SQL:1999
- Chapter 2. User-Defined Types
- Chapter 3. Typed Tables
- Chapter 4. Routines and Routine Invocation
- Chapter 5. Foreign Servers and Foreign-Data Wrappers
- Chapter 6. Datalinks
- Chapter 7. OLAP
- Chapter 8. SQL/OLB and SQL/JRT
- Chapter 9. SQL/XML
- Chapter 10. SQL Multimedia and Application Packages
- Chapter 11. A Look to the Future
- Appendix A. An SQL:1999 Example Using UDTs
- Appendix B. The SQL: 1999 Annexes
- Appendix C. Relevant Standards Bodies
- Appendix D. Status Codes
- Appendix E. The SQL Standardization Process
- Index
- About the Author