Standard Naming Conventions for SQL Database Design
Naming Conventions is an important factors for any type of database design. It’s benefits are high. It makes a simple database generic for others. This article describes what standard should …
Category: Oracle
Difference Between Primary Key and Unique Key
In relational database system primary key and unique key are two important concepts. Both are used to uniquely identify a row in a table. Though both can identify a row …
How to make a Great Primary Key?
The primary key is in important factor for any relational database. It plays a vital role. It has numerous functionalities. On a table we can create a primary key in …
SQL Views
In SQL, a View is a virtual table that is generated based on a SQL statement. It has no own data, but it returns data from others table. This article …
Oracle Database
Oracle is a database management application or software. At present It is the leading RDBMS vendor worldwide. Currently nearly half of RDBMS worldwide market is owned by Oracle.This article is …
SQL Join
In a relational database, SQL join is a very important feature. SQL Joins are used to get data from other tables. It is a part of SQL query that retrieves …
What is Database Schema?
The database schema is the logical view of the entire database. It is a set of database objects (tables, views, functions etc.). This article describes about the database schema and …
What is Database Object?
The database objects are the core component for any database system. This help use to store and retrieve data easily. This article describes about basic overview of Database Object . Summary …
Relational Database Management System or RDBMS
Relational Database Management System is computer software/program that is developed based on relational model. At present most modern commercial and open-source database systems are using RDMS. This article explains what …
Database Management System or DBMS
DBMS is the process to store and retrieve information. This article describes about the basic overview of DBMS or Database Management System. Summary of the article: What is Database? What …