- 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)
NanoPi R5C minicomputer designed by FriendlyElec. It is equipped with a Rockchip RK3568B2 processor, 4 GB of LPDDR4x RAM and 32 GB eMMC memory. It supports microSD cards and works with operating systems such as FriendlyWrt, Android, Debian. FriendlyELEC NanoPi R5C
Retired
No product available!
NanoPi R5C minicomputer designed by FriendlyElec. It is equipped with a Rockchip RK3568B2 processor, 2 GB of LPDDR4x RAM and 32 GB eMMC memory. It supports microSD cards and works with operating systems such as FriendlyWrt, Android, Debian. FriendlyELEC NanoPi R5C
Retired
No product available!
NanoPi R6C minicomputer designed by FriendlyElec. It is equipped with a Rockchip RK3588S processor and 4 GB of LPDDR4x RAM. Supports booting from microSD cards and works with operating systems such as FriendlyWrt, Android, Debian, Ubuntu, etc. FriendlyELEC NanoPi R6C
Retired
No product available!
NanoPi R6C minicomputer designed by FriendlyElec. It is equipped with a Rockchip RK3588S processor and 4 GB of LPDDR4x RAM. Supports booting from microSD cards and works with operating systems such as FriendlyWrt, Android, Debian, Ubuntu, etc. FriendlyELEC NanoPi R6C
Retired
No product available!
NanoPi R6C minicomputer designed by FriendlyElec. It is equipped with a Rockchip RK3588S processor, 8 GB LPDDR4x RAM and 32 GB eMMC Flash memory. Supports booting from microSD cards and works with operating systems such as FriendlyWrt, Android, Debian, Ubuntu, etc. FriendlyELEC NanoPi R6C
Retired
No product available!
3D printer with automatic table leveling and printing resume function. Equipped with a double Z axis and a filament sensor. It offers a large working space of 240 x 240 x 260 mm and uses a metal hotend. It allows printing at a speed of 300mm/s, which translates into 30% faster printing compared to previous versions of Sidewinder printers. Artillery Sidewinder X3 Pro
Retired
No product available!
3D printer with automatic table leveling and printing resume function. Equipped with a double Z axis and a filament sensor. It offers a large working space of 300 x 300 x 400 mm and uses a fully metal hotend. It allows printing at a speed of 300mm/s, which translates into 30% faster printing compared to previous versions of Sidewinder printers. Artillery Sidewinder X3 Plus
Retired
No product available!
3D printer with automatic table leveling and printing resume function. Equipped with a double Z axis and a filament sensor. It offers a large working space of 240 x 240 x 260 mm and uses a full metal hotend and a dual gear extruder. It allows printing at a speed of 500mm/s. Artillery Sidewinder X4 Pro
Retired
No product available!
3D printer with automatic table leveling and printing resume function. Equipped with a double Z axis and a filament sensor. It offers a large workspace of 300 x 300 x 400 mm and uses a full metal hotend and a dual gear extruder. It allows printing at a speed of 500mm/s. Artillery Sidewinder X4 Plus
Retired
No product available!
Linear, programmable DC benchtop power supply with three independent, galvanically isolated outputs, providing a total power of 220 W. It offers two fully adjustable 0-32 V channels and an additional fixed 2.5 V/3.3 V/5 V output for flexible applications. A 4.3-inch color TFT display allows for clear, real-time monitoring of voltage, current, and waveforms. Support for independent, serial, and parallel modes, as well as remote control via USB and LAN, make it a versatile tool for electronics design and test. The Siglent SPD3303X-E
Retired
No product available!
The Samsung PM991a 256GB is an M.2 2230 SSD that offers sequential read speeds of up to 3,100 MB/s, write speeds of up to 1,300 MB/s and high IOPS rates, increasing system performance and responsiveness
Retired
No product available!
GOODRAM PX500 gen.2 M.2 SSD is a PCIe NVMe gen 3 x4 interface drive, offering performance up to 1850 MB/s in reading and 950 MB/s in writing, providing improved computer speed in various applications. Goodram SSDPR-PX500-256-80-G2
Retired
No product available!
The Vorel 82736 workshop lamp is an ideal solution for professionals and DIY enthusiasts who need a reliable and powerful light source. Thanks to the adjustable base, rotating hook and magnets, the lamp is extremely functional and suitable for various applications. Durable construction and high protection class ensure long-term and safe use. Vorel - 82736
Retired
No product available!
Designed for horizontal mounting in 19-inchserver racks, the Lanberg Power Distribution Unit (PDU) provides smooth, reliable power with single-phase input and advanced protections including overload protection and automatic fuse, ideal for professional server environments thanks to its redundant cable size. Lanberg PDU-PRO-07F-0200-BK
Retired
No product available!
HAT audio module for Raspberry Pi. It uses the Texas Instruments PCM5242 DAC, which provides excellent sound quality and a built-in headphone amplifier, which makes it an ideal solution for people who prefer to listen to music through headphones. Pimoroni SC0369
Retired
No product available!
Compact mini router with two Gigabit Ethernet ports, equipped with a quad-core RK3528 ARM Cortex-A53 processor clocked at 1.5 GHz, which provides fast and stable network connections. The router offers 4 GB of LPDDR4 memory, 8 GB of built-in eMMC memory expandable up to 512 GB, and support for Type-C power supply in the range of 5V-12V, making it a flexible and efficient network solution. Seeed Studio 113991235
Retired
No product available!
Jan Harrington