Database Management System, Oracle SQL and PL/SQL

by Pranab Kumar Das Gupta

Database Management System (DBMS) and Oracle are essentially a part of the curriculum for undergraduate and postgraduate courses in Computer Science, Computer Applications, Computer Science and Engineering, Information Technology, and Management.

This book introduces the readers to the theoretical and practical concepts of DBMS, Oracle SQL and PL/SQL using numerous real-life examples. Important and complex topics such as relational algebra, query processing, index file organization, hashing, distributed architecture, concurrency control, triggers, cursors, Oracle architecture, and data mining are comprehensively covered with the help of a number of solved examples.

KEY FEATURES
• Explains each topic in a step-by-step detail.
• Includes more than 240 examples to illustrate the concepts.
• Offers about 140 objective type questions to quiz students on key points.
• Provides about 40 challenging exercises that invite deeper analysis and interpretation of the subject matter.

396 pages, Kindle Edition

First published July 14, 2013

About the author

Dr. Pranab Kumar Das Gupta is a professional with over 35 years of expertise in Computer Science and HR management. He is an author, with 10 books and over 30 research papers to his credit.