March 23rd, 2009

What are Database Objects? (Part 1 of 2)

Posted by admin in O. Database Objects

Database objects are tables, views, schemas, catalogs, clusters, and other objects required by your RDBMS system.

Database clusters contain catalogs.

Catalogs contain schemas.

Schemas contain tables and views.

Tables and Views contain
columns and rows.
As discussed earlier under SQL is DML, DDL, & DCL, there are three components to the SQL language:

Data Manipulation Language (DML) is the part of SQL that retrieves and updates the database tables.
This includes the SELECT, INSERT, UPDATE, and DELETE commands discussed previously.

Data Definition Language (DDL) is the part of the SQL language used to define and maintain database objects.
This includes the CREATE, ALTER, and DROP commands used in this part of the course.

Data Control Language (DCL) is used to provide security for your database.
This includes the GRANT and REVOKE commands discussed later.

Comments are closed.

Sorry, the comment form is closed at this time.