Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

SQL (ANSI) 2011 Fundamentals

Description:

Our SQL (ANSI) 2011 Fundamentals test measures your knowledge of database queries using ANSI SQL. This test is based on the 2011 ANSI standard. Designed for entry-level database programmers and administrators, this test covers the following topics: Aggregates and Sets, DDL and DCL, Data Modification, Multi-Table Queries, Queries, SQL/PSM, Transactional Control, and Tuning and Debugging.

$49.95

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Aggregates and Sets
ANY, ALL, IN, EXISTS, UNIONS
GROUP BY
HAVING
NULLs
Data Modification
DELETE
INSERT
UPDATE
View Data Update
DDL and DCL
Access Rights
Indexes and Constraints
Tables and Table Structure
Triggers
Views
Multi-Table Queries
INNER JOIN
OUTER JOIN
Self Joins
Queries
Access to Table Data
Dataset Windows
Equality Predicates
Filtering and Sorting
Scalar Functions
Subqueries
SQL/PSM
Cursors
Exception Handling
Flow Control
Variables
Writing SQL Modules
Transaction Control
Beginning Transactions
Ending Transactions
Nested Transactions
Savepoints
Tuning and Debugging
Explain Statements and Plans
Improving Query Performance
Resolving Query Errors