Amazon cover image
Image from Amazon.com

The language of SQL / Larry Rockoff

By: Material type: TextTextPublication details: India Pearson 2018Edition: 2nd edDescription: 224 pISBN:
  • 9789332585928
Subject(s): DDC classification:
  • 005.756 ROC-L
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Shelving location Call number Status Date due Barcode Item holds
Books Books BITS Pilani Hyderabad 003-007 General Stack (For lending) 005.756 ROC-L (Browse shelf(Opens below)) Available 38220
Total holds: 0

A quick, clearly written introduction to the use of SQL to store and retrieve information
Features First edition of this strong-selling book has sold over 14,000 copies since 2010.
• Utilizes a language-based approach that allows the user to learn SQL as they would learn English
• Updated examples work with the latest versions of Oracle, SQL Server and MySQL
Table of Contents
The Language of SQL, 2nd Edition

Introduction
1. Relational Databases and SQL
2. Basic Data Retrieval
3. Calculated Fields and Aliases
4. Using Functions
5. Sorting Data
6. Selection Criteria
7. Boolean Logic
8. Conditional Logic
9. Summarizing Data
10. Subtotals and Crosstabs
11. Inner Joins
12. Outer Joins
13. Self Joins and Views
14. Subqueries
15. Set Logic
16. Stored Procedures and Parameters
17. Modifying Data
18. Maintaining Tables
19. Principles of Database Design
20. Strategies for Displaying Data
A. Getting Started with Microsoft SQL Server
B. Getting Started with MySQL
C. Getting Started with Oracle.

There are no comments on this title.

to post a comment.
An institution deemed to be a University Estd. Vide Sec.3 of the UGC
Act,1956 under notification # F.12-23/63.U-2 of Jun 18,1964

© 2024 BITS-Library, BITS-Hyderabad, India.