SQL Clearly Explained
eBook - ePub

SQL Clearly Explained

  1. 480 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

SQL Clearly Explained

About this book

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.- Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system- Explains use of SQL to enter, modify or delete data to maintain database structural elements- Covers in great detail new SQL application for XML to meet the growing XML usage in development of online content

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.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. 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 SQL Clearly Explained by Jan L. Harrington 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

Publisher
Morgan Kaufmann
Year
2003
eBook ISBN
9780123756985
Edition
3
Topic
Computer Science
Subtopic
Databases
Index
Computer Science

Table of contents

  1. Cover Image
  2. Table of Contents
  3. Front matter
  4. Copyright
  5. Preface to the Third Edition
  6. 1. The Relational Data Model
  7. 2. Relational Algebra
  8. 3. Introduction to SQL
  9. 4. Simple SQL Retrieval
  10. 5. Retrieving Data from More Than One Table
  11. 6. Advanced Retrieval Operations
  12. 7. Working with Groups of Rows
  13. 8. Data Modification
  14. 9. Schemas and Tables
  15. 10. Views, Temporary Tables, CTEs, and Indexes
  16. 11. Keeping the Design Up to Date
  17. 12. Users and Access Rights
  18. 13. Users, Sessions, and Transaction Control
  19. 14. Writing and Executing SQL Routines and Modules—Triggers and Stored Procedures
  20. 15. Embedded SQL
  21. 16. Dynamic SQL
  22. 17. XML Support
  23. 18. The Object-Relational Data Model
  24. 19. Object-Relational Support
  25. Appendix A. Common Acronyms and Abbreviations
  26. Appendix B. SQLSTATE Return Codes
  27. Appendix C. SQL Syntax Summary
  28. Glossary
  29. Index