Data Modeling and Database Tutorial | Oracle Database Commands

You are here: Home Database & Data Modeling Tutorial

Database & Data Modeling Tutorial:

In general, Data Models are created at the very beginning of any project development life cycle. Since data models are a better resource for understanding the business flows and the data relationships, it becomes a mandatory rule for the data modeler(or the data modeling team) to create a flawless data model by carefully observing the business rules and the requirements. From data model, the data structures are transformed into a more meaningful form and finally stored in the database, thus enabling one to retrieve data for analysis/reporting purposes. Any changes to data model must be carefully directed to and should successfully be implemented on the database almost immediately. At any point of time, data modelers and the database administrators should be in exact terms in communicating the changes.

Alternatively, though not very often, the data modelers are required to create data models based on the existing database due to many factors like analyzing and locating the flaws in the current business relationships, may be the organization is going for a major business change etc.

Thus, it is important for the data modeler to be have a thorough knowledge of any database access/query language to become a successful data modeler.

Here in this Data Modeling and Database tutorial section helps to understand the basics of Data Definition Language (create, alter, drop), Data Manipulation Commands (insert, update, delete, select), Transaction Control Commands (Grant, Revoke) and data dictionary commands that are used by a data modeler for implementing the data model in an oracle database.

With CREATE commands, learn how to create tables, sequences, triggers, indexes, views, synonyms, primary keys, foreign keys, copy tables with data, copy tables with no data.
With ALTER commands, learn how to add/rename columns, modify datatypes, add unique/check constraints, modify/disable/enable/drop constraints.
With DML commands, learn how to insert records, delete records and update values in records. By using select statements, learn how to select records with/without where clause, with group by clause, with having clause, distinct records, count of all records etc.
With DROP commands, learn how to drop index, synonyms, views, sequences, trigger, tables.

Browse through the following links to read more.

Database Overview