SQL Primer: An Accelerated Introduction to SQL Basics

Index

A

Access control

granting privileges to users

general syntax, GRANT

multiple privileges

PostgreSQL

relational databases

REVOKE command

SQLite

Aggregate functions

AVG

casting values, integers

COUNT

MAX and MIN

SUM

varchar value

Alpha

ALTER TABLE command

American National Standards Institute (ANSI)

The Art of SQL

Atomicity

B

Bitmap Heap Scan

Bitmap Index Scan

C

Check constraints

Compound queries

Concatenation operator

Constraints

check

NULL

SeeNULL constraints

primary key

relational databases

selective fields INSERT

unique key

CREATE USER command

Cross joins

D

Database and database administrators (DBA’s)

Database Management and Design

Database Management System (DBMS)

Data Control Language (DCL)

Data Definition Language (DDL)

Data Dictionary

Data Manipulation Language (DML)

DELETE command ...