Jagdish Chandra Patni - A Comprehensive Study of SQL: Practice and Implementation

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

• provides a complete collection of modeling techniques, beginning with fundamentals and gradually progressing through increasingly complex real-world case studies.
• explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications.
• gives a solid foundation in best practices and relational theory.
• 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.

Jagdish Chandra Patni

First edition published 2023

by CRC Press

6000 Broken Sound Parkway NW, Suite 300, Boca Raton, FL 33487-2742

and by CRC Press

4 Park Square, Milton Park, Abingdon, Oxon, OX14 4RN

CRC Press is an imprint of Taylor & Francis Group, LLC

2023, Jagdish Chandra Patni;

Reasonable efforts have been made to publish reliable data and information, but the author and publisher cannot assume responsibility for the validity of all materials or the consequences of their use. The authors and publishers have attempted to trace the copyright holders of all material reproduced in this publication and apologize to copyright holders if permission to publish in this form has not been obtained. If any copyright material has not been acknowledged, please let us know so we may rectify it in any future reprint.

Except as permitted under U.S. Copyright Law, no part of this book may be reprinted, reproduced, transmitted, or utilized in any form by any electronic, mechanical, or other means, now known or hereafter invented, including photocopying, microfilming, and recording, or in any information storage or retrieval system, without written permission from the publishers.

For permission to photocopy or use material electronically from this work, access

Trademark notice: Product or corporate names may be trademarks or registered trademarks and are used only for identification and explanation without intent to infringe.

Library of Congress CataloginginPublication Data

Names: Patni, Jagdish Chandra, author.

Title: A comprehensive study of SQL : practice and implementation / Jagdish Chandra Patni.

Description: First edition. | Boca Raton : Chapman & Hall/CRC Press, 2023.|Includes bibliographical references and index. |

Identifiers: LCCN 2022026700 (print) | LCCN 2022026701 (ebook) | ISBN 9781032348407 (hardback) | ISBN 9781032349756 (paperback) |ISBN 9781003324690 (ebook)

Subjects: LCSH: Microsoft Excel (Computer file)--Textbooks. | SQL (Computer program language)--Textbooks. | Relational databases--Textbooks. | Querying (Computer science)--Textbooks.

Classification: LCC QA76.73.S67 P3775 2023 (print) | LCC QA76.73.S67 (ebook) | DDC 005.54--dc23/eng/20220920

LC record available at https://lccn.loc.gov/2022026700

ISBN: 978-1-032-34840-7 (hbk)

ISBN: 978-1-032-34975-6 (pbk)

ISBN: 978-1-003-32469-0 (ebk)

DOI: 10.1201/9781003324690

Typeset in Palatino

by SPi Technologies India Pvt Ltd (Straive)

This book A Comprehensive Study of SQL: Practice and Implementation is dedicated to my beloved parents Late Sh. Prayag Datt Patni and Smt. Haripriya Patni; I am here in this beautiful world just because of your blessings and guidance. My father, now you are not with us, but I know you are still giving your continuous blessings to all.

My wife, Priyanka Patni always motivates me to do new things, she always reminds me that you can do wonders if you try for the same, so this book is the result of this continuous motivation.

I dedicate this book to my loving kids, Shrey and Parisha, who gave me strength and love during the journey of this book; I took their time while working day and night.

Last but not least, I dedicate this book to all my family members, gurus, colleagues, friends, and my beloved students for motivating and continuous support for this wonderful purpose.

Dr. Jagdish Chandra Patni

Jain University Bangalore

Managing data is a critical task when it comes to a scale, and we need a powerful management tool or program to handle this huge amount of data. These specialized sets of programs are known as database management system, and SQL is one of the powerful tools for managing the data.

SQL stands for a structured query language used to manage the relational database management system where we store the data in the form of rows and columns. SQL has different sets of languages for defining the databases, managing the databases, retrieving the databases, and controlling the user access in the database. This book focuses on the basics of SQL, starting from creating the databases, manipulating the databases, constraints that make our database stronger, concepts of programming languages, functions, and procedures, as well as advanced concepts of triggers and cursors. This book also covers the difference between SQL and Oracle with similarities and differences. This book also covers the basics of change management in the database system.

This book comes with the proper syntax of each one of the topics with practical examples with proper explained output. This book contains real-life examples for a better understanding of the topics with proper explanation.

This book guarantees to bridge the gap between theoretical knowledge and practical implementations with the proper understanding of concepts. We would like to invite suggestions from our readers to improve the content of this book.

This book is divided into 13 chapters, and each chapter is connected with other chapters. The chapter-wise details are as follows.

: This chapter gives the basics of the databases in terms of practical implementation with features, advantages, and disadvantages.

: This chapter gives detailed descriptions of defining, manipulating, retrieving, and controlling the database with proper syntax and examples.

: This chapter describes the various types of database constraints that make our database stronger and safer. This chapter also discussed the various types of keys used in the databases and their practical implementation.

: This chapter shows the effective and efficient retrieval of records from the databases with different types of select statements. Also discussed are the different types of aggregate functions.

: In this chapter, the concepts SQL and Oracle are discussed with similarities and differences between them.

: This chapter discusses conditional statements and different types of operators used in SQL.

: This chapter explains the concepts of subqueries and joins and how we can use them and vice-versa.