Relational Database Management System

Vishwajit Barbuddhe

ISBN 10: 6200655065 / ISBN 13: 9786200655066

Published by LAP LAMBERT Academic Publishing Feb 2020, 2020

About this Item

This item is printed on demand - it takes 3-4 days longer - Neuware -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. 152 pp. Englisch.

Seller Inventory # 9786200655066

Bibliographic Details

• Title: Relational Database Management System
• Publisher: LAP LAMBERT Academic Publishing Feb 2020
• Publication Date: 2020
• Language: English
• ISBN 10: 6200655065
• ISBN 13: 9786200655066
• Binding: Taschenbuch
• Condition: Neu

About this title

Synopsis

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.