SQL (ANSI)

Test Outline

Aggregates and Sets
ANY, ALL, IN, EXISTS, UNIONS
GROUP BY
HAVING
NULLs
Complex Queries
Dataset Windows
Pipelined DML
Scalar Functions
Temporal Features
XML Features
DDL and DCL
Access Rights
Indexes and Constraints
Tables and Table Structure
Triggers
Views
Data Modification
DELETE
INSERT
UPDATE
View Data Update
Multi-Table Queries
FULL OUTER JOIN
INNER JOIN
LEFT/RIGHT OUTER JOIN
Self Joins
Queries
Access to Table Data
Constants and Comments
DISTINCT
Equality Predicates
Filtering and Sorting
SQL/PSM
Cursors
Exception Handling
Flow Control
Variables
Writing SQL Modules
Subqueries
Correlated
Row Deletion
Single Value
Subquery Based Updates
Transaction Control
Beginning Transactions
COMMIT
Nested Transactions
ROLLBACK
Savepoints
Tuning and Debugging
Explain Statements and Plans
Improving Query Performance
Recognizing Full Table Scans
Resolving Query Errors

 

Go Back