Essential Structured Query Language (ANSI SQL-99) six page laminated guide with core commands, statements, syntax and terms for support of beginners who are learning, and experts as a handy quick reference. Author Robin Nixon worked with computers in the 80s and started developing websites in the 90s becoming an expert and writing over 40 programming books and over 500 articles for top computer magazines. With his expertise in the field and writing to his audience in our succinct and organized QuickStudy format, this reference has more quality actionable facts per page than any book or website. Designed for quick access to the facts you need, this inexpensive tool has been a best seller for over 10 years and is an easy add to your programming toolbox. 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