Database Management System Oracle SQL and PL/SQL
2nd Edition
Published on 30. December 2013
Book
Paperback/Softback
576 pages
978-81-203-4842-4 (ISBN)
Description
Database Management System (DBMS) and Oracle are an essential part of the curriculum for undergraduate and postgraduate courses in computer science, computer applications, computer science and engineering, information technology and management. The book is organised into three parts to introduce theoretical and programming concepts of DBMS. Part I (Basic Concepts and Oracle SQL) deals with DBMS basic, software analysis and design, data flow diagrams, ER models, relational algebra, normal forms, SQL queries, functions, subqueries, different types of joins, DCL, DDL, DML, object constraints and security in Oracle. Part II (Application Using Oracle PL/SQL) explains PL/SQL basics, functions, procedures, packages, exception handling, triggers, implicit, explicit and advanced cursors using suitable examples. This part also covers advanced concepts related to PL/SQL, such as collection, records, objects, dynamic SQL and performance tuning. Part III (Advanced Concepts and Technologies) elaborates on advanced database concepts such as query processing, file organisation, distributed architecture, backup, recovery, data warehousing, online analytical processing and data mining concepts and their techniques.
New to the Second Edition - The book reorganised into three parts for better understanding of DBMS concepts.
- All the existing chapters thoroughly revised and eight new chapters added.
- New chapters discuss Oracle PL/SQL advanced programming concepts, data warehousing, OLTP, OLAP and data mining concepts.
- Additional examples, questions and workouts in each chapter.
Key Features - Explains each topic in step-by-step detail.
- Includes about 300 examples to illustrate concepts.
- Offers about 400 objective type questions to test students on key points.
- Provides about 100 challenging workouts that invite deeper analysis and interpretation of the subject matter.
- Teaching Aid Material for all the chapters is provided on PHI Learning's website, which can be used by faculties/teachers for delivering lectures. Visit www.phindia.com/gupta to explore the contents.
New to the Second Edition - The book reorganised into three parts for better understanding of DBMS concepts.
- All the existing chapters thoroughly revised and eight new chapters added.
- New chapters discuss Oracle PL/SQL advanced programming concepts, data warehousing, OLTP, OLAP and data mining concepts.
- Additional examples, questions and workouts in each chapter.
Key Features - Explains each topic in step-by-step detail.
- Includes about 300 examples to illustrate concepts.
- Offers about 400 objective type questions to test students on key points.
- Provides about 100 challenging workouts that invite deeper analysis and interpretation of the subject matter.
- Teaching Aid Material for all the chapters is provided on PHI Learning's website, which can be used by faculties/teachers for delivering lectures. Visit www.phindia.com/gupta to explore the contents.
More details
Edition
2nd Revised edition
Language
English
Place of publication
New Delhi
India
Target group
College/higher education
Edition type
Revised edition
Dimensions
Height: 235 mm
Width: 178 mm
Thickness: 20 mm
Weight
456 gr
ISBN-13
978-81-203-4842-4 (9788120348424)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Pranab Kumar Das Gupta, Ph.D., is a Senior Scientist in Defence Research and Development Organization (DRDO). Presently, he is Additional Director in Computer and Communication Wing at Proof and Experimental Establishment, Chandipur, India. Dr. Das Gupta is also the author of three other books: Developing Web Applications Using ASP.NET and Oracle (2nd edition), Cloud Computing-Based Projects Using Distributed Architecture and Oracle Developer 2000: Basics to Implementation, all published by PHI Learning.
P. Radha Krishna, Ph.D., is a Principal Research Scientist at Infosys Labs, Infosys Limited, Hyderabad, India, where he is associated with research projects leading to futuristic information management and analytical solutions.
P. Radha Krishna, Ph.D., is a Principal Research Scientist at Infosys Labs, Infosys Limited, Hyderabad, India, where he is associated with research projects leading to futuristic information management and analytical solutions.