SQL Programming

By: Robin Nixon

Write A Review

Fold-Out Book or Chart | 1 November 2024 | Edition Number 2

At a Glance

Fold-Out Book or Chart
6 Pages

Dimensions(cm)
21.6 x 28 x 0.3

Fold-Out Book or Chart

RRP $19.99

$18.75

or 4 interest-free payments of $4.69 with

Ships in 5 to 10 business days

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

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.