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
- 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
