Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books! Seller Inventory # OTF-S-9781423238799

Contact seller

Report this item

Bibliographic Details

Title: SQL Programming: QuickStudy Laminated ...

Publisher: QuickStudy Reference Guides

Publication Date: 2024

Condition: New

Edition: 2nd Edition

About this title

Synopsis:

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