SQL

Database

records

record’s attributes

metadata

database categories

Personal Database

Workgroup/Departmental Database

Enterprise Database

relational database

common key

Database Management Systems (DBMS)

types of users that work on DBMS

Schema

Domain

Constraint

Categories of SQL Command Types

Data Definition Language (DDL) commands

Data Manipulation Language (DML) commands

Data Query Language (DQL) commands

“Data Control Language (DCL) commands

Transactional Control Commands

Data types in SQL

numeric

string

date and time

Boolean