SQL Clearly Explained
  • Release Date : 28 May 2003
  • Publisher : Elsevier
  • Genre : Computers
  • Pages : 480 pages
  • ISBN 13 : 0123756987
Ratings: 4
From 235 Voters
Get This Book

Download or read book entitled SQL Clearly Explained by author: Jan L. Harrington which was release on 28 May 2003 and published by Elsevier with total page 480 pages . This book available in PDF, EPUB and Kindle Format. SQL 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. Understanding the how as well as the what will aid in creating SQL statements that execute as quickly as possible. The book is organized into five parts. Part I presents the theoretical material underlying relational databases and SQL. Part II covers interactive SQL retrieval. Part III discusses the creation and management of database structure. It also covers non-data elements in the database environment, such as managing users/user accounts and transaction control. Part IV introduces several techniques for SQL programming: embedded SQL (using a high-level host language), dynamic SQL, and triggers/stored procedures. Part V discusses the non-relational extensions that have been added to the SQL standard: XML and object-relational capabilities. It covers object-oriented concepts, including the differences between pure object-oriented databases and object-relational databases. It also looks at SQL's object-relational features. 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

Database Design  Know It All

Database Design Know It All

Author : Toby J. Teorey,Stephen Buxton,Lowell Fryman,Ralf Hartmut Güting,Terry Halpin,Jan L. Harrington,W.H. Inmon,Sam S. Lightstone,Jim Melton,Tony Morgan,Thomas P. Nadeau,Bonnie O'Neil,Elizabeth O'Neil,Patrick O'Neil,Markus Schneider,Graeme Simsion,Graham Witt
Publisher : Morgan Kaufmann
Genre : Computers
Get Book