What are Database Objects? (Part 1 of 2)
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.
