A comprehensive study of SQL practice and implementation / Jagdish Chandra Patni.
| Author/creator | Patni, Jagdish Chandra |
| Format | Electronic |
| Edition | First edition. |
| Publication Info | Boca Raton : Chapman & Hall/CRC Press, 2023. |
| Description | pages cm |
| Supplemental Content | Full text available from Taylor & Francis eBooks |
| Subjects |
| Contents | Database systems -- Creating and manipulating database -- Data and integrity constraints -- Query execution and aggregate functions -- SQL server vs. Oracle -- Conditional statements and operators in SQL -- Nested query and join -- Views, indexes and sequence -- PL/SQL -- Functions and procedures -- Cursors and triggers -- Change management for databases -- Previous year question papers with solutions. |
| Abstract | "'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"-- Provided by publisher. |
| Bibliography note | Includes bibliographical references and index. |
| Access restriction | Available only to authorized users. |
| Technical details | Mode of access: World Wide Web |
| Genre/form | Electronic books. |
| LCCN | 2022026700 |
| ISBN | 9781032348407 (hardback) |
| ISBN | 9781032349756 (paperback) |
| ISBN | (ebook) |
Availability
| Library | Location | Call Number | Status | Item Actions |
|---|---|---|---|---|
| Electronic Resources | Access Content Online | ✔ Available |