Database Management System, Oracle Sql and Pl/Sql  (English, Paperback, Dasgupta Pranab Kumar)

Database Management System, Oracle SQL And PL/SQL is an introductory text on database concepts and the use of the Oracle Database, SQL, and PL/SQL.

Summary Of The Book

Database Management System, Oracle SQL And PL/SQL introduces and explains the fundamental concepts and principles of database management systems, especially relational database systems.

It also discusses the practical applications of these concepts in actual DBMS systems with relevance to Oracle. The Oracle DBMS is explored in detail, with practical examples of using SQL for data manipulation and programming using PL/SQL.

The first chapter goes into the fundamentals of database systems. It then examines software analysis and design. This chapter also explains Data Flow diagrams and the Entity Relationship (ER) model. Database Management System, Oracle SQL And PL/SQL then discusses relational algebra and data normalization. It looks at file organization, query processing, distributed processing, and data mining.

The book then examines other important database concepts like concurrency control, transaction processing, and backup and recovery methods. It also explains the Oracle database architecture.

Database Management System, Oracle SQL And PL/SQL then discusses SQL, the language used by databases. It also shows how to use SQL for data retrieval, how to use the built in SQL functions, and how to perform subqueries and joins.

The use of Data Manipulation Language is explained next. Using SQL statements like Insert, Update and Delete to change the data in the database is also discussed and so is the use of transaction control statements like commit, rollback, and savepoint.

Views and indexes, and defining constraints to ensure data integrity are the focus of the subsequent chapter. The author also discusses how to assign roles and privileges in Oracle, how to create profiles, and how to assign and change passwords.

Database Management System, Oracle SQL And PL/SQL then takes an in-depth look at Procedural Language/Structured Query Language (PL/SQL). PL/SQL is the Oracle proprietary extension of the fundamental database language, SQL. It adds powerful programming features to SQL, explaining PL/SQL basics and structure, and how to use this language to full advantage in Oracle databases.

Database Management System, Oracle SQL And PL/SQL explains powerful programming features like creating functions, procedures, and packages. It also goes into exception handling, implicit cursors, database triggers, and explicit and advanced cursors.

All database concepts are presented clearly and the various aspects of the Oracle database and the use of SQL and PL/SQL are also well defined. The book provides many exercises, including their solutions, to ensure the students’ understanding of the concepts.

About Pranab Kumar Das Gupta

Pranab Kumar Das Gupta is a Senior Scientist at the DRDO.

Other books by Das Gupta include Oracle Developer 2000 : Basics To Implementation, and Developing Web Applications Using ASP.NET And Oracle.

He writes books on databases.

Das Gupta has an M.Sc and an M.Tech in Computer Science. He also has a doctorate in Information and Communication technology. He is currently posted in Odisha, as Additional Director, Proof and Experimental Establishment. His area of expertise is relational database management and web based applications.