Essential SQL Knowledge at a Glance
Keep essential Structured Query Language concepts, commands, syntax, and terminology close at hand with this practical six-page laminated reference guide.
Designed as a convenient quick-reference resource, this guide provides a structured overview of essential ANSI SQL-99 concepts for people learning SQL as well as experienced users who need a fast way to check commands and terminology while working.
Instead of searching through lengthy books or online documentation for a specific command, users can quickly locate important SQL concepts across clearly organized sections covering databases, tables, queries, data types, operators, statements, and more.
Key Areas Covered
- SQL overview, history, and popular relational database management systems
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
- Data Query Language (DQL)
- SQL conventions and terminology
- Common numeric, string, date, time, and other data types
- Mathematical, comparison, string, logical, bitwise, and miscellaneous operators
- Operator precedence and usage
Database & Table Management
- Creating databases
- Modifying databases
- Deleting databases
- Creating and altering tables
- Deleting tables
- Creating and deleting indexes
- Working with views
Queries & Data Operations
- Search conditions
- WHERE clauses
- FROM and JOIN operations
- GROUP BY and HAVING
- ORDER BY
- INTO and TOP
- SELECT, INSERT, UPDATE, and DELETE
- TRUNCATE TABLE
A Practical SQL Reference for Everyday Use
The compact laminated format makes this reference especially useful beside your computer while studying, practicing database development, writing queries, or reviewing programming concepts. Its organized layout is designed to make frequently needed information easier to locate.
Suitable For
- SQL beginners and students
- Programming and computer science learners
- Database development students
- Web and software developers
- Experienced programmers needing a quick reference
- Anyone looking for a compact SQL study and workspace companion
With its concise organization and broad coverage of essential SQL concepts, this laminated reference is a useful addition to any programming, database, or development toolkit.
