Introduction to SQL : mastering the relational database language / by Rick F. van der Lans

By: Lans, Rick F. van derMaterial type: TextTextPublication 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.13
Contents:
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
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Call number Status Date due Barcode Item holds
CD/DVD CD/DVD Namal Library
CD/DVD Rack 		005.13 LAN-I 2013 6185 (Browse shelf (Opens below)) Available CD06185
Books Books Namal Library
Computer Science 		005.13 LAN-I 2013 6185 (Browse shelf (Opens below)) Available 0006185
Total holds: 0

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.

to post a comment.