• Contact

  • Newsletter

  • About us

  • Delivery options

  • Prospero Book Market Podcast

  • 'Language is english. Váltás magyarra.'
    Wishlist
    A Comprehensive Study of SQL: Practice and Implementation

    A Comprehensive Study of SQL by Patni, Jagdish Chandra;

    Practice and Implementation

      • GET 20% OFF

      • The discount is only available for 'Alert of Favourite Topics' newsletter recipients.
      • Publisher's listprice GBP 76.99
      • The price is estimated because at the time of ordering we do not know what conversion rates will apply to HUF / product currency when the book arrives. In case HUF is weaker, the price increases slightly, in case HUF is stronger, the price goes lower slightly.

        34 760 Ft (33 105 Ft + 5% VAT)
      • Discount 20% (cc. 6 952 Ft off)
      • Discounted price 27 808 Ft (26 484 Ft + 5% VAT)
      • Discount is valid until: 30 June 2026

    31 284 Ft

    db

    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.

    Why don't you give exact delivery time?

    Delivery time is estimated on our previous experiences. We give estimations only, because we order from outside Hungary, and the delivery time mainly depends on how quickly the publisher supplies the book. Faster or slower deliveries both happen, but we do our best to supply as quickly as possible.

    Product details:

    • Edition number 1
    • Publisher CRC Press
    • Date of Publication 5 December 2022

    • ISBN 9781032348407
    • Binding Hardback
    • No. of pages236 pages
    • Size 254x178 mm
    • Weight 560 g
    • Language English
    • Illustrations 13 Illustrations, black & white; 13 Line drawings, black & white; 180 Tables, black & white
    • 260

    Categories

    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.

    More

    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.

    More

    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.

    More
    0