· Overview History Popular RDBMS

· Key Components & Operations Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Transaction Control Language (TCL) Data Query Language (DQL)

· Conventions

· Data Types Numeric Types String Types Date & Time Types Other Data Types

· Operators Math Comparison String Variables Comments Bitwise Miscellaneous Logical

· Operator Precedence

· Databases Creating a database Modifying a database Deleting a database

· Tables Creating a table Altering a table Deleting a table

· Table Indexes Creating an index Deleting an index

· Views

· DML Search Conditions Where From & Join Group By Having Order By Into Top

· SQL Statements Select Insert Update Delete Truncate Table