Cart (0)
eBooks Cart (0)
*Conditions Apply
Home  >  Database Management System, Oracle SQL And PL/SQ...
Buy Database Management System, Oracle SQL And PL/SQL: Book
Web Reader
Now you can read Flipkart eBooks on various web browsers
Android
Install Flipkart eBooks App on your Android(2.2 or higher) devices from Google Play Store
iOS
Install Flipkart eBooks App on your iOS devices from App Store
Windows Phone 8
Install Flipkart eBooks App on your Windows Phone 8 devices from Store

Database Management System, Oracle SQL And PL/SQL

Paperback
Language: English
Length: 344 Pages
Publisher: Phi Learning
Rs. 250
Inclusive of taxes
Seller: WS Retail
Shop on the Flipkart App and get Free Delivery. Get it now
COMBO OFFER: Exciting combos available View combos
This item is Out of Print [?]
Shipping to: Change

Database Management System, Oracle SQL And PL/SQL (Paperback) Price: Rs.250

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.

Specifications of Database Management System, Oracle SQL And PL/SQL (Paperback)

Contributors
Author Das Gupta, Pranab Kumar
Book Details
Publisher Phi Learning
Publication Year 2009
ISBN-13 9788120339200
ISBN-10 8120339207
Language English
Binding Paperback
Number of Pages 344 Pages
Please note: All products sold on Flipkart are brand new and 100% genuine

Book Reviews of Database Management System, Oracle SQL And PL/SQL

4.8
Average Rating
Based on 5 ratings
Have you used this product?
Rate it now.

Most Helpful Reviews (5 of 10)

13 January 11
Balanced book ...

I came to know about the book from JNTU MCA syllabus. Borrowed the book from my friend and could not resist to have my own personal copy. Its now my companion. Simply fantastic book - specially concurrency control, hashing, query processing and pl/sql is superb. A must have book. Keep it up dasgupta and phi. Please add chapters on OODBMS and grid computing in revised edition.

Was this review helpful?  / 
2 of 2 users found this review helpful.
Rudranath Maitra
05 January 10
Extremely helpful book

The book is extremely helpful for the beginners and anybody could
use it as a reference book during their tough time. The way, Mr. Dasgupta has
explained the theoretical and practical concepts of DBMS by step-by-step and
defining Oracle SQL and PL/SQL with the real life examples shows his sincerity
regarding the reader. I have mostly attracted by the quiz session on key points
and the brain storming exercises that is inviting deeper analysis of the subject
matter.

1 of 1 users found this review helpful.
Edit     Permalink  
08 November 10
The 'certified buyer' badge indicates that this user has purchased this product on flipkart.com.
certified buyer
Good book for professionals

I read this book and got three job in a row. Good book which combines dbms, sql and pl/sql seemlessly. Must purchase at Rs 250.

Was this review helpful?  / 
3 of 3 users found this review helpful.
Purujit Kar
23 October 09
first to review
Easy to follow

After a long time, i got a book which is easy to follow in both theoretical and pracical concepts. I have scanned the book like a novel literally without any pause. The quiz and descreptive questions are also good. The best part is - the book contains solutions/ hints for all the question. Thank you PHI. Purujit

2 of 2 users found this review helpful.
Edit     Permalink  
Amit Kumar
05 November 09
Best book on DBMS and Oracle

This is a book where the author is concerned for the reader. The writing style is straight without any useless material. From page one till the last page, the same enthusiasm is maintained by the author. I recommend this book to all the average students who find DBMS tough. AMIT KUMAR

2 of 2 users found this review helpful.
Edit     Permalink  

Most Recent Reviews

View all
★★★★★
★★★★★
The 'certified buyer' badge indicates that this user has purchased this product on flipkart.com.
certified buyer
BEST BOOK FOR LEARNING ORACLE

This book is very comprehensive.....easy to understand.Everything is explain in details with examples.In a layman language it a...

Read More
23 November 11
Balanced book ...

I came to know about the book from JNTU MCA syllabus. Borrowed the book from my friend and could not resist to have my own pers...

Read More
13 January 11
The 'certified buyer' badge indicates that this user has purchased this product on flipkart.com.
certified buyer
Good book for professionals

I read this book and got three job in a row. Good book which combines dbms, sql and pl/sql seemlessly. Must purchase at Rs 250.

Read More
08 November 10
Rudranath Maitra
Extremely helpful book

The book is extremely helpful for the beginners and anybody could
use it as a reference book during their tough time. The...

Read More
05 January 10
Deepak Saxena
Good book on DBMS

In the book Chapters related to Normalization, Hashing, Concurrency control and Oracle PL/SQL is outstanding. Problem are real...

Read More
07 November 09
    Book: Database Management System, Oracle SQL And PL/SQL by Das Gupta, Pranab Kumar
    ISBN Number: 8120339207, 9788120339200, 978-8120339200

PAYMENT METHOD

POWERED BY
Loading ...