Skip to Main Content
SQL All-in-One For Dummies, 4th Edition
book

SQL All-in-One For Dummies, 4th Edition

by Allen G. Taylor, Richard Blum
April 2024
Intermediate to advanced content levelIntermediate to advanced
800 pages
18h 34m
English
For Dummies
Content preview from SQL All-in-One For Dummies, 4th Edition

Appendix B

Glossary

ActiveX control:
A reusable software component that can be added to an application, reducing development time in the process. ActiveX is a Microsoft technology; ActiveX components can be used only by developers who work on Windows development systems.
aggregate function:
A function that produces a single result based on the contents of an entire set of table rows; also called a set function.
alias:
A short substitute or nickname for a table name.
API:
See application programming interface (API).
applet:
A small application written in the Java language, stored on a web server that’s downloaded to and executed on a web client that connects to the server.
application programming interface (API):
A standard means of communicating between an application and a database or other system resource.
assertion:
A constraint specified by a CREATE ASSERTION statement (rather than by a clause of a CREATE TABLE statement). Assertions commonly apply to more than one table.
atomic:
Incapable of being subdivided.
attribute:
A component of a structured type or relation.
back end:
That part of a database management system (DBMS) that interacts directly with the database. See also database management system (DBMS).
catalog:
A named collection of schemas. See also schema.
client:
An individual user workstation that represents the front end of a database management system (DBMS) — the part that displays information on a screen and responds to user input. See also front end and database management ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL All-In-One For Dummies, 3rd Edition

SQL All-In-One For Dummies, 3rd Edition

Allen G. Taylor
SQL Essentials For Dummies

SQL Essentials For Dummies

Richard Blum, Allen G. Taylor
SQL in a Nutshell, 4th Edition

SQL in a Nutshell, 4th Edition

Kevin Kline, Regina O. Obe, Leo S. Hsu

Publisher Resources

ISBN: 9781394242290Purchase Link