QUICKSTUDY: SQL PROGRAMMING LANGUAGE

Description

6 page laminated reference Includes:

• 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

DDL

• 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