Advanced Data Management

• Constraints

• JOIN

• NULL

• UNION Clause

• Aliases

• Indexes

• Batch Processing Mode

• Views

• SCHEMA

• ALTER TABLE Statement

• TRUNCATE TABLE Statement

• Transactions

• Cursors

• Partitioned Tables

• Locks

• Anonymous Blocks

• Triggers

• Stored Procedures

• Materialized Views

• Subqueries

• Permissions

• Functions