|
Introduction to SQL: Mastering the Relational Database Language 4th Edition
CONTENTS:
About the Author xix
Preface xxi
Part 1 Introduction 1
1 Introduction to SQL 3
2 The Tennis Club Sample Database 31
3 Installing the Software 41
4 SQL in a Nutshell 67
Part 2 Querying and Updating Data 95
5 SELECT
Statement: Common Elements 97
6 SELECT Statements, Table Expressions, and Subqueries 155
7 SELECT Statement: The FROM Clause 185
8 SELECT Statement: The WHERE Clause 241
9 SELECT Statement: SELECT Clause and Aggregation Functions 339
10 SELECT Statement: The GROUP BY Clause 377
11 SELECT Statement: The HAVING Clause 421
12 SELECT Statement: The ORDER BY Clause 429
13 Combining Table Expressions 443
14 Updating Tables 469
Part 3 Creating Database Objects 485
15 Creating Tables 487
16 Specifying Integrity Constraints 515
17 Character Sets and Collating Sequences 535
18 Changing and Dropping Tables 553
19 Designing Tables 565
20 Using Indexes 579
21 Views 611
22 Creating Databases 635
23 Users and Data Security 641
24 Creating Sequences 665
25 Creating Schemas 681
Part 4 Programming with SQL 685
26 Introduction to Embedded SQL 687
27 Transactions and Multi-User Usage 725
28 Introduction to ODBC 745
29 Optimization of Statements 783
Part 5 Procedural Database Objects 803
30 Stored Procedures 805
31 Stored Functions 847
32 Triggers 853
Part 6 Object Relational Concepts 871
33 User-Defined Data Types, Functions, and Operators 873
34 Inheritance, References, and Collections 889
35 The Future of SQL 909
Appendix A Syntax of SQL 911
Appendix B Scalar Functions 953
Appendix C Bilbiography 999
Index 1003
|
