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) Fundamentals

Description:

Our Structured Query Language (SQL) (ANSI) Fundamentals test measures your knowledge of database queries using ANSI SQL. Designed for entry-level database programmers and administrators, this test covers the following topics: Aggregated Data Queries (GROUP BY), Data Definition Language (DDL), Data Modification, Limiting the Return Set, Multiple Table Queries (SELECT with Joins), Set Queries (UNION) Single Table Queries (SELECT), Transactions and Using Functions and Constant Values.

$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

Aggregated Data Queries (GROUP BY)
GROUP BY
HAVING
Sorting Aggregate Data
Data Definition Language (DDL)
Altering Existing Tables
Creating Indices
Tables
Views
Data Modification
DELETE
INSERT
UPDATE
Using Indices
Limiting the Return Set
Using Intermediate Predicates ( WHERE)
Using Simple Predicates to Limit Data ( WHERE)
Using WHERE in Multiple Table Queries
Multiple Table Queries (SELECT with Joins)
CROSS JOIN
FULL OUTER JOIN
INNER JOIN
LEFT/RIGHT OUTER JOIN
Set Queries (UNION)
Sorting Set Data
Using UNION
Using UNION ALL
Single Table Queries (SELECT)
Obtaining Table Data with SELECT
Sorting Data
Specifying Columns to Use with SELECT
Using DISTINCT to Eliminate Duplicates
Transactions
Understanding Concurrency Issues
Using COMMIT
Using ROLLBACK
Using Functions and Constant Values
Aggregate Functions
Scalar Functions
Using Constant Data