ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

SQL (Structured Query Language) (ANSI) Test

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.



Scope Of The Online SQL (Structured Query Language) (ANSI) Test

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

Duration

40 minutes.

Assessment Method of Questions

Multiple choice questions

Each question has between 2 and 8 options out of which 1 or more may be correct.

More links

Related Professions

programmer, developer

Keywords

SQL ANSI base assessment test, clickatest, information technology, computers, IT industry