Share this book with your friends

RELATIONAL DATABASE MANAGEMENT SYSTEM

Author Name: Prof. Vishwajit K. Barbudhe, Prof. Shraddha N. Zanjat, Dr. Bhavana S. Karmore | Format: Paperback | Genre : Educational & Professional | Other Details

Book contain    Database Concepts: A Relational approach: Database – Relationships – DBMS – Relational Data Model – Integrity Rules – Theoretical Relational Languages. Database Design: Data Modeling and Normalization: Data Modeling – Dependency – Database Design – Normal forms – Dependency Diagrams – De -normalization – Another Example of Normalization. Oracle9i: Overview: Personal Databases – Client/Server Databases – Oracle9i an introduction – SQL *Plus Environment – SQL – Logging into SQL *Plus - SQL *Plus Commands – Errors & Help – Alternate Text Editors - SQL *Plus Worksheet - iSQL *Plus. Oracle Tables: DDL: Naming Rules and conventions – Data Types – Constraints – Creating Oracle Table – Displaying Table Information – Altering an Existing Table – Dropping, Renaming, Truncating Table – Table Types – Spooling – Error codes. Working with Table: Data Management and Retrieval: DML – adding a new Row/Record – Customized Prompts – Updating and Deleting an Existing Rows/Records – retrieving Data from Table – Arithmetic Operations – restricting Data with WHERE clause – Sorting – Revisiting Substitution Variables – DEFINE command – CASE structure. Functions and Grouping: Built-in functions –Grouping Data. Multiple Tables: Joins and Set operations: Join – Set operations. 

Read More...
Paperback
Paperback 325

Inclusive of all taxes

Delivery

Item is available at

Enter pincode for exact delivery dates

Also Available On

Prof. Vishwajit K. Barbudhe, Prof. Shraddha N. Zanjat, Dr. Bhavana S. Karmore

Prof. V. K. Barbudhe working as Professor at Jagadambha college of Engineering and Technology for UG and PG Department of Electronics and Telecommunication Engineering  . Total Years of Experience 11+ . He publish more than 50+ Papers in International Journals . He work as International Expert at International Conferences . He worked as a Editorial Board Members in 15+ International Journals and Reviewer in 100+ International Journals and International Conferences . Project Guided 10+ PG students and 50+ UG Students  . He publish more than 140+ Books on Electronics and Computer Engineering Subject.

Read More...

Achievements

+4 more
View All