UID:
almahu_9948330094102882
Format:
1 online resource (369 p.)
Edition:
2nd ed.
ISBN:
1-281-07818-2
,
9786611078188
,
0-08-051758-7
Series Statement:
The Morgan Kaufmann Series in Data Management Systems
Content:
This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including ·formulating SQL queries, ·understanding how queries are processed by the DBMS,·
Note:
Includes index.
,
Front Cover; SQL Clearly Explained; Copyright Page; Contents; Preface to the Second Edition; The Organization of This Book; The CD and the Sample Database; Acknowledgments; Part 1: Getting Started; Chapter 1: Installing and Running MySQL; Linux; Windows; Mac OS X; Chapter 2: Creating and Loading Databases; Creating a New Database; Creating the Tables; Populating the Tables; Chapter 3: Introduction to SQL; A Bit of SQL History; Conformance Levels; Relational Database Terminology and the Sample Database; Manipulating Relations; SQL Environments; Part 2: Performing Interactive Data Manipulation
,
Chapter 4: Simple SQL RetrievalChoosing Columns; Ordering the Result Table; Choosing Rows; Nulls and Retrieval: Three-Valued Logic; Chapter 5: Retrieving Data from More Than One Table: Joins; The Relational Algebra Join Operation; SQL Syntax for Inner Joins; Finding Multiple Rows in One Table: Joining a Table to Itself; Outer Joins; Valid versus Invalid Joins; Avoiding Joins with Uncorrelated Subqueries; Chapter 6: Advanced Retrieval Operations; Union; Negative Queries; The EXISTS Operator; CASE Expressions; Chapter 7: Calculations and Grouping Queries; Performing Arithmetic
,
String ManipulationsDate and Time Manipulation; Set Functions; Changing Data Types: Using CAST; Grouping Queries; Chapter 8: Data Modification; Inserting Rows; Updating Data; Deleting Rows; Part 3: Managing Database Structure; Chapter 9: Schemas and Tables; Database Object Hierarchy; Schemas; Domains; Tables; Chapter 10: Views, Temporary Tables, and Indexes; Views; Temporary Tables; Indexes; Modifying Database Elements; Deleting Database Elements; Granting and Revoking Access Rights; Part 4: Program-Based Data Manipulation; Chapter 11: Users, Sessions, and Transaction Control
,
The Concurrent Use Data EnvironmentDatabase User IDs; Database Sessions and Connections; Transaction Control; Chapter 12: Embedded SQL; The Embedded SQL Environment; DBMS Return Codes; Retrieving a Single Row; Retrieving Multiple Rows: Cursors; Embedded SQL Data Modification; Chapter 13: Dynamic SQL; Immediate Execution; Dynamic SQL with Dynamic Parameters; Part 5: Additional Language Features; Chapter 14: Unimplemented SQL-92 Features; Additional Relational Algebra Operations; Additional Predicate Operators; Table Constructors in Queries; Additional Foreign Key Options; Assertions
,
Determining When Constraints Are CheckedChapter 15: Object-Oriented Features of the SQL:1999 Standard; The Basics of Object Orientation; SQL:1999 versus Pure Object-Orientation; Object-Relational Support; Typed Tables; Creating Classes; Querying with Classes; Modifying Data for Classes as Domains; Part 6: Appendices; Appendix A: The Online Bookstore Database; Appendix B: SQLSTATE Return Codes; Appendix C: SQL Syntax Summary; Appendix D: SQL:1999 Core Features; Glossary; Index
,
English
Additional Edition:
ISBN 1-55860-876-1
Language:
English
