Vishwajit Barbuddhe, Shraddha N. Zanjat, Bhavana S. Karmore

Relational Database Management System

Basic of Relational Database Management System

• Broschiertes Buch

Produktbeschreibung

The book contains: 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.

Produktdetails

• Verlag: LAP Lambert Academic Publishing
• Seitenzahl: 152
• Erscheinungstermin: 25. Februar 2020
• Englisch
• Abmessung: 220mm x 150mm x 10mm
• Gewicht: 244g
• ISBN-13: 9786200655066
• ISBN-10: 6200655065
• Artikelnr.: 58849990

Autorenporträt

Prof. Vishwajit Barbuddhe is currently working as Assistant Professor in Jagadambha College of Engineering & Tech., Yavatmal, having 11 Years of Teaching experience. He has published 45 research paper in International Journals & presented 6 research paper in International Conference. His area of interest is Digital Image Processing & networking.