Resources‎ > ‎

SQL

This will show the different areas of SQL and Database information. 

Standard SQL Statements
Area
Description
DDL Statements
Data Definition Language (DDL) statements are used for managing data objects.
DML Statements
Data Manipulation Language (DML) statements are used for managing data within schema objects. These statements do not implicitly commit the current transaction.
SQL Functions
SQL functions are built into the database and are available for use in various appropriate SQL statements. Do not confuse SQL functions with user-defined functions.
Data Types
Definition of the data types that are used within the database structures.

Database SQL Programming
Area
Description
Concepts

Structure
 
Variables
 
Constants
 
Records
 
Conditional Statements
 
Iterative Statements
 
Cursors
 
Procedures
 
Functions
 
Exception Handling
 
Triggers
 
External Coding
 
  




* Database's are listed in alphabetical order and not by importance or market share.