Online Data Modeling Training
Learn data modeling design Skills on OLTP and OLAP from a US University Professor with real time examples.
Read More
Oracle’s Database Dictionary Views
These SQL commands are related with Oracle’s data dictionary and can be used to get information about different database objects.
Oracle important DDL Statements
important DDL Statements from Oracle like Commit, Rollback, Grant, Revoke etc..
Oracle Database Data Definition Language(DDL Statements)- DROP Object Commands
In this section, we will try to explain about important database DROP commands that are used by a data modeler by relating it with our example data.
Oracle Database Data Manipulation Language (DML) Commands
In this section, we will try to explain about important database DML commands that are used by a data modeler.
Oracle Database Data Definition Language(DDL Statements) – ALTER Commands:
In this section, we will try to explain about important database ALTER commands that are used by a data modeler by relating it with our example data.
Oracle DDL Statements – CREATE Commands
An Oracle database consists of DDL commands, which are useful to create, modify and drop the database objects. In this section, we will try to explain about important database CREATE commands that are used by a data modeler by relating it with our example data.
Database: Sample Data
With a simple example of designing a data model with “employee related information”, most of the data structures can be easily understood. So we will try to design a data model using the sample data given below and will explain the data modeler’s involvement in the database environment.
Oracle Database Objects Overview
A database can have many schemas; one schema can contain multiple database objects like tables, views, Synonym etc.