Structured Query Language -- An IntroductionLulu.com, 2005 - 374 σελίδες Structured Query Language ' An Introduction, provides a comprehensive tutorial and reference for database programmers of all skill levels. Using the open source database PostgreSQL as a reference, the reader is taken from the basics of creating a database, setting permissions, and designing and implementing tables. The reader is introduced to searching for records in the database using queries, adding new data, updating existing data, and deleting data. Advanced topics are also included, such as: the creation and usage of indices for faster queries; the use of transactions to ensure database integrity; design and implementation of primary keys, foreign keys, and alternate keys; joining multiple tables in a single query; and database security. |
Περιεχόμενα
List of Figures | 9 |
2 | 16 |
1 | 25 |
4 | 32 |
5 | 39 |
6 | 48 |
Databases Schemas And Tablespaces | 57 |
Groups Users And Privileges | 71 |
5 | 271 |
11 | 277 |
17 | 283 |
23 | 289 |
Data Types | 319 |
Terminology Cross Reference | 331 |
Glossary | 337 |
ALTER | 341 |
4 | 77 |
5 | 85 |
Table And Column Operations | 91 |
Constraints And Indices | 123 |
2 | 130 |
4 | 145 |
Selecting Data | 155 |
4 | 191 |
5 | 199 |
33 | 201 |
Inserting Data | 205 |
2 | 208 |
Updating Data | 215 |
1 | 216 |
1 | 228 |
4 | 235 |
Isolation Levels Transactions And Locking | 239 |
2 | 245 |
3 | 253 |
III | 256 |
6 | 259 |
Reference | 265 |
Contents vii | vii |
List of Figures xiii | xiii |
9 | xiv |
Employee Table Definition INSERT Example | xv |
Preface xix | xix |
Overview 3 | 3 |
History 9 | 9 |
Deleting Data | 11 |
Relational Database Overview 25 | 25 |
SELECT Example | 158 |
SELECT Example 2 SELECT Example 3 SELECT Example 4 SELECT Calculated Fields Example How JOIN Works | 168 |
JOIN Example | 174 |
JOIN Example | 181 |
JOIN Example 10 Set Operations | 188 |
UNION Example 1 UNION Example 2 COUNT Example 1 COUNT Example 2 COUNT Example 3 COUNT Example 4 MIN Example | 196 |
205 | 205 |
212 | 212 |
218 | 218 |
224 | 224 |
232 | 232 |
343 | |
350 | |
Συχνά εμφανιζόμενοι όροι και φράσεις
added allowed ALTER ALTER TABLE application approach assigned attempt automatically BEGIN Chapter 14 CHECK clause column COMMIT constraint contain cost CREATE criteria data type database defined definition delete described desired determine discussed disk DROP Employee Employee table employeeid example execution existing EXPLAIN expression fields Figure following command foreign key function given GRANT GRANT OPTION GROUP hash implement indices INSERT integer issue the following JOIN language lock match mechanism multiple node Note NULL objects obtain operation output owner Parameters particular perform Planner PlutoSchema.Employee PostgreSQL primary key privileges programming provides query records REFERENCES relational returned REVOKE ROLLBACK rows rules SAVEPOINT schema SELECT sequence shown shows situation sort specified standard stored structure syntax table’s tablespace tion transaction tree unique UPDATE username