9787115296634 (1 results)

paperback. Condition: New. Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date: 2013 Language: English Publisher: People's Posts and Telecommunications Press SQL Definitive Guide (4th Edition) is the latest version of the world-renowned database expert Joe Celko classics. it reveals the formulation of the theory of the SQL standard and practical considerations. from a novel perspective analysis of the idea of ??resolving SQL programming. is a must-read for SQL Advanced not to be missed. Getting Started with SQL is not difficult. the difficulty is advanced and improved. As a member of the SQL standards committee. Celko aside commercial database products in this book. a comprehensive. in-depth. thorough analysis of the SQL language itself. Book ANSI SQL-89. taking into account the SQL-92 features fully explain the relational database design. optimization. and operational aspects of a variety of key issues. SQL data types. queries. grouping. set operations. optimization. data telescopic and senior theme coding. transaction and concurrency control model professional SQL programmer must understand and master everything. The language of humor. unique perspective. to read often very sobering sense of Brief Encounter. Book Peiyoudaliang straightforward sample code is also a book widely critical readers praised and respected. SQL Definitive Guide (4th edition) for some SQL programming experience senior SQL programmer or DBA learning reference. Contents: 1.4. the 1.1 Entity Table 1.2 of Chapter 1 of the database and file system relations Table 1.3 line and record mode object with field 1.5 1.6 CREATE SCHEMA statement Chapter 2 transaction concurrency control 2.1 sessions the 2.2 Affairs and ACID2.2.1 of atomic 2.2. 2 Conformance 2.2.3 2.2.4 Persistent isolation 2.3 Concurrency Control 2.3.1 three phenomena 2.4 2.3.2 isolation level pessimistic concurrency control 2.5 snapshot isolation and optimistic concurrency 2.6 logic Concurrency Control 2.7 deadlock and livelock first Chapter 3 database schema objects 3.1 CREATE SCHEMA statement 3.2 create the CREATE the PROCEDURE. CREATE FUNCTION to CREATE TRIGGER statement 3.3 CREATE DOMAIN statement 3.4 the sequence 3.5 create assertion 3.5.1 Mode level constraints use view 3.5.2 is constrained using the primary key and assertions 3.6 character set Create a character set structure 3.6.1 to 3.6.2. to create collation 3.6.3 create translation Chapter 4 positioning data and special values ??of 4.1 explicit physical locator a 4.1.1 ROWID and the physical disk address 4.1.2 identity column 4.2 generates the identifier 4.2.1 GUID4.2.2 UUID4.3 sequence generation function 4.4 4.5.1 Series pre-assigned a value of 4.5 special sequence table 4.5.2 primes 4.5.3 random order value 4.5.4 Chapter 5 of the other sequences underlying table and related elements 5.1 CREATE TABLE statement column constraint 5.1.1 5.1.2 DEFAULT clause 5.1.3 NOT NULL constraints 5.1.4 CHECK () constraint 5.1.5 UNIQUE and PRIMARY KEY constraints 5.1.6 REFERENCES clause 5.2 nested UNIQUE constraint 5.2.1 overlap key 5.2.2 single-column and multi-column unique 5.3 CREATE ASSERTION constraint 5.4 temporary operation Table 5.5 Table 5.5.1 DROP TABLE 5.5.2 ALTER TABLE5.6 avoid attribute segmentation 5.6.1 table-level attribute segmentation 5.6.2 line level attributes split 5.7 DDL in the performance class hierarchy relations 5.8 explicit physical locator 5.9 5.9.1 ROWID physical disk address 5.9.2 identity column since added 5.9.3 Comparison identity column and sequence 5.10 to generate identifiers 5.10.1 industry standard unique identifier unique identifier of the Department of Defense 5.10.2 5.10.3 5.10.4 sequence generation function only value generator the 5.10.5 verify source 5.11 5.15 CREATE TRIGGER statement duplicate rows 5.12 other schema objects 5.13 temporary table 5.14 the CREATE DOMAIN statement 5.16 CREATE PROCEDURE statement 5.17 DECLARE CURSOR statement 5.17.1 How to Use the cur.