Cart (0)
Digital Cart (0)
Home  >  Database Management System, Oracle SQL and PLSQL...
Buy Database Management System, Oracle SQL and PLSQL (English): 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 PLSQL (English)

Author: DAS GUPTA
Paperback
Language: English
Length: 344 Pages
Publisher: Phi Learning Pvt Ltd
Rs. 1,290 23% Off
Rs. 992
Inclusive of taxes
COMBO OFFER: Exciting combos available View combos
Notify me when this product is in stock:
Email:
Out of Stock
This item is Out of Stock [?]
Shipping to: Change

Database Management System, Oracle SQL and PLSQL (English) (Paperback) Price: Rs.992

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 PLSQL (English) (Paperback)

Contributors
Author DAS GUPTA
Book Details
Publisher Phi Learning Pvt Ltd
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 PLSQL (English)

Have you used this product?

Rate it now.

TOP REVIEWS View All Top Reviews (1)

'Top Reviews' lists the most relevant product reviews only. Show ALL instead?
★★★★★
★★★★★
Ankur Shukla
23 Nov 2011
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 act as a guide for oracle.
This book helped me a lot in enhancing my oracle skills and prepared me to do better in professional world.

0 of 0 users found this review helpful.
    Book: Database Management System, Oracle SQL and PLSQL (English) by DAS GUPTA
    ISBN Number: 8120339207, 9788120339200, 978-8120339200

PAYMENT METHOD

POWERED BY
Loading ...