TY - BOOK AU - Patni,Jagdish Chandra TI - A comprehensive study of SQL: practice and implementation SN - 9781032348407 AV - QA76.73.S67 P3775 2023 U1 - 005.54 23/eng/20220920 PY - 2023/// CY - Boca Raton PB - Chapman & Hall/CRC Press KW - Microsoft Excel (Computer file) KW - Textbooks KW - SQL (Computer program language) KW - Relational databases KW - Querying (Computer science) N1 - SIBF2023; P.B; Includes bibliographical references and index; 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 N2 - "'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"-- ER -