A Comprehensive Study of SQL - Patni, Jagdish Chandra; - Prospero Internet Bookshop
Basket (0)
Wishlist (0)
Your personal newsletter
__

A Comprehensive Study of SQL: Practice and Implementation
 
Product details:
ISBN13:9781032349756
ISBN10:1032349751
Binding:Paperback
No. of pages:236 pages
Size:254x178 mm
Weight:453 g
Language:English
Illustrations: 13 Illustrations, black & white; 13 Line drawings, black & white; 180 Tables, black & white
688
Category:

A Comprehensive Study of SQL

Practice and Implementation
 
Edition number: 1
Publisher: CRC Press
Date of Publication:
 
Normal price:
Publisher's listprice:
GBP 44.99
Estimated price in HUF:
23 619 HUF (22 495 HUF + 5% VAT)
Why estimated?
 
Your price:
21 258 (20 246 HUF + 5% VAT )
discount is: 10% (approx 2 362 HUF off)
The discount is only available for 'Alert of Favourite Topics' newsletter recipients.
Click here to subscribe.
 
Availability:
Estimated delivery time: In stock at the publisher, but not at Prospero's office. Delivery time approx. 3-5 weeks.
Not in stock at Prospero.
Can't you provide more accurate information?
 
Add to basket
  Piece(s)

 
Short description:

This book is designed as a textbook and provides a comprehensive approach to SQL - the standard programming language for defining, organizing, and exploring data in relational databases. It demonstrates how to leverage SQL and Excel to perform comprehensive data analysis without the need for a sophisticated and expensive data mining tool.

Long description:

A Comprehensive Study of SQL - Practice and Implementation is designed as a textbook and provides a comprehensive approach to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. It demonstrates how to leverage the two most vital tools for data query and analysis ? SQL and Excel ? to perform comprehensive data analysis without the need for a sophisticated and expensive data mining tool or application.


Features



  • The book provides a complete collection of modeling techniques, beginning with fundamentals and gradually progressing through increasingly complex real-world case studies

  • It explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications

  • It also gives a solid foundation in best practices and relational theory

  • The book offers self-contained lessons on key SQL concepts or techniques at the end of each chapter using numerous illustrations and annotated examples

This book is aimed primarily at advanced undergraduates and graduates with a background in computer science and information technology. Researchers and professionals will also find this book useful.

Table of Contents:
1. Database Systems. 2. Creating and Manipulating Database. 3. Data and Integrity Constraints. 4. Query Execution and Aggregate functions. 5. SQL Server Vs. Oracle. 6. Conditional statements and Operators in SQL. 7. Nested Query and Join. 8. Views, Indexes and Sequence. 9. PL/SQL. 10. Functions and Procedures. 11. Cursors and Triggers. 12. Change Management for databases. 13. Previous year Question papers with solutions.