Introduction to SQL : mastering the relational database language / by Rick F. van der Lans
Material type: TextPublication details: New Delhi : Pearson, 2013Edition: 4th edDescription: xxvi, 1026 p. : ill. ; 24 cm. + 1 Compact Disc (4 3/4 in.)ISBN: 9788131713556 (pbk.)Subject(s): SQL (Computer program language)DDC classification: 005.13Item type | Current library | Call number | Status | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|
CD/DVD | Namal Library CD/DVD Rack | 005.13 LAN-I 2013 6185 (Browse shelf (Opens below)) | Available | CD06185 | ||
Books | Namal Library Computer Science | 005.13 LAN-I 2013 6185 (Browse shelf (Opens below)) | Available | 0006185 |
Includes bibliographical references (p. [999]-1001) and index.
1- Introduction to SQL
2- The Tennis Club Sample Database
3- Installing the Software
4- SQL in a Nutshell
5- Select Statement : Common Elements
6- Select Statement : Table Expressions & Subqueries
7- Select Statement : The FROM Clause
8- Select Statement : The WHERE Clause
9- Select Statement : SELECT Clause & Aggregation Functions
10- Select Statement :The GROUP BY Clause
11- Select Statement : The Having Clause
12- Select Statement : The ORDER BY Clause
13- Combining Table Expressions
14- Updating Tables
15- Creating Tables
16- Specifying Integrity Contraints
17- Character Sets and Collacting Sequences
18- Changing & Dropping Tables
19- Designing Tables
20- Using Indexes
21- Views
22- Creating Databases
23- Users & Data Security
24- Creating sequences
25- Creating Schemas
26- Introduction to Embedded SQL
27- Transactions & Multi-User Usage
28- Introduction to ODBC
29- Optimization of Statements
30- Stored Procedures
31- Stored Functions
32- Triggers
33- User-Defined Data Types
34- Inheritance, References & Collections
35- The Future of SQL
There are no comments on this title.