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... 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. The second edition of this book included some material about the object-relational extensions. However, that set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the third edition. A chapter on basic relational concepts will be also added to broaden the audience and make the book more complete in its own right. 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 where the particular type of operation is discussed. While the content throughout will be updated where necessary, the existing organizational structure through chapter 14 will remain largely intact because this coverage represents the stable portion of the SQL language. There will be 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 material 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 material from the original chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. (Some of chapter 19 will come from the second edition, however, a great deal of object-relational support has been added to the current standard and therefore needs to be added.) The other NEW chapter is Chapter 14, which covers triggers and stored 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 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 "Sustainability has come to be associated with cutting-edge technology, and in architecture, with glass, steel, solar panels, and wind turbines. In Britain and the United States, the majority view of sustainable housing involves "modern" solutions to problems and the application of technology to produce green products and services. Add to this the fact that most consumers want to live in a traditional house in a traditional setting and work in a traditional office building, and significant problems emerge. First, consumers reject sustainability because they think it will take them into a high-tech environment rather than a traditional setting. Second, tradition is viewed with scorn among built environment professionals, derided as kitsch and as pastiche. The result: a disconnect between the professionals and their clients." "In Green Living: Architecture and Planning, twelve leading experts in green architecture and urbanism argue that tradition and the vernacular have much to teach us about sustainability, and in fact can serve as the base from which to evolve cities, towns, and buildings that can respond to our global environmental challenges. Indeed, if we look past the last fifty years of planning and architectural trends to the deeper patterns that have provided the foundation for human settlement on the planet for more than a few thousand years, some of the answers have been right under our noses the whole time. Resolving the conflict between the professionals and their clients will require better definitions of both sustainability and tradition, and the reestablishment of living traditions that evolve to confront contemporary challenges." "Green Living provides an insight into current thinking on the subject that will both enlighten the layperson and provide an important, scholarly appreciation to architects and urban planners alike."
SQL Clearly Explained, 3rd Edition details the release of the SQL standard (SQL:2008), including two sets of extensions to support object-relational databases and XML. NEW chapters include coverage of the relational data model, relational algebra, SQL object-relational support, triggers and stored procedures, as well as XML. This expanded edition is packed with tips, tricks and other vital information for working with SQL.
- 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
1. The relational data model 2. Manipulating relations with relational algebra 3. Introduction to SQL 4. Simple SQL retrieval 5. Retrieving data from more than one table 6. Advanced retrieval operations 7. Calculations and grouping queries 8. Data Modifications 9. Schemas and tables 10. Views, temporary tables, CTEs and indexes 11. Keeping the design up to date 12. Users and access rights 13. Users, sessions, and transaction manipulation 14. Triggers and stored procedures 15. Embedded SQL 16. Dynamic SQL 17. XML support 18. The object-relational data model 19. Object-relational support
