What IS RDBMS (SQL)

A Relational Database Management System (RDBMS) is an  advanced version of DBMS that also Defines the relationship between the various data Values. This Features Helps In Organizing and Accessing Data more efficiently than DBMS. Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd.

Posted By: Haxjer Hunt Saturday, 10 August 2013

0

Read More

SQL DML And DDL

Sql Dml And DDL Statement

Sql Can Be Divided Into Two Parts :-

1. The Data Manipulation Language (DML) .
2. The Data Definition Language (DDL) .

The Data Manipulation Language (DML) : Is Used to Manipulate The Data In The Database  Objects. Some of The DML Commands Are :-

• Insert : Used To Insert A New Data Record In A Table.
• Update : Used To Modify An Existing Record In A Table.
• Delete : Used To Delete An Existing Records In A Table.

The Data Definition Language (DDL) : Is Used to Define The Databases Data Types, Structures And Constraints on the data. Some Of The DDL commands Are :-

• Create : Used To Create A new Database objects, Such as a table.
• Alter : Used To Modify the database objects.
• Drop : Used To Delete The Objects.

Posted By: Haxjer Hunt

0

Read More

What Is Tables (SQL)

What Is Tables

• A Table Is A Collection of Related Data Entries And It Consists Of Coolumns And Rows. 
• A table has a specified number of columns, but can have any number of rows. 
• Each row is identified by the values appearing in a particular column subset which has been identified as a unique key index.

For example, an Employees table would contain the same basic details on each employee: name, title, department and so on. Each detail, each chunk of information you need to store lives in a field. When you view a single employee record, QuickBase displays it in a form. Whenever you want to view more that one record at a time, you do so in a table report, where fields appear as columns and each record is a row.

Posted By: Haxjer Hunt

0

Read More