Patni, Jagdish Chandra,

A comprehensive study of SQL : practice and implementation / Jagdish Chandra Patni. - First edition. - pages cm

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.

"'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"--

9781032348407 9781032349756

2022026700


Microsoft Excel (Computer file)--Textbooks.


SQL (Computer program language)--Textbooks.
Relational databases--Textbooks.
Querying (Computer science)--Textbooks.

QA76.73.S67 / P3775 2023

005.54