SQL
- Structured Query Language
- Comprehensive relational database language
- Used for data manipulation and queries
- Requires ACID transactions
Math Operations
- Operations are incorporated in an algebra defined for accessing and manipulating data
- The operations:
- Select
- Identify records in a table
- Project
- Product a subset of the columns in a table
- Cartesian product
- Concatenate rows from two tables
- Union
- Difference
- Intersection
- Natural join
- Division
- Select