- Out-of-Stock
SQL Clearly Explained
ID: 175032
Jan Harrington
Although the core of the SQL language is relatively unchanged, the most recent version of SQL (2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. The second edition of this book contains some material about the object-relational extensions. However, that set of commands has to be added to the account. The XML extensions are completely new to the third edition. A chapter on basic relational concepts.
All of the chapters will be revised to be sure they are up to date. Chapter 10 ("Views, Temporary Tables, and Indexes") from the second edition will be expanded to include common table expression (CTEs). The material in the existing Chapter 14 ("Unimplemented SQL-92 Features 251") will be disbursed through the chapters. While the contents of the SQL chapter, the most important part of the SQL language can be found.
There are two NEW chapters at the beginning of the book. Chapter 1 (The Relational Data Model) covers the relational data model conceptual material; Chapter 2 ("Manipulating Relations with Relational Algebra") covers the relational algebra that will be pulled from the retrieval chapters. Part 5 ("Non-relational SQL Extensions") will now include the non-relational SQL extensions in three chapters. Chapter 17 (NEW) will cover XML. Chapter 18 will contain the object-relational conceptual chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. (Some of chapter 19 will be added to the second edition, however, it is added to the current standard. The other is chapter 14, which covers triggers and stores procedures. This material was missing from previous editions. Many readers should find it a useful addition.
- Demonstrates how to formulate SQL queries and how queries are processed to maximize the performance of the database management system
- Explains use of SQL to enter, modify or delete data to maintain database
- Covers in great detail new XML application for XML to meet the growing
Chapter 1: The relational data model
Chapter 2: Manipulating relations with relational algebra
Chapter 3: Introduction to SQL
Chapter 4: Simple SQL retrieval
Chapter 5: Retrieving data from more than one table
Chapter 6: Advanced retrieval operations
Chapter 7: Calculations and grouping queries
Chapter 8: Data Modifications
Chapter 9: Schemas and tables
Chapter 10: Views, temporary tables, CTEs and indexes
Chapter 11: Keeping the design up to date
Chapter 12: Users and access rights
Chapter 13: Users, sessions, and transaction manipulation
Chapter 14: Triggers and stored procedures
Chapter 15: Embedded SQL
Chapter 16; Dynamic SQL
Chapter 17: XML support
Chapter 18: The object-relational data model
Chapter 19: Object-relational support
175032
Other products in the same category (16)
The Analog Training Board evaluation and training kit for designers interested in modern analog components from the Analog Devices offer
Retired
No product available!
Odroid N2 4 GB CoreELEC Edition is a ready-made kit that allows you to build a home entertainment center (media center), based on the ODROID N2 minicomputer with 4 GB of RAM.
Retired
No product available!
Industrial microSD UHS-1 memory card with a capacity of 8GB for ODROID N2 with pre-loaded Linux software.
Retired
No product available!
Panasonic Eneloop PRO R6/AA rechargeable batteries with a minimum capacity of 2500mAh and a voltage of 1.2V. The set contains four pieces sold in a reusable packaging. Panasonic BK-3HCDE/4LE
Retired
No product available!
Panasonic Eneloop PRO R03/AAA rechargeable batteries with a minimum capacity of 930mAh and a voltage of 1.2V. The set contains four pieces sold in a reusable packaging. Panasonic BK-4HCDE/4LE
Retired
No product available!
Panasonic Eneloop PRO R6/AA rechargeable batteries with a capacity of 2000mAh and a voltage of 1.2V. The set contains four pieces sold in a reusable packaging. Panasonic BK-3MCCE/4LE
Retired
No product available!
Panasonic Eneloop PRO R6/AA rechargeable batteries with a capacity of 2000mAh and a voltage of 1.2V. The set contains eight pieces sold in a reusable packaging. Panasonic BK-3MCCE/8LE
Retired
No product available!
Panasonic Eneloop R03/AAA rechargeable batteries with a capacity of 800mAh and a voltage of 1.2V. The set contains four pieces sold in a reusable packaging. Panasonic BK-4MCCE/4LE
Retired
No product available!
Panasonic Eneloop R03/AAA rechargeable batteries with a capacity of 800mAh and a voltage of 1.2V. The set contains eight pieces sold in a reusable packaging. Panasonic BK-4MCCE/8LE
Retired
No product available!
Universal Panasonic Eneloop R6/AA and R03/AAA battery box in blue. Panasonic BQ-CASEL/1E
Retired
No product available!
Panasonic Eneloop PRO R6/AA rechargeable batteries with a capacity of 2000mAh and a voltage of 1.2V. The set contains two pieces sold in a blister packaging. Panasonic BK-3MCCE/2B
Retired
No product available!
Panasonic Eneloop PRO R6/AA rechargeable batteries with a capacity of 2000mAh and a voltage of 1.2V. The set contains four pieces sold in a blister packaging and a plastic case. Panasonic BK-3MCCEC4B
Retired
No product available!
Panasonic Eneloop R03/AAA rechargeable batteries with a capacity of 800mAh and a voltage of 1.2V. The set contains two pieces sold in a blister packaging. Panasonic BK-4MCCE/2BE
Retired
No product available!
Panasonic PRO R6/AA rechargeable batteries with a capacity of 2700mAh and a voltage of 1.2V. The set contains four pieces sold in a blister packaging. Panasonic BK-3HGAE/4BE
Retired
No product available!
The BQ-CC55 microprocessor charger designed for quick charging of R6/AA or R03/AAA NiMH batteries. It has 4 separate charging channels, which allows you to simultaneously charge 1, 2, 3 or 4 batteries. Panasonic BQ-CC55E
Retired
No product available!
Odroid N2 2GB CoreELEC Edition is a ready-made kit that allows you to build a home entertainment center (media center), based on the ODROID N2 minicomputer with 2 GB of RAM. Odroid N2 2GB CoreELEC Edition
Retired
No product available!
Jan Harrington